"Absolutely" <nospam@nospam.here> wrote in message
news:ey3pJvspHHA.4496@TK2MSFTNGP06.phx.gbl...
> Getting "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server doesn not exist
> or access denied" when trying to connect to SQL 2005 SP2 from a
> workstation. From the SQL server itself there are no problems.
>
> The SQL server has a SQL 2005 named instance and SQL Express on it. The
> SQL Express is used for a home grown app and the SQL 2005 is for a
> database application. The 2005 is configured to allow remote connections
> and there is nothing on the server or workstations that would stop the
> connection. Tried both Named Pipes and TCP/IP without success. Also
> unable to setup an ODBC connection to the 2005.
>
> I've installed 2005 several times and in some cases with SQL Express also
> on the same box and this is the first time I've had this problem.
> Everything appears as though it should work, but it just won't.
>
>