ODBC connection fails to an ION instance on a remote computer, but works on the server



Goals and Symptoms

When trying to connect with an ODBC System DSN connection to the SQL 2005 server, an error similar to the one below will appear. Connection with a user other than ION or Report may work however, these will not connect remotely. Pinging the server works, as well as remote desktop.
Connection failed:
SQL State: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connt()).

Connection failed:
SQL State: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

Causes and Fixes

By default SQL Server Browser service is disabled. This service must be enabled and started on the server to get a connection to the SQL 2005 Server Instance. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server Browser contributes to the following actions:

  • Browsing a list of available servers
  • Connecting to the correct server instance
  • Connecting to dedicated administrator connection (DAC) endpoints

Also verify that your communication protocol is enabled
  1. Go to the SQL Server Configuration Manager
    Start > Programs > Microsoft SQL Server 2005 > Configuration Tools
  2. In the tree on the left expand SQL Server 2005 Network Configuration and click on Protocols for ION
  3. Enable your communications protocol on the right hand side

Last Revised: April 17, 2008
Applies To: ION Enterprise,
Original Author: MN
All content © 1992-2008 Schneider Electric

Legacy KB System (APS) Data: RESL191704 V1.0, Originally authored by KBAdPM on 04/18/2008, Last Edited by KBAdPM on 04/18/2008
Related ranges: ION Enterprise V5.6, Database for PowerLogic Software