Unwanted database showing in 'Linked Servers' catalogs list

  • webrunner

    SSC-Dedicated

    Points: 30310

    Hello experts,

    I've created a remote login and a linked server and granted what I thought were the correct permissions to two databases on the remote server.

    However, when I open up the linked server, I see an additional database listed. That is a real database on the same remote server, but I don't see where I would have added it to the linked server configuration. I checked the remote login and it does not have anything checked in the User Mapping screen.

    At the same time, it doesn't show any Tables or Views, so it seems like a stray public or guest permission that somehow has this database in it.

    Does anyone know where linked server catalog/permission data is stored so I can see why this database is showing, and how I can remove the remote login's permissions to it?

    Thanks for any help.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Sue_H

    SSC Guru

    Points: 90701

    If the guest account is enabled in those databases, that's one thing that would allow those databases to show.

    Sue

  • webrunner

    SSC-Dedicated

    Points: 30310

    Thanks, Sue, that was it!

    I'm going to review our guest accounts to make sure no inappropriate ones are enabled or have connect permissions.

    I disabled guest for the database in question with this command:

    REVOKE CONNECT FROM guest
    GO

    https://blog.sqlauthority.com/2012/02/20/sql-server-disable-guest-account-serious-security-issue/

    thanks again.

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

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

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