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 01, 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 @ 8:42 AM
Points: 12,744, Visits: 31,078
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 01, 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: Yesterday @ 11:24 AM
Points: 32,781, Visits: 14,942
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse