InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 01:22:19 GMT20http://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxplease check database mdf and ldf located disk present or not this might reason .i already face this error such error .it is showing database online in ssms .bcoz it is showing entry of database from system catalog..Wed, 05 Dec 2012 03:42:58 GMTHemant.Rhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspx[quote][b]Bhuvnesh (12/4/2012)[/b][hr][quote][b]hemant.raibole (12/4/2012)[/b][hr]this connectivity issue due to network failure[/quote] this cant be the case as OP posted above that he is abble to connect with other databases.This might be bacause wrong reference of that particular database log's file check the refernce is sys.databases.[/quote] try to set database offline then only try to detach mdf files NOT ldf (if you can afford)Tue, 04 Dec 2012 02:45:15 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspx[quote][b]ravi@sql (12/3/2012)[/b][hr]no actually i closed sql server and opened am able to see other databases except which i wanted to connect.[/quote]Hello Ravi,Are you able to connect to the database now? Do you see the database at all in SSMS? If yes, is it online or, you are seeing it is suspect mode?If you are not seeing the database at all, you need to attach it. Right click on databases and click on attach. Then, browse to the physical location of MDF file for the database.Tue, 04 Dec 2012 02:44:26 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxyes you are right if i guess right ... but one senior guy telling that mdf and log files are corrupted now resore it from any other back only the option.they try to detach and attach the but it didnt worked.any solution for this ?Tue, 04 Dec 2012 02:34:45 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspx[quote][b]hemant.raibole (12/4/2012)[/b][hr]this connectivity issue due to network failure[/quote] this cant be the case as OP posted above that he is abble to connect with other databases.This might be bacause wrong reference of that particular database log's file check the refernce is sys.databases.Tue, 04 Dec 2012 02:24:58 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxthis connectivity issue due to network failure.please check it using cmd ping -t with IP of server another possible reason is when service get restart .check using sql query when was last sql server restart select name .create_date from sys.databases where name='tempdb'Tue, 04 Dec 2012 00:25:14 GMTHemant.Rhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxhave you gone thru this link [url] http://blogs.msdn.com/b/spike/archive/2009/04/16/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.aspx[/url]You could also check if the servvice startup type is manual , most probably after the restart the service didnt come back up.Mon, 03 Dec 2012 22:22:09 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspx[quote][b]ravi@sql (12/3/2012)[/b][hr]no actually i closed sql server and opened am able to see other databases except which i wanted to connect.[/quote]check your SQL server error logsMon, 03 Dec 2012 22:18:33 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxno actually i closed sql server and opened am able to see other databases except which i wanted to connect.Mon, 03 Dec 2012 21:36:07 GMTravi@sqlhttp://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxI guess it is because you restarted SQL Server and trying to connect to the instance from an already opened SSMS Query window.Try this:Right-click on query windowGoto ConnectionsClick on Connect and connect to the instance again.If this doesn't solve your issue, tell us how you are trying to connect to the instance?Regards..Mon, 03 Dec 2012 07:12:27 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1391917-391-1.aspxHi All, While connecting to database am getting below error."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."actually i restarted the system and then again i replced existing log file with the same name. But am not abel to connect to that data base.so i replced with the old logfile with same name.After that am getting above error.Please provide solution for this.Tahnks,Ravi@sqlMon, 03 Dec 2012 06:54:54 GMTravi@sql