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

Same SQL Server Instance name on two different Windows 2008 R2 servers Expand / Collapse
Author
Message
Posted Monday, May 13, 2013 3:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 10:43 PM
Points: 2, Visits: 52
Hi,

We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The questions I have are:

1) Can I have the same named instance on both the servers (Server1\Instance1, Server2\Instance2)?
2) Will this cause any problems for operations.

Thanks in advance for the replies.


Raghuveer S



Post #1452330
Posted Monday, May 13, 2013 3:14 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 12,965, Visits: 32,541
raghusg (5/13/2013)
Hi,
We have two different Windows 2008 R2 servers (Server1 and Server2) on the same domain. The questions I have are:
1) Can I have the same named instance on both the servers (Server1\Instance1, Server2\Instance2)?
2) Will this cause any problems for operations.
Thanks in advance for the replies.
Raghuveer S


Your example doesn't have the same instance names? typo?

a classic example in my shop is everyones developer machines have 2008 and 2012 both as instances.

so my machine, DEV223, has instances named DEV223\SQL2008 and DEV223\SQL2012.

The guy in the next cube has a machine named DEV241, and he has isntances named DEV241\SQL2008 and DEV241\SQL2012

it's the combination of machine name + instance name that is required to be unique across the network, not just the isntance name.
Does that help?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1452333
Posted Monday, May 13, 2013 3:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 10:43 PM
Points: 2, Visits: 52
Thank you very much for the response.

Sorry for the typo.

Yes, it does answer the question.

The combination of Server Name\Instancename in our case would be WIDSQL04\ProjectWise (Development) and WIPSQL04\ProjectWise (Production).

Do you see any problems with this?


Thanks again.




Post #1452345
Posted Monday, May 13, 2013 4:27 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 11:08 AM
Points: 31,371, Visits: 15,839
I'm assuming the part in parenthesis is for our benefit and not part of the name? If so, you are fine.

Instance names must be unique on a Windows host. On a network, the hostname\instancename must be unique. These two are unique

WIDSQL04\ProjectWise
WIPSQL04\ProjectWise

Because the hostname is different.

Put another way, I can have a "Sales" instance on every windows machine on my network.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1452352
Posted Monday, October 27, 2014 7:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:19 AM
Points: 116, Visits: 647
Steve -

Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql instances with the same name. Would it be acceptable:

Server1:
SQLSERVER\Instance1

Server2:
SQLSERVER\Instance1

I know if you are on the same network, you use servername\instancename to connect to SQL. I assume the above case it is not acceptable since both server name and instance names are the same even though they are on different nodes. Please correct me if I am wrong.

Thanks,



Post #1628778
Posted Monday, October 27, 2014 9:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:07 AM
Points: 6,763, Visits: 14,427
lsalih (10/27/2014)
Steve -

Question for you, I know this is an old post but I was curious about where you have two different nodes (node1 and node2) and having two sql instances with the same name. Would it be acceptable:

Server1:
SQLSERVER\Instance1

Server2:
SQLSERVER\Instance1

I know if you are on the same network, you use servername\instancename to connect to SQL. I assume the above case it is not acceptable since both server name and instance names are the same even though they are on different nodes. Please correct me if I am wrong.

Thanks,

No, on a Windows network the computername must be unique and usually no more than 15 characters.

You cannot have 2 hosts called SQLServer. You could have the following

Server1:
SQLSERVER1\Instance1

Server2:
SQLSERVER2\Instance1


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1628811
Posted Monday, October 27, 2014 9:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:19 AM
Points: 116, Visits: 647
Perry - Thank you.


Post #1628815
Posted Monday, October 27, 2014 10:01 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 11:08 AM
Points: 31,371, Visits: 15,839
What Perry said.

Windows name unique. SQL instance names unique on a host.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1628839
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse