SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Starting one named SQL Server service stops/crashes another


Starting one named SQL Server service stops/crashes another

Author
Message
darrylc-ssc
darrylc-ssc
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2412 Visits: 266
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.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40569 Visits: 32666
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
darrylc-ssc
darrylc-ssc
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2412 Visits: 266
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...
MysteryJimbo
MysteryJimbo
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2239 Visits: 15346
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.
Grant Fritchey
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40569 Visits: 32666
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 Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Philip Barry
Philip Barry
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1460 Visits: 646
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
sgmunson
sgmunson
SSCertifiable
SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)SSCertifiable (7.1K reputation)

Group: General Forum Members
Points: 7101 Visits: 4377
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)
Smile Smile Smile
Health & Nutrition
EdVassie
EdVassie
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5870 Visits: 3866
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 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search