Search code examples
sql-serverasp-classic

CLASSIC ASP - SQL Server does not exist or access denied

I'm trying to make a connection to a SQL Server Express DB on localhost, but I get the following error message:

Microsoft OLE DB Provider for SQL Server (0x80004005)

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

The code I'm using is

Dim connection 
Set connection = CreateObject("ADODB.connection") 
connection.connectionString = "server=localhost;Provider=SQLOLEDB;Data Source=RiskManagement;Initial Catalog=RiskManagement;User ID=sa;Password=myPass;" 
connection.Open()

Any ideas?

Solution

  • First thing to always check is that you have configured SQL Server to allow remote connections.

    How to configure SQL Server 2005 to allow remote connections

    For generic SQL Server Connectivity Troubleshooting consult the following Blog Post