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
Unfortunately you can only use the same login for databases on the same server as mentioned in this post: http://forum.Winhost.com/showthread.php?t=7974 You will have to set up a separate connection for your database on S05.
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.