MSSQL - NOTES, ((working on))
Posted: Mon Nov 09, 2009 10:35 am
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
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