I am pretty sure that my conn string is correct. I even tried using a dsn instead of the dsn-less string and got a similar error.
/DentalConsent/login.asp, line 12
It must be a permissions issue. I did add the iuser account and gave it access to all actions (write, read etc...).
My error is 'Login failed' but I am using windows authentication (no uid/password).
the closest error in the link provided is as follows:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Cannot open database requested in login 'user_id'. Login fails.
This can occur if you use a valid user name in your connection string, but specify a database that user cannot access. Typically, this is because a user's default database is unavailable for verification (and this is a necessary step in the verification handshake). This can be because the default database is in single user mode, is offline, has been detached, or this user has been explicitly removed from their default database.
I dont understand how to resolve this.
I can't figure this out