ASP SQL Native Connection to SQL Express Server
Posted on 2012-03-31
I am trying to connect to a SQL database on another file server, but receive an error when I run the ASP:
Microsoft SQL Native Client error '80004005'
Cannot open database "pbsdata" requested by the login. The login failed.
/odbc/test_xdbc.asp, line 10
The asp page is:
'On Error Resume Next
conn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=pbsdata;Data Source=profish-app01\SQLExpress"
If conn.State = 1 Then
If db <> 0 Then
I had created the connection string by creating a udl file, and then cutting and pasting the connection string from notepad. When I test the UDL file, the test connection works.
The ASP page is located on a Windows 2003 Server Service Pack 2
Any help would be greatly appreciated.