September 30, 2010 at 12:12 pm
Error:
System.Data.SqlClient.SqlException: Cannot open database "WebData" requested by the login. The login failed.
Now this should be simple...
A) checked DB Logins and login SFCC\Staff and Faculty exists and has permissions to the DB Server.
B) check actual DB permissions: user is set to DB Reader permissions, and execute on several of the stored procedures.
so what am I missing? feeling I'm missing something small stupid (on my part)....
September 30, 2010 at 12:18 pm
This login is linked to a user in that database, correct? Verify that. The name being the same does not mean they are linked.
September 30, 2010 at 12:20 pm
The users may be orphaned - did you recently restore the database from a backup?
Run this query -
EXEC sp_change_users_login 'Report'
If the logins show up on the list, run
EXEC sp_change_users_login 'Auto_fix', <username_to_fix>
and see if that resolves the issue.
September 30, 2010 at 12:20 pm
yes the Staff and Faculty database user is linked to the SFCC\Staff and Faculty DB Server User.
September 30, 2010 at 12:22 pm
exec sp_change_users_login 'Report'
generates an empty list of Username/UserSID
September 30, 2010 at 12:22 pm
no restore.
September 30, 2010 at 1:13 pm
wondering if it was partially AD. I can get in but can't select out of a specific table. this account has datareader permissions.... can't read?
October 1, 2010 at 9:39 am
Well, the database could still have per-table permission settings - You might wanna check that. Also, is there more than one schema at play here?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply