Giving one sql database access to another

Discussion in 'Databases' started by peteegan, Nov 27, 2011.

  1. Hi folks - As I add new account databases, I need to give access for my central database to access the account database. Up until now, i haven't had problems with this since all my databases have resided on the same server (S04).

    The problem now is that when i create a new database, the new one resides on the S05 server (which is a different server). I have been unable to give access across servers.

    I've tried user names like the following:
    s05.Winhost.com\DB_20485_aapollo_user
    DB_20485_aapollo_user
    s05\DB_20485_apollo_user

    Please advise.

    Pete
     
    Last edited by a moderator: Oct 14, 2015
  2. Last edited by a moderator: Oct 14, 2015
  3. Ray

    Ray

    The SQL servers are not designed to really carry additional DB login. If the database you are referring to resides on the same SQL server, than technically you can set it up to access another database, so long as it is on the same SQL server, and you have dbo rights to both databases. But if the database resides on a SQL server, than there is no way of getting one database to access another one from a different server.
     

Share This Page