• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1835
  • Last Modified:

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




0
adimit
Asked:
adimit
  • 4
  • 2
3 Solutions
 
jss1199Commented:
You are attempting to connect to VMWINXPBLOOM1\SQLEXPRESS or just VMWINXPBLOOM1?
0
 
adimitAuthor Commented:
the only option that is available to me when I browse is VMwinxpbloom1. I don't see the option for SQLEXPRESS
0
 
adimitAuthor Commented:
I just tried typing in vmwinxpbloom1\sqlexpress and I received the same error
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
udaya kumar laligondlaTechnical LeadCommented:
check if the port no 1433 is open and allowed to access on both the machines in firewall. use the machine IP address and try
0
 
adimitAuthor Commented:
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
0
 
udaya kumar laligondlaTechnical LeadCommented:
it looks like the client is trying to use named pipes. check if it is enabled on the server and that port is exempted from firwall list.

use the checklist provided at
http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx
0
 
adimitAuthor Commented:
by default i had to enable incoming connections and sql browser on sql express station
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now