asked on

Can't connect to SQL Server 2005 Express from SQL Server 2005

I am using SQL Server Management studio to connect to a SQL Server 2005 Express database. I keep getting the following error:

TITLE: Connect to Server
------------------------------

Cannot connect to VMWINXPBLOOM1.

------------------------------
ADDITIONAL INFORMATION:

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 that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1265)

I have allowed for remote connections(both TCP/IP and named pipes) and configured SQL browser to start The SQL Server Express Machine VMWINXBLOOM1

THe SQL Server 2005 machine is running win2k3, the express machine winxp sp2

SOLUTION

jss1199

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adimit

ASKER

the only option that is available to me when I browse is VMwinxpbloom1. I don't see the option for SQLEXPRESS

adimit

ASKER

I just tried typing in vmwinxpbloom1\sqlexpress and I received the same error

ASKER CERTIFIED SOLUTION

udaya kumar laligondla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adimit

ASKER

there is no firewall. The port is opened. I can connect to any other SQL Server Machine except any computer running SQL Server express. They all use port 1433

SOLUTION

udaya kumar laligondla

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

adimit

ASKER

by default i had to enable incoming connections and sql browser on sql express station