Breaking News
Loading...
Monday, 20 July 2015

Info Post

How to change the password of a SQL Server login 

(Enterprise Manager)

To change the password of a SQL Server login

  1. Expand a server group, and then expand a server.
  2. Expand Security, and then click Logins.
  3. In the details pane, right-click the login to modify, and then click Properties.
  4. In the Password box, on the General tab, enter a new password.
  5. 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