error has occurred while establishing a connection

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

error has occurred while establishing a connection

Author

Topic

Ambikaa
Starting Member

43 Posts

Posted - 2008-08-11 : 02:30:56

Hi,

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)

my connection string is
connectionString ="Data Source=72.167.251.52;DATABASE=RealEstate;UID=sa;PASSWORD=sa;" providerName="System.Data.SqlClient"

This is from remote system , i have installed the sql server 2005 when i check it for the project it showed that error.

kindly suggest me.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-11 : 02:49:48

As what the error message said. Have you enable the remote connection via the Surface Area Config ?

KH
[spoiler]Time is always against us[/spoiler]

Ambikaa
Starting Member

43 Posts

Posted - 2008-08-11 : 02:58:43

Hi,

yes, i have enabled the sqlserver 2005 surface area configuration->local and remote connection->using both tcp and named pipes

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-11 : 02:58:58

Check in your Surface Area Configuration manager
Go to Programs->SQL Server 2005-> configuration tools->SQL Server Surface Area Configuration
Select Surface Area configuration for services and connections
select remote connections under your server->database engine and select local and remote connections option.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-11 : 03:00:37

see this also:-
http://blogs.msdn.com/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-11 : 23:23:06

Tried specify port number in connection string?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-08-11 : 23:29:47

Is the Server machine behind a firewall or anything ?