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 Data Import for SQL Server?

April 26, 2017Connect Data EMS import instance named SQL Server

0

10 Posted

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

1 Answer

0

10 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 at the Setting Connection Properties step. (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 Data Import 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 Data Import.