reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia

How to reset MSSQL sa user password with Enterprise Manager [1/1]

Type: Picture reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia
How to reset MSSQL sa user password with Enterprise Manager
Level: Beginner reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia 
How to reset MSSQL sa user password with Enterprise Manager
Date: 2007-Apr-07
How to reset MSSQL sa user password with Enterprise Manager
Visited: 1811 times
How to reset MSSQL sa user password with Enterprise Manager
Rating: How to reset MSSQL sa user password with Enterprise Manager
How to reset MSSQL sa user password with Enterprise Manager
Author: Stephen Think
This tutorial will show you how to change/update/reset the password on the 'sa' account from the graphical interfaces of MSSQL Server 7.0 and 2000 or MSDE.

Start by opening the Enterprise Manager. This is usually located here:
Start -> Programs -> Microsoft SQL Server, but your software may be configured differently.

Starting with MSSQL , the SQL Server Enterprise Manager is a snap-in for the "Microsoft Management Console" (mmc.exe). Check the Microsoft documentation if you are unsure how to use this application.

Navigate to the Logins object under the Security folder on the SQL Server you wish to administer. Then, right click on the sa account and select Properties or simply double click on it. An new dialog box will open. Now, enter a new password in the Password field under the Authentication options.
All left is to click OK.

Rate this tutorial:                    
reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia - How to reset MSSQL sa user password with Enterprise Manager [1/1] - reference, tutorial, tutorials, help, example, photoshop, html, php, mysql, 3d software, internet, graphics, programming, multimedia

Need a specific tutorial? Do not hesitate and submit a request!
Keywords: remote desktop port  change remote desktop port  rdp port number  remote desktop port number  RDP port  function overloading in c++  change RDP port  exception handling in C++  rdp ports  remote desktop ports  function overloading  Trillian webcam  remote desktop port change  windows remote desktop port  remote desktop change port  exception handling c++  how to change remote desktop port  change remote desktop port number  function overloading c++  check my windows version