Post reply

Security VIMP

  • February 10, 2009 at 12:00 pm

    #201062

    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

    #941532

    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

    #941558

    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

    #941572

    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