MY project shows this error in execution time?

Posted by Sudheep.grandhe under ASP.NET on 10/20/2011 | Points: 10 | Views : 1293 | Status : [Member] | Replies : 4
Hi,

MY project shows this error in execution time?can you please resolve it for me.please do the needful.
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)

Best,
Sudheep.



Responses

Posted by: Blessyjees on: 10/20/2011 [Member] Bronze | Points: 25

Up
0
Down
Hi,

check your sql server TCP/IP port is enabled or not. By using sql server configuration manger ->sql native client configuration->client procol-> enable TCP/IP

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ndebata on: 10/20/2011 [Member] Starter | Points: 25

Up
0
Down
Try to use sql server management studio or odbc to see you can coonect to the database server, firewall port should be open.



Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudheep.grandhe on: 10/20/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I dont have idea how to open

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sudheep.grandhe on: 10/20/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

I am not finding those .

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response