SQL Server Connection string?
Okay, this is doing my nut in today..
I'm doing a little test script to test a new sql server we've got installed here, fairly basic stuff, but for some reason it absolutely refuses an ASP connection..
Code:
strCon = "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=mydatabase;" & _
"User ID=blah;" & _
"Password=blah"
That's my connection string, which fails with:
Quote:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
If I use this connection string:
Code:
strCon = "Provider=sqloledb;" & _
"Data Source=MyDBServer;" & _
"Initial Catalog=Mydatabase;" & _
"User Id=blah;" & _
"Password=blah"
I get the error:
Quote:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'blah'. Reason: Not associated with a trusted SQL Server connection.
Now I've read through things and it suggests that the problem lies with having a windows only authentication setting, and to change it to SQL Server & Windows instead, but the system is already configured to SQL Server & Windows authentication..
Yet I can easily connect to the database using aespe Table Browser, which uses virtually the same connection method..
Any ideas?