Updated September 15, 2017 Click the Windows “Start” button and select “Programs.” In the menu labeled “SQL Server,” select “SQL Server Management Studio.” Enter a username and password to access the SQL Server. The username and password needs to have elevated administrative rights. You can also enter the SA password if you are just doing a maintenance reset of the administrative credentials. Click the “Security” icon under the database section on the left side of the window. This expands the director and shows a list of users configured on the server. In this list, SA is also displayed. Right-click the “SA” user account. In this window, enter a new password in the labeled text box. Passwords for SA should be alphanumeric with special characters and at least 10 characters long. Click the “OK” button and close the configuration window. If you are logged in as SA, you will not need to use the new password until you reconnect to the server at a later time. Writer Bio
