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.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  February 22, 2016 at 10:46 am

  #1860151

  Did you check the service status in the Configuration Manager?

  -- Gianluca Sartori

• Michelle-138172

  Hall of Fame

  Points: 3234

  More actions

  February 22, 2016 at 10:54 am

  #1860154

  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: 247142

  More actions

  February 22, 2016 at 11:01 am

  #1860157

  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?

  ---

• Michelle-138172

  Hall of Fame

  Points: 3234

  More actions

  February 22, 2016 at 11:07 am

  #1860159

  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.