.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Multiple Sql instances in a cluster

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server


I have a need to add a second Sql instance to an existing cluster. However I read in this article http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

that this is not recommended. Does anyone know why this is or what problems I may encounter?

Its is running Sql 2005 on a 64 bit windows Server 2003.

View Complete Post

More Related Resource Links

Multiple Instances of User Control


I have a user control that I place on a page severl times.  When I make a selection on a ddl in one one control the SelectedIndexChanged event fires for all the control on the page for that ddl.  So I get duplication of an insert that I do.  Is there a way to make sure these events are isolated so this doesn't happen.


How to run multiple instances of workflow



I've created simple sequential workflow. It's only creates one task and is waiting in while loop until task is Approved. It works fine when I run only one instance of this workflow, but if I start another instance before first one is finished it gets stack and doesn't complete task an workflow stays in In Progress state forever.

Network failure in Cluster Environment,will it stop the SQL Server Instances?

Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

multiple instances of report manager VS multiple users

Hello, I want multiple users to access same report or different reports through report manager for a report server. Will the scenario of opening multiple windows of report manager on same machine and execute reports from all windows simultaneously mean same as multiple users accessing the reports at the same time? If not, then how should I generate the scenario of multiple users? Regards.

How to use single windows service to host multiple WCF Services instances (Each instance of WCF is i

How to use single windows service to host multiple WCF Services. I have a mutiple instance of same WCF service in different folder, each instance has unique service name and port. WCFService has reference to Reg-Free COM Reference, i have Native.WCFService.manifest in each folder. Ex: WCFService1 is in "C:\WCFService01\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config WCFService2 is in "C:\WCFService02\WCFService.dll, Native.OCWCFService.manifest, OCWCFService.dll.config Now i need host above services from single Windows Service. I am trying to create AppDomain for each above WCFService Instance from Windows Service and then host. Its working if i register COM dll in the server using regsvr32, but when i un register COM dll, i am getting unable to load COM component .... This looks like AppDomain is not loading COM DLL and Manifest files. Its looks strange but we need it in this way because we have production and test environment in the same server. Everything works fine if create a seperate Windows Service for each WCFService Instance, but my manager wants single Windows Service :). Any help whould be really appreciated.  ravi kumar reddy

Rebooting one Instance on a SQL 2008 Server with multiple instances installed

Hello, Hoping someone can answer the following questions ... If I have SQL Server 2008 with multiple Named Instances configured on it, can I reboot one Named Instance without rebooting any of the other Named Instances, or without having to reboot the entire server ? For example, if I have an application that needs to be re-booted and it requires the Database to be re-booted. Regards, JD

Multiple Instances Same User Control

I have an ASP.NET page inside of an ASP.NET Master page, and inside the page I have two instances of the same web user control. I have given them different IDs, but when I click a button on the first user control it causes the second user control to do the expected activity and the first one does nothing. Is there something I need to do to make sure that the controls don't get confused? P.S. The expected activity is that when the button is clicked one panel object is disabled and another is shown. When the button is clicked on custom control 1 the panel on custom control 2 is disabled and it's next panel is shown and custom control 1 does nothing. Thanks for the help. 

Installing multiple instances of SQL Server R2 creates permissions issues - first instance won't st

After installing two named instances of SQL Server 2008 R2 DataCenter edition (R2D2 and C3P0) I found the first instance would no longer start.  The errorlog showed the reason to be an invalid path. 2010-09-14 18:15:39.12 Server      Error: 17113, Severity: 16, State: 1. 2010-09-14 18:15:39.12 Server      Error 3(The system cannot find the path specified.) occurred while opening file 'C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary. Finding the files in the proper location I check the ACLs and found the Local Group created for the second instance on the ACL for the first instance.  That is to say for instance R2D2 I found MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0 instead of the MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$R2D2 that was originally there. C:\MSSQL\SQLDAT\MSSQL10_50.R2D2\MSSQL\DATA>icacls master.mdf master.mdf NT AUTHORITY\SYSTEM:(F)            BUILTIN\Administrators:(F)            MSP-JANHONJ7\SQLServerMSSQLUser$MSP-janhonj7$C3P0:(F) It seems that creating the second instance causes this problem.  I have been u

integation services and multiple instances - no backdoor?


When I try to deploy an SSIS package to the second instance on my server, I get a nasty message to use the default instance because the service does not support multiple instances.

So, ... just because the "service" won't support multiple instances, does that mean what it sounds like it means, that there is NO WAY for us to put a second (test) instance on the same server and have separate packages in the respective msdb's on each instance?

I mean, that seems to be what it's saying, but here we are, all eager to do just that ... so if there was a way to make it work without the service, we might try it.  But maybe dtexec won't even be able to fetch the package from msdb?  I don't want to go so far as to export it manually from the (named instance) msdb to a file just to run it ...

since a cheap workaround is simply to put the dtsx files on a file folder instead of msdb anyway.

(in fact, probably would have been my first choice, if anyone had asked me!)





Multiple instances - max server memory setting?

Please let me know any practical guidelines of max server memory setting if you have multiple instances on the same box. Brand new server and not much of historical data available. What are some safe guidelines and tweaking instructions?

Running Multiple Instances of a VB.Net App EXE



I want to allow the user to be able to run multiple instances of the program like Notepad. The way it is now is like once I run the executable I can not run another instance as long as the first instance is running.

How can I change this behavior at follwoing levels...

  1. At setup level
  2. After installing EXE.

Please suggest.


Please remember to click 'Mark as Answer' on the post that helped you.

How do I add multiple instances of the wiki editor control to a page?


(Sharepoint 2007)

I have a SharePoint wiki site and the home page has become a bit cluttered. Using SharePoint Designer 2007 I have figured out how to edit the home page of the wiki site and I have created a row of tabs with associated content pieces. It's the usual thing, click on a tab, hide one div, show another. What I would like to do is to be able to edit each div's content as a separate wiki page. Is this possible? I currently have the SharePoint:FormField and SharePoint:ListFieldIterator tags commented out.

Thank you for any help you can give.

To create Multiple Instances in windows application?


we are running multiple instances of application.we want to have  connection string seperate for each instance as long as instance is running?

How to achieve?

application created in .net 3.5

Please Help.

How to run application made in vb.net of multiple instances of excel add ins


My project is based on Excel Addins. and when i run my application then open excel and working my project running fine but when i am trying to open multiple excel then this condition my project not worked except single excel when opened. so i would like to work on multiple instances of excel running fine.

Plz help me out if u have any idea regarding this.

Thanks in advance,


Multiple SQL Server installations on different machines vs multiple instances



i've got a question concerning the topology of SQL Servers in a enterprise. Until now we had a single SQL Server to serve the need of user databases throughout the enerprise.
Now were facing a change of our infastructure: The servers will be moved to a Hyper-V machine and we are going to install some application servers, that need SQL Server as backend: SharePoint, System Center Essentials, Data Protection Manager. At least one, DPM, says it is to be designed to run on a dedicated server controlling its own SQL Server.
Now we think of giving each of this servers its own SQL Server. Is this a way to go? Or is it absolute nonsense? Should we try to force all the servers to use named instances on a single SQL Server? Sometimes i have the feeling that SQL Server becomes a part of the OS, so just install it and let the application (SharePoint, DPM, you name it) take over control.

Any advice or opinion is highly appreciated.

Thank you,


Mirroring with multiple instances?


Have a server with 4 SQL 2008 instances loaded on it.  One of these instances is a witness for another set of servers within the organization and has an endpoint already created for database mirroring.

The question here relates to the endpoint.  I want to mirror a DB on an instance other than the one (Witness instance) that does already have the endpoint created.  Do I need to create DB mirroring endpoints for every instance that I want to mirror and give it a different port than the original 5022 that the first one is using?


SPN and Multiple Instances


When i register SPN for a service account(domain account), i specify the instance by set the port of the instance.

If i have more than 1 instance or mutiple SQL server running with the same service account, can i set SPN setting all instances to the same account ?

Or, this is 1 x 1, to one instance, am i have to create 1 service account and set the SPN for this account ?



Eduardo Leal
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend