Is it possible to have 2 separate SQL Server instances mirrored to one SQL Server Mirror / Fail Over Partner?
View Complete Post
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?
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
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
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 ?
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.
Summary=============================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)"
Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft Visual Studio)
ÃÂ ÃÂ 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
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
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:
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?