Page 1 of 1

MSSQL - NOTES, ((working on))

Posted: Mon Nov 09, 2009 10:35 am
by Leo
MSSQL server service manager
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe - is the server service manager ( Computer with green arrow in task bar)

How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition
http://support.microsoft.com/?kbid=322336


Scans the network for SQL instances?
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql -L


Is the sa password blank?
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql -U sa
for the password just hit enter, If >1 comes back its BLANK


To connect by using Windows authentication and change the password
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql -E
or
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql -S copied_servername -E
1> sp_password NULL,'new_password','sa'
2> go
3> exit