Re: SQL Server Express 2005 and remote connections ?

These should 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


"Peter Stojkovic" <no_spam@xxxxxxx> wrote in message
news:%23iXRBepHHHA.2236@xxxxxxxxxxxxxxxxxxxxxxx
I have installed SQL Server Express 2005

I have read, that by default the express edition is set to local
connection only.
Is it possible to switch to local AND remote for the express edition 2005
?




.

Relevant Pages

  • Re: Windows 2003 Standard, SQL Server 2005, and RAM
    ... you may wish to explore what happens to performance if you were to use AWE with only 4GB of total memory. ... Configuration -Memory, Can not use more than 2GB of memoryhttp://www.support.microsoft.com/?id=811891 ... SQL Server to use more than 2 GB of physical memoryhttp://support.microsoft.com/kb/274750/ ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005- Not getting Started
    ... in the SQL2005 folder or the start menu under the Configuration folder. ... is the SQL Server Configuration Manager and the other is the Surface Area ... I'm a newbie to SQL Server 2005 and i've installed 180 days trial ver. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Re: Please advice
    ... Go to Remote Connections and check it out if TCP\IP is selected. ... Go to Start\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Configuration Manager. ... Expand SQL Server 2005 Network Configuration. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server 2005 on Windows Server 2008 - sqlcmd can not connect
    ... Being new to SQL Server, I assumed that sqlcmd would connect to the local SQL Server instance automatically, this turns out to be not the case. ... I did verify that Remote Connections are enabled and that the SQL Browser service is configured to start automatically (SQL Server Configuration Manager shows that all the SQL Server services are running). ...
    (microsoft.public.sqlserver.setup)
  • Re: Local connection to SQL Server 2005 Express fails
    ... Configuration -Configure SQL Server 2005 to allow remote connections ... "An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the fact ...
    (microsoft.public.sqlserver.connect)
Loading