SQL 2005 Linked server showing more than 1 database in catalog

Posted on 2009-05-01
Last Modified: 2012-06-27
Hi experts - added a new linked server in a SQL2005 instance so that developers could read from the tables on another instance.  Security credentials are setup to use a remote login which has been created on the server and tests ok.  The remote login only has READ access to one database on that particular instance.

The issue is that on the instance where the linked server was created if you expand the catalog section - it shows 2 different databases as being able to be browsed using this linked server.  I cant see any login for the 2nd database that is not required and would ideally like to remove it so that only the database that the developers are supposed to have access to show up there.  

Anyone got any ideas why this is happening?
Question by:BravehearT-1326
    LVL 9

    Accepted Solution

    make sure that the login on the remote server doesn't have the "view any database" permission at the server level.


    Author Closing Comment

    Many thanks - worked a treat. :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now