G
glbdev
I can't seem to create a connection string to my SQL Server 2005
Express with windows authentication using classic ASP
This is my current string:
sConnStr = "Provider=sqlNCLI;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MyDatabase;Data Source=MYSERVER\SQLEXPRESS"
I got this string from a search but still can't make it work.
Here's the error I get:
Error Type:
Microsoft SQL Native Client (0x80004005)
Cannot open database "MyDatabase" requested by the login. The login
failed.
Thanks,
Gary
Express with windows authentication using classic ASP
This is my current string:
sConnStr = "Provider=sqlNCLI;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MyDatabase;Data Source=MYSERVER\SQLEXPRESS"
I got this string from a search but still can't make it work.
Here's the error I get:
Error Type:
Microsoft SQL Native Client (0x80004005)
Cannot open database "MyDatabase" requested by the login. The login
failed.
Thanks,
Gary