RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

RESET "SA" PASSWORD (SQL SERVER)

RESET "SA" PASSWORD (SQL SERVER)


USE MASTER

comando :

sp_password @ old = null, @ new = 'complexpwd', @ loginame = 'sa'
go 

 

Altro modo:
http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html

How to resetting the sa password on SQL Server

Yousef_Alahmad (IT Manager) posted 2/24/2010 | Comments (0)
When creating a new SQL user or changing an existing user with the SQL Server Management Studio, you'll need do run a few queries to get around the default expiration policies:


ALTER LOGIN [user] WITH PASSWORD='pa$$w0rd' UNLOCK
ALTER LOGIN [user] WITH CHECK_EXPIRATION=OFF
ALTER LOGIN [user] WITH CHECK_POLICY=OFF

Categoria: Sql Server ALL
giovedì, 08 apr 2010 Ore. 17.09

Messaggi collegati


Statistiche
  • Views Home Page: 455.090
  • Views Posts: 869.031
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003