Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

database is not connecting . Expand / Collapse
Author
Message
Posted Monday, December 3, 2012 6:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:02 AM
Points: 93, Visits: 195

Hi 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@sql
Post #1391917
Posted Monday, December 3, 2012 7:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
I 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 window
Goto Connections
Click 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..
Post #1391930
Posted Monday, December 3, 2012 9:36 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:02 AM
Points: 93, Visits: 195
no actually i closed sql server and opened am able to see other databases except which i wanted to connect.

Post #1392243
Posted Monday, December 3, 2012 10:18 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 21, 2014 8:48 AM
Points: 323, Visits: 986
ravi@sql (12/3/2012)
no actually i closed sql server and opened am able to see other databases except which i wanted to connect.



check your SQL server error logs


-----------------------------------------------------------------------------
संकेत कोकणे
Post #1392250
Posted Monday, December 3, 2012 10:22 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, November 4, 2014 8:46 PM
Points: 1,786, Visits: 1,015
have you gone thru this link
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

You could also check if the servvice startup type is manual , most probably after the restart the service didnt come back up.


Jayanth Kurup
Post #1392251
Posted Tuesday, December 4, 2012 12:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
this 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'
Post #1392265
Posted Tuesday, December 4, 2012 2:24 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:03 AM
Points: 2,840, Visits: 3,975
hemant.raibole (12/4/2012)
this connectivity issue due to network failure
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.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1392296
Posted Tuesday, December 4, 2012 2:34 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 26, 2014 6:02 AM
Points: 93, Visits: 195
yes 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 ?


Post #1392300
Posted Tuesday, December 4, 2012 2:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2014 11:46 PM
Points: 42, Visits: 290
ravi@sql (12/3/2012)
no actually i closed sql server and opened am able to see other databases except which i wanted to connect.



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.
Post #1392302
Posted Tuesday, December 4, 2012 2:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 5:03 AM
Points: 2,840, Visits: 3,975
Bhuvnesh (12/4/2012)
hemant.raibole (12/4/2012)
this connectivity issue due to network failure
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.
try to set database offline then only try to detach mdf files NOT ldf (if you can afford)


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1392303
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse