Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How to connect to a named instance of SQL Server in EMS SQL Manager for SQL Server?

April 26, 2017Connect EMS instance manager named sql SQL Server

0

Posted

How to connect to a named instance of SQL Server in EMS SQL Manager for SQL Server?

1 Answer

0

Posted

To connect to a named instance of SQL Server 2005 just enter instance name in after host name and back slash symbol in ‘Host name’ field of Database Registration Info form. (For example: my_server\my_instance.) To connect to a named instance of SQL Server 2000 you need: – Run SQL Server Client Network Utility (WINDOWS\\SYSTEM32\\cliconfig.exe) on client computer where STUDIO (particularly EMS SQL Manager for SQL Server) runs. – Go to the second (Alias) tab of the Utility. – Add a new server alias with Server Name in form \\ and TCP/IP as Network library. – Use the server alias name as host name in STUDIO.