Enterprise Manager: Multiple Logins for single SQL Server

Customer Support Database Support
1

I have multiple logins for a single SQL Server. However, I have been unable to add more than one login to the SQL Server in the Group. When I attempt a new SQL Server Registration, it tells me the DB alreayd exists.

So the question is how do I setup EM to work with two separate logins for two separate databases on the same server?

Thanks for the help,

Brent

2

I ended up just adding the server to the Enterprise Manager twice, with different credentials :frowning:

It’s annoying if you want to acccess both databases because it means you’ll have to go through the (slow) connection process twice.

3

I tried adding the server to a new group and it didn’t work. Maybe I’ll try it another way. There must be a way to manage multiple logins via EM. mmm.