SQL Server doesn not exist or access denied

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.


.

Relevant Pages

  • Re: Migrating DTS Packages on SQL 2000 to SSIS on 2005
    ... You can install a named instance of SQL Server 2005 on the same box as SQL ... server as SSIS does not support named instances. ...
    (microsoft.public.sqlserver.dts)
  • Re: Do SqlServer 2000 & SqlServer 2005 co-exist
    ... I understand that you can connect to SQL 2000 named instance on the local ... to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed ... Select TCPIP, and click Properties, and set the port of the instance to ...
    (microsoft.public.sqlserver.setup)
  • Re: different environment fails to fill a dataset
    ... Andrew J. Kelly SQL MVP ... workstation four out of the five winforms worked fine but one doesn't. ... oledbadapter.fill command to fill the dataset it fails. ... Is there anything in the environment or SQL Server that could be causing ...
    (microsoft.public.sqlserver.clients)
  • Re: ADP2007/SQLServerExpress RIP
    ... SERVERNAME\SQLEXPRESS is what you need to use for SQL Express. ... the named instance. ... I even went so far as reinstalling VISTA before I ... Anyway I can't create an ADP linked to my sql server file. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help - "this recordset is not updatable"
    ... I have an MS-Access 2002 ADP application that connects to SQL server. ... displays "this recordset is not updatable". ... It does sound workstation related but still a security issue. ...
    (comp.databases.ms-access)
Loading