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

Starting one named SQL Server service stops/crashes another Expand / Collapse
Author
Message
Posted Tuesday, December 10, 2013 8:44 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 4:41 PM
Points: 1,445, Visits: 205
Hi all

We currently have a machine running a named instance of SQL Server 2008 and need to create a new named instance on the same machine (the separation is needed due to client data from different countries). In the past this has been no problem and we have multiple instances on other machines running with no issue.

In this case however after having installed the new instance when starting up the new services, it either stopped (or crashed) the existing instance service "SQL Server (Original)". Noticing this I restarted the service for "SQL Server (Original)" service, but then realized that it then stopped the new one "SQL Server (New)".

Obviously there is some conflict somewhere, but we have never had this issue previously. I thought it may have been a TCP issue but having looked at the Network Configuration both seem to be running with Dynamic Ports with no clash in the port number.

I've not had much luck with Google but may be searching for the wrong terms - has anyone out there seen a similar problem and/or come up with a solution?

Many thanks for any help.
Post #1521726
Posted Wednesday, December 11, 2013 3:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 15,661, Visits: 28,050
What does the error log of the system being shut down say? Are there any entries in the Windows logs suggesting possible problems?

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1521797
Posted Wednesday, December 11, 2013 1:42 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 4:41 PM
Points: 1,445, Visits: 205
Grant, thanks for your reply.

I neglected to mention in the earlier post that the SQL Server log showed no error at all. There was simply the last valid entry of one log (a log backup being taken) then the next log started with the usual instance startup entries. I did however receive an agent alert email notification for a Severity 25 fatal error: The <InstanceName> service terminated unexpectedly.

For the windows logs:-

The security log showed the services for the new named instance being granted their various privileges, but no untoward errors at all.

The system log showed the various services of the new instance "entering the running state", 2 seconds later the next message showed the SQL Server Agent (Original) service entering the stopped state, following 1 sec later "The SQL Server (Original) service terminated unexpectedly. It has done this 2 time(s)." - this was the last message before I restarted the (Original) service. Once this service started it was followed immediately by "The SQL Server (New) service terminated unexpectedly. It has done this 1 time(s)."

The application log showed the installer going through its thing and then the new named instance starting up. Here the last service to start up was the Reporting Services followed by "The MSSQL$<Original> service terminated unexpectedly."

Essentially all I can see is that the new instance starts up and then the old one stops (and vice versa). Unfortunately there does not seem to be a lot to go on...
Post #1522047
Posted Thursday, December 12, 2013 12:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,362, Visits: 15,269
Were they installed incorrectly, sharing the same systems dbs? I've never tested the impact of this so I cant confirm what impact this would have.
Post #1522167
Posted Thursday, December 12, 2013 4:12 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:09 AM
Points: 15,661, Visits: 28,050
I'm not sure. You may need to open a case with Microsoft. I'd say it sounds like you've set them up on the same ports, but you said you checked that. If it's not that and there's no indications in the error logs getting in touch with Microsoft would be my next step.

You could try running pssdiag. They're probably going to have you do that anyway. That might capture something you can spot.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1522224
Posted Thursday, December 12, 2013 7:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 9:06 AM
Points: 1,406, Visits: 582
You could consider running File Monitor (http://technet.microsoft.com/en-gb/sysinternals/bb896642.aspx) and Process Monitor (http://technet.microsoft.com/en-gb/sysinternals/bb896645.aspx) to see if the new instance is trying to access any files that belong to the original instance.

Regards,

Phil
Post #1522302
Posted Thursday, December 12, 2013 8:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 7:32 PM
Points: 1,669, Visits: 2,211
Failing any of the previous suggestions, I'd start looking at available resources... Does the server have enough RAM to run all the existing instances? Is there perhaps a disk space issue somewhere ? Admittedly, this is more of a "grasping at straws" thing, but outside of going to MS, there might not be any easy ways to trap the problem.


Steve
(aka sgmunson)

Internet ATM Machine
Post #1522348
Posted Monday, December 16, 2013 4:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 2,868, Visits: 3,213
The most obvious cause is that both instances are sharing a resource that should not be shared. The advice about using File Monitor and Process Monitor to help detect this is worth looking at.

You say you are using SQL 2008 (not SQL 2008 R2). This version uses 8.3 style filename references for some of its folders, and I remember a situation a few years back where the installer plugged in the wrong 8.3 reference for a folder. This resulted in two instances using the same folder when looking at 8.3 format filenames, while the long format filenames were correct and distinct. Needless to say only one instance at a time would work. I could not reproduce the problem so did not report it.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1523143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse