RE: Clustering Analysis services 2005 and SQL Server 2005: Best Ap

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Jason,

Since AS/SQL are installed on different node, they usually run on different
"machines" though they may run on the same node under situaiton that one
node fails. I agree with Chip this is a riks but it rarely occurs.

You are correct that in a normal scenario, they are isolated from each
other since they are on different nodes. It's possible fail over AS to SQL
node to process and fail back afterwards. However, I don't think it's
necessary since the other node has more processing capability.

As Chip mentioned, AS/SQL are different type of applications, and
configuration/optimation might be different. This shall be the benefit of
the 2nd solution.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.




.