Thursday, March 8, 2012

Changing SA password in SQL Server 2005

How do you change the SA password in SQL Server 2005?

Thanks.


Doug

I set up a .UDL file and am trying to test a connection to SQL Server 2005 using the sa account.

I know this is bad, but I'm simply running a test for now in that I need to run some batch files to install a database to SQL Server 2005...

When I right click on the sa account under the Object Explorer: Server Name->Security->Logins->Properties.

I am trying to change the password by clicking General under the Select a Page section of the Login properties window.

However, when I test the connection in the UDL, I get an error saying:

----------------------

Test connection failed because of an error in initializing provider. Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

----------------------

This is nuts.

No comments:

Post a Comment