Hi. i run a classic asp app. connecting to sql server with: g_objconn.Open "Provider=SQLOLEDB;Server=myServerName;Database=myDBName;Uid=myIdName;Pwd=password"everything was just fine untill few days ago.im not sure if it started because Traffic increase. anyways, i started to get this error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. ill appreciate some help. thanks !
1 of 2 possible scenarios here: 1) You (or someone else) changes your login credentials to the SQL server. To verify, try to log into the SQL server using the credentials you use in your website. 2 2) Your SQL server no longer exists or the name has been changed. Assuming you've made NO changes, scenario 1 is most likely the culprit: somebody changes the server's SQL password.
Cause # Integrated security is enabling in the SQL Enterprise Manager and Microsoft Windows NT account that is being used or may be not mapped in SQL Account The User ID in the connection String is invalid Resolve # Right Click the SQL Server name that appears in the Server Manager window and Click the Properties then Click Security Options and then Click Standard and Windows so the Password option is disable for that Project.