MS SQL Server - Does not allow remote connections

Author

Does not allow remote connections

larzeb

2006-03-10, 3:23 am

I have installed SQL Server 2005 Std on an XP system for development using VS 2005. When I try to
connect to the DB via Server Management Studio, I get the message that "... does not allow remote
connections".

When I launch Surface Area Configuration and select the Surface Area Configuration for Services and
Connections, I see only 4 services listed: Analysis, Reporting, Integration and SQL Server Browser.
There is no Database Engine Service listed!

Have I installed incorrectly?

TIA Lars

Peter Yang [MSFT]

2006-03-10, 7:23 am

Hello,

Please check if the following folder exist:

%programfiles%\Micro
soft sql server\mssql.1\mssql\data

If it does not exist, it seems the database engine is not installed, you
may want to go to Add/Remove program to install this component.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

====================
====================
=============

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>NNTP-Posting-Date: Fri, 10 Mar 2006 01:47:30 -0600
>From: larzeb <larzeb@community.nospam>
>Newsgroups: microsoft.public.sqlserver.server
>Subject: Does not allow remote connections
>Date: Thu, 09 Mar 2006 23:47:23 -0800
>Message-ID: < oeb212ljn7hj2gqd0b79
5dkcd0mqv6qf3h@4ax.com>
>X-Newsreader: Forte Agent 3.1/32.783
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Lines: 11
>X-Trace:
sv3- PjJxXeuzs9DydzPoFbzA
okDHiY6O/KXDzjV8O7hEwxj/ ljIdWbzP3wItPsTOueQ5
nFw/SN8L
okMLvDY!lpKWpYf6RQBH
uNvVXmwxsNoiCv3bMHVG
U73LWN6CN48tFv9p/w4z0jbRyZAA6ZBcpvbv
WXA=
>X-Complaints-To: abuse@giganews.com
>X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
>X-Postfilter: 1.3.32
>Path:
TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.server:423971
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>I have installed SQL Server 2005 Std on an XP system for development using
VS 2005. When I try to
>connect to the DB via Server Management Studio, I get the message that
"... does not allow remote
>connections".
>
>When I launch Surface Area Configuration and select the Surface Area
Configuration for Services and
>Connections, I see only 4 services listed: Analysis, Reporting,
Integration and SQL Server Browser.
>There is no Database Engine Service listed!
>
>Have I installed incorrectly?
>
>TIA Lars
>

Sponsored Links