SQL Express Connection Issues

14 Mar 2006 11:05 PM

Stoneyos

I am having a problem connecting to a remote SQL Express server. I have SQL
Express installed on 2 boxes and am trying to connect to one from the other
and vice versa through the SSMSE 'Connect to Server' interface. I can browse
to the server through the server name drop down box (server name/browse for
more/network servers) but after hitting ok andd trying to connect I get the
error:

An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.

I have gone into both the Surface Area Configuration and the Configuration
manager to verify that both Named Pipes and TCP/IP are enabled. I have not
tampered with any of the default settings for either Named Pipes or TCP/IP.
I have also turned off Windows Firewall and disabled any anti-virus programs.

BOX1
SQL Server Name: POS\EDGE
Security Mode: Mixed
Named Pipes: Enabled
TCP/IP: Enabled
BOX2
SQL Server Name: SUPPORTLAP\EDGE
Security Mode: Mixed
Named Pipes: Enabled
TCP/IP: Enabled

I have gone through several articles on how to enable remote connections and
have followed the steps. I have even reinstalled SQL Express to no avail.
I would appreciate any help or advice.

Thanks

15 Mar 2006 5:40 AM

Roger Wolter[MSFT]

Did you enable and start the SQLBrowser service? Is there a firewall on
either server?

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Show quoteHide quote

"Stoneyos" <Stone***@discussions.microsoft.com> wrote in message
news:09C017BE-D0E0-4ED9-A676-732D4554790F@microsoft.com...
>I am having a problem connecting to a remote SQL Express server. I have
>SQL
> Express installed on 2 boxes and am trying to connect to one from the
> other
> and vice versa through the SSMSE 'Connect to Server' interface. I can
> browse
> to the server through the server name drop down box (server name/browse
> for
> more/network servers) but after hitting ok andd trying to connect I get
> the
> error:
>
> An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
>
> I have gone into both the Surface Area Configuration and the Configuration
> manager to verify that both Named Pipes and TCP/IP are enabled. I have
> not
> tampered with any of the default settings for either Named Pipes or
> TCP/IP.
> I have also turned off Windows Firewall and disabled any anti-virus
> programs.
>
> BOX1
> SQL Server Name: POS\EDGE
> Security Mode: Mixed
> Named Pipes: Enabled
> TCP/IP: Enabled
> BOX2
> SQL Server Name: SUPPORTLAP\EDGE
> Security Mode: Mixed
> Named Pipes: Enabled
> TCP/IP: Enabled
>
> I have gone through several articles on how to enable remote connections
> and
> have followed the steps. I have even reinstalled SQL Express to no avail.
> I would appreciate any help or advice.
>
> Thanks

15 Mar 2006 5:56 PM

Stoneyos

Thanks for the reply. I figured it out. Maybe someone could help shed some
light on this though. I was able to connect to the SQL Express Server by
using the ip of the computer followed by the SQL Server name. ex:
192.168.1.113\EDGE, where EDGE = the name of the SQL Server instance.

So it seems that the computer name is not being resolved. I can hit that
computer over our network using the computer's name ex: \\POS. But when I
try to access the SQLServer by using POS\EDGE no go.

Any ideas? Could it have something to do with reinstalling SQL Express. I
know at one point we were able to access it using the standard name.

Thanks