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.
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?
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!