Post reply

separating linked servers

  • December 2, 2008 at 9:11 am

    #154974

    Any help is greatly appreciated as I set up a new instance of SQL 2005.

    I have 2 groups of sql developers, each with different needs. One group needs to connect to a remote production database, and they do this with a linked server, where they specify a SQL username/password to this server.

    The other group should not have access to this remote production database, but since they have access to my SQL instance, they can access the linked servers (using the SQL username/password stored in the linked server connection) and connect to the remote production database.

    Is there a way to keep these two group separated, so that they cannot see the linked servers? Or force the other group to be prompted for the password to the linked server every time they need to connect?

    Thanks so much!

  • December 2, 2008 at 9:39 am

    #906308

    Hi,

    Linked Server Local Login is mapped to the remote login.

    How is your linked server logins are set up?

    I would create 2 Windows Global (or server local) groups, add developers to these 2 groups and add these 2 groups as 2 SQL Server logins. After that in Linked Server Properties Security tab add just one group with the proper remote login and click the checkbox that says that for the login NOT defined above, the connection "Not be made"

    Regards,Yelena Varsha

  • December 3, 2008 at 9:50 am

    #907003

    thank you!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply