Thursday, March 29, 2012

Granting consultant access to database

Hi,
I need to grant a consultant access to one database on an sql server.
I do not want to give him remote access to the server.
I have installed the client tools (Enterprise manager) on his laptop.
I put him in Users and made him db_admin.
However, when he connects to the server and clicks on the tables it says he
is an invalid user error 916.
Any ideas how i can do this so its most secure. He needs to examine the
tables on the server. The SQL server is 2000.
ThanksRoberto,
Something that you might check. If you ran sp_grantdbaccess to make your
consultant a user in the database, that does not prove that he has access to
the server. You may also need to:
EXEC sp_grantlogin 'Corporate\BobTheConsultant'
If that is OK, then you should also check that the default database of his
login is a database to which he has access. The 'not a user' may come from
the default database.
RLF
"Roberto R" <RobertoR@.discussions.microsoft.com> wrote in message
news:BE654755-B958-48AB-9B5A-BCF215916729@.microsoft.com...
> Hi,
> I need to grant a consultant access to one database on an sql server.
> I do not want to give him remote access to the server.
> I have installed the client tools (Enterprise manager) on his laptop.
> I put him in Users and made him db_admin.
> However, when he connects to the server and clicks on the tables it says
> he
> is an invalid user error 916.
> Any ideas how i can do this so its most secure. He needs to examine the
> tables on the server. The SQL server is 2000.
> Thanks

No comments:

Post a Comment