PROBLEM: The dialog for which SQL Server instance is empty when installing DataGate for SQL Server

The information in this article applies to:

• Acceler8DB, Version 5.0
• DataGate for SQL Server, Version 5.0
• SQL Server2000
• Windows

SYMPTOMS:

When installing DataGate for SQL Server (DSS), there is a dialog prompting which SQL Server instance you wish to connect to. The list of available SQL Servers is empty.

CAUSE:

There are several causes for this:

• The SQL Server instance is blank or no name was assigned.  This name is prompted when installing SQL Server2000.
• The machine you are wanting to connect to is on another domain and there is no trust relationship between the two domains.

RESOLUTION:

NOTE: Please coordinate with your Network Administrator or Microsoft when working with Domain or SQL Server2000.

The resolutions to the causes are:

• Make sure you install and assign a name when installing the SQL Server2000 Engine.

NOTE: Installing MSDE (Microsoft SQL Desktop Engine), you will have to assign a name via SQL commands. Remember, MSDE does not have SQL Enterprise management tools.

• Assign a two way trust relationship between the domains

MORE INFORMATION:

Below are trouble shooting steps you can work with to determine the root cause:

1. Can you use the SQL Enterprise Manager tool from a workstation/server and connect to this SQL machine? If it fails, search on Microsoft's Knowledge Base to see if they have a resolution.
2. Is this machine on the Network and on the same domain as other SQL Server2000 machines?

   If it isn't on the same domain, then are the two domains have a two way trust relationship?

   The following is the SQLDMO api DSS Instance name dialog is calling:

   http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_l_9jfo.asp

   DCOM is the running agent, and DCOM specification requires a two way trust relationships between multiple domains.

Keywords: SQL Server, MSDE, Domain, instance name, DSS, Install