Re: Problems With Client Connections

Perhaps these articles will help:

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"William Downey" <wdowney@xxxxxxxxxxxxxxxxxx> wrote in message
news:%23emSqz9FHHA.4588@xxxxxxxxxxxxxxxxxxxxxxx
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: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)
  • 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: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • 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)