Multiple MS SQL enterprise manager connections?

Customer Support Database Support
1

I have a MS SQL login(accountname_datausername) and I have a client with a MS SQL login(clientname_datausername) that I also need to access.

I tried to create two connections in Enterprise Manager and it said you allready have a connection to mssql2.hostdomainname.com. Right now I have to change login info to connect to their data.

Is thier a better way?

thanks

2

Hello!

You can create TCP/IP alias of mssql2.hostdomainname.com (using SQL Server Client Network Utility). Then you can register this alias as new SQL Server in your Enterprise Manager.

Hope this helps,
Resnovit

3

resnovit

Thanks, that works great. I haven’t had to use that before.