A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider

Question

This type of error is comming from last few days when i try to connect the server database before i was working fine.

waiting fro ur answers

Thanks & Regards
Sudhakar

Answer 1

http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

Answer 2

There is a problem in connecting to your database server. Check if you database is running. Check the port on which your database is running and check if you can connect to that port from the machine from which you are trying to run your program.
If you know the IP and port of the server on which your database is running you can test the connectivity by typing
telnet "IP Address" "port"
e.g. if your database server is running on port 1433 on a machine with IP 172.23.45.1 then you can try
telnet 172.23.45.1 1433
If you are able to connect then your database is available. In this case you need to check your program.
If you are using the name of the server to connect to the database then check if the IP name of the server has changed or if there is some problem with the DNS. You can do this by first doing
ping DatabaseServerName
E.g. if you database server name is EINSTIEN you can try
ping EINSTIEN
if you get a message indicating that you are getting response from the server then your are OK else you need to check with your network administrator to see if something is wrong.
You can also try
telnet EINSTIEN 1433
in this case.
If nothing works reboot your machine, reboot the database server and restart the database server, check your code and run.

Regards,

Answer 3

Restart your server