Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 How to retrieve userid and pwd of sql server

Author  Topic 

vineetc_25
Starting Member

1 Post

Posted - 2007-10-17 : 01:17:35
I am writing a VBscript which takes my machine details and put in the SQL database.

But after executing the script , i got the following error: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I dont remember the password I have given during installation.
Please tell me how to get the password of sql server.

Kristen
Test

22859 Posts

Posted - 2007-10-17 : 01:36:21
Log onto the server as an administrator. Start SSMS (i.e. ON the server). Change the password of SA.

This won't work if Administrator group has been removed from SQL Server

Kristen
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-18 : 23:22:35
Or try connect with windows authentication.
Go to Top of Page
   

- Advertisement -