February 10, 2009 at 12:00 pm
hi,
I gave db_reader to few logins and those logins (users ) ,I can see them in the database but still they are not able to access the database
I have checked everythingand everything is fine .I have ran sp's too
and all ran successfully
exec sp_addrolemember 'db_datareader', '******';
exec sp_addrolemember 'db_datareader', '******';
but still they dont have access..
Can anyone help me how to figure out thr root cause /..
Thanks,
Kiran.
February 10, 2009 at 12:06 pm
What is the error that they get when they connect?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
February 10, 2009 at 12:38 pm
login camplained me this..
when I open my server login properties and view "User Mapping" I get the message "One or more databases are inaccessible and will not be displayed in the list"
February 10, 2009 at 1:00 pm
Now its working.
I have droped the user and recreated
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply