Multiple MS SQL enterprise manager connections?

X

xscott

Perch
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
 
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
 
You must log in or register to reply here.
Back
Top