Problems With Client Connections

I will try to keep this as concise as possible. I am trying to set up a new
SQL Server 2005 Express server.

The OS is Windows XP Pro SP2. SQL Express is SP2.

I am able to connect to the instance locally through shared memory. I am
also able to connect to the instance locally with TCP by selecting browsing
and the network tab.

I have been able to connect through ODBC from one client desktop through MS
Access.

I am unable to establish a connection from any other client. They are all
on the same subnet. I have tried updating the driver to SQL Native Client
but still cannot connect. I receive the very long error message that
essentially states that it doesn't exist or I do not have permission to it.

I hope that this will be enough information for someone to make some
suggestions.

Thanks in advance for reading this post.

Bill


.

Relevant Pages

  • Re: connect to named instance w/ non-default port
    ... SQL Native Client Configuration. ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Source table filtering in DTS by target table values.
    ... I am new to SQL Server and to DTs. ... for the client master. ... file (created in the DTS package) and add them batch by batch ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems connecting to SQL Server
    ... I am a complete newbie when it comes to SQL, ... I can not connect from this machine to the SQL Server. ... You should not need to know the sa password to install the ODBC driver. ... Client software. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Mobile - cant replicate anymore?
    ... >> replicating data between SQL Mobile on my pda and SQL Server 2000. ... the replication process fails on the client. ...
    (microsoft.public.sqlserver.ce)
  • Re: Cannot connect a remote sql server
    ... Try disabling the firewall on the client. ... I would also make sure the SQL Browser service is running and that the login credentials you're using have rights to the default database. ... I've also written a long chapter on connecting that has helped a lot of people establish and maintain connections. ... I don't know if this matter but the server I'm trying to connect to is SQL Server 2000. ...
    (microsoft.public.dotnet.framework.adonet)