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

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

Is it possible to have 2 separate SQL Server instances mirrored to one SQL Server Mirror / Fail Over

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Is it possible to have 2 separate SQL Server instances mirrored to one SQL Server Mirror / Fail Over Partner?



View Complete Post

More Related Resource Links

Can two SS instances on one server support two separate farms that are each on their own server?


I have a configuration of a named SS instance using a custom port on a server supporting a MOPS+SPFS instance on a second  server (versions are MOPS2010, SP2010, Win2008R2x64 & SS 2008R2x64).  I have been asked to support a second MOPS/SP2010 instance that will be on a third server, by adding another instance of SS to the existing DB server.  The two SPs will be independent farms (one for development, one for testing).

Is this a workable configuration?

What special steps are required for Reporting Services (SP integrated mode) and Analysis Services for the second instance?

What special steps are required for the second SP that will access the second instance of SS?

Distributed Transactions fail on Linked server

We get the below error while performing a distributed transaction on linked server. We have several linked servers configured in the source server and all of them succeed with the distributed transaction except on one.   We did all the basic troubleshooting and moreover the distributed transactions work fine if we use a remote server instead.   Need your expert guidance in resolving this issue     Error:   OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" returned message "No transaction is active.". Msg 7391, Level 16, State 2, Line 3 The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "SERVERNAME.REDMOND.CORP.MICROSOFT.COM" was unable to begin a distributed transaction.     Test code:   begin distributed transaction   select top 10 * from [SERVERNAME.REDMOND.CORP.MICROSOFT.COM].master.sys.objects   ROLLBACK     Source server :      Microsoft SQL Server 2008 (RTM) - 10.0.1779.0 (X64)        Nov 12 2008 12:10:04        Copyright (c) 1988-2008 Microsoft Corporation        Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (VM)     Target server :     Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)        Jul  9 2008 14:43:34        Copyright (c) 1988-2008 Microsoft Corporation        Enterprise Edition

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

Detect other versions of SQL Server, or SQL server instances on a computer

Hi All, I want to detect other versions of SQL Server, or SQL server instances on a computer. I used the recommended Microsoft C# example by using the SQL Server Windows® Management Instrumentation (WMI) provider. http://msdn.microsoft.com/he-il/library/dd981032(en-us,SQL.100).aspx SQL server 2005 has been correctly identified on my PC with Windows 7 64 bit OS. Then I uninstalled the SQLserver and all its tools/components. But even after uninstall the utility detects the SQL server 2005 as if it was not removed. What is an alternative for the correct detection of the SQL server installed on PC? Thanks in advance Dmitry

Different SQL Server instances on one server

Good afternoon. I have a Windows Server 2003 with SP2 loaded. On it I have SQL Server 2000 - 8.00.760 SP3 Developer Edition along with SQL Server 2005 - 9.00.1399.06 RTM Developer Edition. Can I also install an instance of SQL Server 2008 on this server without cauing a problem with the otherSQL instances? Thank you.

SSRS2005: Is it safe to manually remove instances from the Keys table in the report server database?

I have a problem with redundant reporting services instances still hanging around in the initialization pane of the RS configuration wizard and I can't get rid of them. The problem arose when we had new webfarms and before I had removed all references to the old ones from the initialization screen, the old webfarms had been switched off, removed from the network and dismantled. Therefore when I try to 'de-initialize' them, I get an error stating that reporting services cannot connect to them and when I run reports, a fair few are trying to run on the old webfarms which no longer exist and are disappearing into the void. There's a table in the report server database called Keys whch contains details of these intances and i'm wondering if its safe to remove these via SQL commands without breaking reporting services on other machines.   As a side note: All this stems from the fact that when you uninstall Reporting Services, not all of the files / references are removed. So as a general word of warning, if you do an uninstall of RS2005, you'll need to make sure everything's gone before re-installing, throwing away old machines etc. These include folders in IIS and these old instances as mentioned above.  

Can I have two instances (SQL 2005 - 2008) at the same server?

Hello, I have a Windows 2008 R2 with sql server 2005 x64. I would like to have both instances (SQL server 2005 x64 and 2008 x64) at the same server, each one having its own databases. Is the possible? What should I pay attention to? Thank youChristos

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

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

bootstrapping config process when there are two instances on server!


Have a package (several actually) that first reads c:\apps\config\mypackage.dtsconfig.  This sets the servername and catalog for my database and the main bunch of config values from an SSISConfigurations table.  Let's make believe we just *have* to use that table to hold the real config values.  Well, this all worked fine until they decided to put a second "test" environment on the dev server.  When a package is loaded in the test environment, it should use the test instance, etc.  But it shares the c:\apps\config folder with the other instance!  So now, I have trouble (at least) bootstrapping the configs into the proper environment.  This is SQL 2008, btw, which seems to be extremely important as to the order in which configs are applied.


Has anybody dealt with this?

I think I can squeeze through here as long as I only have to finagle this in dev/test, and production only has a single instance.  Do you see why?

Of course the goal here is to let the package configure correctly without opening it up and changing stored values just to move between environments.

Help!  and TIA,


ps - yes it would be nice if you could put a "p

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?

How to Install MSDTC on a multi Instance SQL Server Fail OverCluster (SQL 2005 & Windows 2003 R2 x64


I am installing 2 SQL instances on a fail over cluster.

Currently I have my Quorum and DTC resources on the default Group and the 2 sql instances on 2 other groups.

In this way would the DTC resource  be available for both the SQL groups or is there any other way i should go about doing this ?

Error opening site using SPSite and SPWeb instances using VS 2010, Win Server 2008 R2


Hi I am trying to open my site using SPSite and SPWeb instances and getting an error message as below-

The Web application at http://url could not be found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

  CODE is -



                    SPSite siteCOll = new SPSite(siteURL);

                    SPWeb oWeb = siteCOll.OpenWeb("url");



I can access site using browser perfectly.

I am running VS as administrator.

I have done permission checking aswell.


please help!





Three instances of SQL server

can I install one instance SQL server 2008 and two instances SQl server 2008 express on the one computer (Windwos server 2008 standard)?
Thank You

Savng SSIS package might fail with "Library not registered" after you install SQL Server 2005 SP2


After installing SQL Server 2005 SP2 you try to change the SSIS package and when you try to save it. it might fail with the below message:

- File - save copy of package
- Package  location = SSIS package store
-Server - <instance name>
- Aunthentication = windows authentication
- gave the package path
- Under Protection level - REly on server storage and roles for access control
- Wehn we click on OK it fails with:
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SqlServer.DTSRuntimeWrap)"

Error details:

Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft Visual Studio)

Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)
   at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
   at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventAr

WSS 3.0 seach fail after migration from Windows Server 2003 with SQL 2000 to Windows Server 2008 wit


Hello we have a WSS 3.0 on a Windows Server 2003 with a single site, and we are trying to migrate it to another server with Windows Server 2008. All database are on a Microsoft SQL Server 2000.

We installed WSS 3.0 from scratch on the new server. We put the default databases on a server with Microsoft SQL Server 2008.

Then we made a backup in the production server with the following command: stsadm -o backup -url https://portal -filename musa.bak

After that we restored the backup in the new server with the following command:  stsadm -o restore -url https://uymvd18 -filename c:\sharepoint\portal-2010-10-05-21-00-06.dat -overwrite

(portal is the name of the old server and uymvd18 is the name of the new one)

Everything worked ok, but the when we try to do a search in the new se

Enable User Instances in SQL Server


I'm just starting out and trying to connect to my first database using the following string:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\RFPdb.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

I get the following error during debug:

"Generating user instances in SQL Server is disabled. Use sp_configure 'user instances enabled' to generate user instances."

I've done this on every database - Master, Model, Tempdb, etc, and my database.

Still get the error.  I may not be enabling it correctly.  Any help would be appreciated.

The documentation suggests that I use user instances so that users without Admin rights can work with the database.  Add, delete, edit data.  Is this true?


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