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

Unable to start sql server service Expand / Collapse
Author
Message
Posted Saturday, January 18, 2014 2:38 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 3:52 PM
Points: 377, Visits: 685
Hello,
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 on my local machine (Windows 7). One instance starts without any problem, but when I start the other instance from the Services, it starts and immediately it stops.

When I try to Connect to server using SSMS, I get the following error:

No Connection could be made because the target machine actively refused it

My event log shows the following error:

An error occurred during recovery, preventing the database 'model' (3:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

Thanks for your help.
Post #1532407
Posted Saturday, January 18, 2014 10:33 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:07 PM
Points: 36,612, Visits: 31,050
ramadesai108 (1/18/2014)
Hello,
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 on my local machine (Windows 7). One instance starts without any problem, but when I start the other instance from the Services, it starts and immediately it stops.

When I try to Connect to server using SSMS, I get the following error:

No Connection could be made because the target machine actively refused it

My event log shows the following error:

An error occurred during recovery, preventing the database 'model' (3:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

Thanks for your help.


It sounds like your Model database files could be corrupt. Most people never make changes to the Model database so this might work. Rename the files for you Model database. Copy the Model files from another server (can only be done while the server is stopped) to the server that you're having problems with and then try restarting the service.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1532428
Posted Monday, January 20, 2014 4:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 29, 2014 9:14 PM
Points: 8, Visits: 47
Or rebuild the system databases and re-attach the database files.

http://technet.microsoft.com/en-us/library/dd207003.aspx

Post #1532817
Posted Monday, March 3, 2014 5:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:28 AM
Points: 6,131, Visits: 13,259
ramadesai108 (1/18/2014)
Hello,
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 on my local machine (Windows 7). One instance starts without any problem, but when I start the other instance from the Services, it starts and immediately it stops.

When I try to Connect to server using SSMS, I get the following error:

No Connection could be made because the target machine actively refused it

My event log shows the following error:

An error occurred during recovery, preventing the database 'model' (3:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

Thanks for your help.

is there any other information in the event log? Clear the Windows application log, then try restarting the service and check log again for further errors.


Jeff Moden (1/18/2014)
ramadesai108 (1/18/2014)
Hello,
I searched on the internet for hours but cannot resolve my issue, so this is my last resort.
I have 2 instances of SQL Server 2012 on my local machine (Windows 7). One instance starts without any problem, but when I start the other instance from the Services, it starts and immediately it stops.

When I try to Connect to server using SSMS, I get the following error:

No Connection could be made because the target machine actively refused it

My event log shows the following error:

An error occurred during recovery, preventing the database 'model' (3:0) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.

Thanks for your help.
Rename the files for you Model database. Copy the Model files from another server to the server that you're having problems with and then try restarting the service.

You must make sure that the collation matches on both systems otherwise the TempDB will have a different collation to master and that will cause issues.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1546859
Posted Monday, March 3, 2014 5:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:19 PM
Points: 42,332, Visits: 35,386
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/

Under the section on model. You'll need a backup of model, a copy of model from another identical server or to rebuild the system DBs.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1546861
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse