I setup a SQL Server 2005 database on my local machine and I'm trying to access it via classic ASP. I setup a DSN and tested the connection and it works. However, whenever I try to use it, I get a "login failed" message. Also, if I try to connect without DSN I get a similar message. Below are the exact strings I've tried an the corresponding messages. Please help!
'Connection String via DSN
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "myherbalharmony" requested by the login. The login failed.
'Connection String non-DSN
Conn.Open "Provider=SQLNCLI;Data Source=USERE3A8\SQLEXPRESS;Initial Catalog=myherbalharmony; Integrated Security=SSPI"
Microsoft SQL Native Client (0x80004005)
Cannot open database "myherbalharmony" requested by the login. The login failed.