January 28, 2010 at 2:45 am
Hello all,
I have been reading the theads on these forums around multiple instances of SQL on a server and I know it is possible (max of 50 I believe) but we are looking at 1 default instance running SQL 2005 and an additional instance using SQL 2008. However is there anything we need to be aware of? For example;
1. SSIS packages... The con-figs are set up to use server1.schema1.table1 but if a second SQL instance is installed will these then fail as they need updating to server1.instance1.schema1.table1?
2. Reporting services - the same with the data sources, do i need to reference the the instance names.
My initial thoughts are that if no instance is named then it uses the default, otherwise if you reference the instance then no problems either...
Is there anything else I need to look out for apart from the obvious additional instance using server resources such as RAM, CPU etc?
Any help or guidance much appreciated...
January 28, 2010 at 7:04 am
You definitely would need to change your data sources to reference the correct instance. You could also use DNS Aliases as described by Allen Kinsel here.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply