May 27, 2008 at 3:18 am
🙂 Hi Friends,
I am getting this error from Sql server Management Studio when executing any query. I searched through google but no info. Is this problem with Microsoft dot net environment or any other issues?
Have u any body encountered this problem.
Thanks in advance.
Msg 10054, Level 20, State 0, Line 0
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Ramaa
May 27, 2008 at 3:39 am
Hi there,
Is this a production database? If not, how often does it get restored?
May 27, 2008 at 4:19 am
Hi SSC,
Thank You for your reply.
It's not a production database. We are in developement environment. Application developers are connecting to the server from sql server management studio client.
Ramaa
May 27, 2008 at 4:35 am
Check the Remote Host TCP/IP port configuration.
Check the configuration setting by typing the following command at Run prompt
SQLServerManager.msc
May 27, 2008 at 4:51 am
We get that when querying a log shipped database after a log restore - it makes sense though since the 'old' session is no longer valid.
May 28, 2008 at 1:03 am
Hi All,
Thank you for your responses.
This is not log shipped database. Its purely development database.
Error getting only when executing the query in sql server management studio. There is no error when connecting through java application.
Thank you and regards
Ramaa
May 28, 2008 at 1:40 am
Just try like the following way:
Re-install / repair .NET Frame work 2.0 (with sp1)
Re-Install / repair SQL Management Studio.
Install SQL 2005 SP2 with latest patches.
Re-Start the SQL Server Services.
Problem is in .NET 2.0. Hope to solve your problem.
Also see the link: http://support.microsoft.com/kb/942861
🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply