Sa password forgotten how to do

Category: MS-SQL Server -> Foundation Classes Author: yc414043181 Date: 2008-06-06 19:37:16
 
yc414043181
2008-06-06 19:37:16
RT, thank you!
aminiamini
2008-06-06 19:47:29
Enterprise Manager to enter through Query Analyzer execute: EXEC sp_password NULL, 'Your new password', 'sa'

If you are under NT (including 2000) install of SQL Server, you can do this:

directly open the "Query Analyzer" (note not from " ; Enterprise Manager "to enter, from the Start menu program group in, if you can not find it, directly in the" Run ", type" isqlw.exe "also);

Select "Windows Authentication" to enter, no password is required, as long as you are the system administrator or the local domain administrator, then SQL Server automatically become an administrator;

In the Query Analyzer window, enter the following statement directly change the SA password:

sp_password Null, \ 'ok \', \ 'sa \'

after running the sa password becomes "ok" sp_password stored procedure function is to change the SQL Server login password;

syntax: sp_password [ [@ old =] \ 'old_password \',] {[@ new =] \ 'new_password \'} [, [@ loginame =] \ 'login \'] Parameter Description [@ old =] \ 'old_password \': old password; [@ new =] \ 'new_password \': To specify a new password [@ loginame =] \ 'login \':

user to specify the return value: 0 (success) or 1 (failure) The key principle is that the above method, from the "Query Analyzer" in order to "Windows Authentication "Connect SQL Server,

as long as you are the system administrator or the local domain administrator, then automatically become the administrator of SQL Server.
lcuandlc2
2008-06-06 20:01:28
use windows authentication and other modifications into the sa password
truthq
2008-06-06 20:16:01
go after using WINDOWS identity with EXEC sp_password NULL, 'Your new password', 'sa' ;
t448711090
2008-06-06 20:35:12
 -> -> sa -> -> -> 
xuwangx2010
2008-06-06 20:42:43


UP
miaosen
2008-06-06 20:57:13
windows can not get in, at establish a connection to the server error. Default settings sql server does not allow remote connections may cause this to fail. error26-locate the specified server instance error
ZHSTWJ
2008-06-06 21:10:13
heard that modifying the registry can be achieved. . . .
sia23
2008-06-06 21:49:19
systems, etc. do not go up. . . . .
m65561986556198
2008-06-06 22:11:01
System Noto, previously forgotten password authentication can login window, not now, and error as
chchchchch
2008-06-06 22:45:19
in establishing a connection with a server error. Default settings sql server does not allow remote connections may cause this to fail. error26-locate the specified server instance error

mzstar1
2008-06-06 23:07:10


landing, View Log option is not specified, the network protocol TCP / IP
ooo1212121
2008-06-06 23:43:03
Login Options? Where
lkswoniu
2008-06-07 00:12:20
Noto, the security status of the sa user in front of a red vertical line, the state also modifies not
wubo8265114
2008-06-07 00:43:30
Message 15118, Level 16, State 1, Line 1
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
wangliang123825
2008-06-07 01:14:37
bit more complex to set the password numbers, letters, punctuation

A3.23 '@ # ¥%
moonchild87
2008-06-07 01:54:31
not complex enough.
wn69503914
2008-06-07 02:24:50
the user is not associated with a trusted sql server connection
error 18452
bbtflhmx
2008-06-07 03:03:02
Remote Desktop server is not what you,

Log in to the server machine, then the administrator login sqlserver Enterprise Manager to change
ldmcl
2008-06-07 03:19:10
Learn about the next

Page 1 of 2    «  »