How to change the password of a SQL Server login
(Enterprise Manager)
To change the password of a SQL Server login
- Expand a server group, and then expand a server.
- Expand Security, and then click Logins.
- In the details pane, right-click the login to modify, and then click Properties.
- In the Password box, on the General tab, enter a new password.
- Confirm the password.
Follow the steps below to reset the "SA" password if you have forgotten what it was set to:
Step 1: * Go to the server that SQL Server is running on. * Open Enterprise Manager(Start -> Programs -> Microsoft SQL Server) * Right click on the SQL Server and select "Edit SQL Server Registration Properties" * Select "Use Windows authentication" and select OK.
Step 2: * Once connected, select Security * Right click on sa and select properties * Reset the password.
0 comments:
Post a Comment