CONNECT TO SERVER PROBLEM

I am getting this message when trying to connect to SQL SERVER 2005;
An error has occurred while establishing connection to the server.When connecting to SQL Server 2005, this failure may be caused by the fact that under default settings SQL Server does not allow remote connections(provider:shared memory provider , error 40-could not open a connection to SQL Server)(MicrosoftSQL SERVER, Error: 2)
Can anyone help to fix this problem please

Are you using SQL Express? If so, you need to enable remote connections. They are disabled by default.

Thanks,
Sam Lester (MSFT)

|||SQL SERVER 2005, STANDART
|||

On the server execute these statements:

sp_configure 'remote admin connections', 1

go

reconfigure

go

Then you should be able to connect from a client workstation.

Connect to Database in SQL 2005 Express

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)

Connect to Database in SQL 2005 Express

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)

Connect from a SQL Server 2005 db to a SQL Server 2000 db, without linked server connection

Can I connect from a SQL Server 2005 database to a SQL Server 2000 database, without establishing a linked server connection.

I need to fire a SELECT query on a SQL Server 2000 database, but don't want to add it as a linked server. Is there any way I can do this or its not possible?

Look in Books Online, Topic: OpenDatasource()

SELECT *
FROM OPENDATASOURCE( 'SQLOLEDB','Data Source=ServerName;
User ID=MyUID;Password=MyPass'
).Northwind.dbo.Categories