Can I have multiple instances of SQL Server for a single SQL virtual server on.......

[eUKShane]

Que : Can I have multiple instances of SQL Server for a single SQL virtual server on a failover cluster?

Solution :

No. You can run only one instance of SQL Server for each virtual server on a SQL Server failover cluster. However, you can install up to 16 SQL virtual servers on a failover cluster. The instance of SQL Server can be either a default instance or a named instance. The virtual server looks like a single computer to applications that are connecting to the instance of SQL Server. When applications connect to the virtual server, they use the same convention as when they connect to any instance of SQL Server. They specify the virtual server name of the cluster and the optional instance name (only needed for named instances): virtualservername\instancename.

When SQL Server is installed to a cluster, only one default instance of SQL Server is permitted. This default instance could be one of the clustered instances of SQL Server or a locally installed SQL Server version on either node. The locally installed SQL Server version could be a Microsoft Data Engine (MSDE) installation or a local installation from any one of the following SQL Server versions:
• Desktop
• Standard
• Developer
• Enterprise Edition
All other installed instances must be named instances.

------------------------
Best Regards,
eUKShane
http://www.eukhost.com