MSSQL - NOTES, ((working on))

Post Reply
Leo
Site Admin
Posts: 886
Joined: Thu Dec 11, 2008 7:52 am

MSSQL - NOTES, ((working on))

Post 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
Post Reply