I am trying to connect to the sample databases in SQL Express. I am getting this error.
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: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
I have downloaded and installed AdventureWorks, Northwind, and Pubs. If I have to allow remote connections how do I do that? I am a studen and I am brand new at this.
first ensure the sample database you wish to use is registered (some of the samples must first be attached from the D/L .mdf files).
second startup the SURFACE AREA CONFIG TOOL via the start menu. after the splash screen display click on the configure services and connections link.
select the Remote Connection node in the tree and select the second radio button to enable remote connections.
if you still have problems you should look at the protocols your sql server has enabled and which protocol format you are using to connect.
|||1. Open SQL Server Configuration Manager under "Microsoft SQL Sever 2005" "Configuration Tools"
2. Navigate to "Sql Server 2005 Network Configuration" --"Protocols for SQL2005"
3. Enable "Shared Memory" , "Named Pipes" & "TCP/IP"
This should solve the problem
|||I figured it out. I feel stupid now. I just had to right click on database and click attach. Then click add. This brought me out to the windows hierarchy where I was able to find the Northwind database and click on it to add it.|||
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: Name Pipes Provider, error: 40 - could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
No comments:
Post a Comment