Urgent! Multiple SQL Instances

Question

Post reply

Urgent! Multiple SQL Instances

Michelle-138172

Hall of Fame

Points: 3234
More actions
February 22, 2016 at 10:31 am

#311599

Hi,
I installed a new SQL 2014 instance to a server that already has an SQL instance running. Both were running fine after installation. But after I rebooted the sql server, now I found I could only have one SQL instance running at the same time. Why is that? How can I resolve the problem?
I'm running the SQL server on AWS if that means anything.
Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Did you check the service status in the Configuration Manager?

-- Gianluca Sartori

Michelle-138172 Hall of Fame Points: 3234 More actions · Answer 2

Yes, that's how I found out I can only run one instance at a time. I thought one server was overwritten by another at the very beginning. But when I checked the Config Mgr and found only one instance running. When I tried to start the stopped instance, it failed. But I can switch between the two instances to have either one running, but not both at the same time.

spaghettidba (2/22/2016)
Did you check the service status in the Configuration Manager?

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

Michelle-138172 (2/22/2016)
Yes, that's how I found out I can only run one instance at a time. I thought one server was overwritten by another at the very beginning. But when I checked the Config Mgr and found only one instance running. When I tried to start the stopped instance, it failed. But I can switch between the two instances to have either one running, but not both at the same time.
spaghettidba (2/22/2016)
Did you check the service status in the Configuration Manager?

What error do you get when you attempt to start the instance?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Michelle-138172 Hall of Fame Points: 3234 More actions · Answer 4

Thanks, all. The problem is now resolved. As was suspected, I changed the port number to 1435 for one of the instances so the two were not conflicting. It's working now.