Steve Brown
asked on
Migrated SQL connection issues 2012
Having migrated an SQL Database from 2000 to 2012, via 2008, I can't connect,
I have set the permissions, applications pool settings but i keep getting the following error...
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/adoconnectiontest.asp, line 16
VBS Code in an asp page....
oConn5.connectionString = "Provider=SQLOLEDB; Data Source=SHA14; Database=SHA; User Id=nbod; Password=password"
I have set the permissions, applications pool settings but i keep getting the following error...
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/adoconnectiontest.asp, line 16
VBS Code in an asp page....
oConn5.connectionString = "Provider=SQLOLEDB; Data Source=SHA14; Database=SHA; User Id=nbod; Password=password"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi BiG Monty, thanks for your help. Think I;ve solved it.
I needed the server instance name as part of the server address
eg Server=192.168.10.243/SHAS QL;Databas e=SHA
I needed the server instance name as part of the server address
eg Server=192.168.10.243/SHAS
Were you using a DSN connection before?
did that work? or do you want to look into DSN connections, which I think you had before?
ASKER
oConn5.connectionString = "Provider=SQLNCLI11;Server
I get a different error now...
Microsoft SQL Server Native Client 11.0 error '80004005'
Named Pipes Provider: Could not open a connection to SQL Server [2].