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