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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

bootstrapping config process when there are two instances on server!

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :Sql 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.

http://msdn.microsoft.com/en-us/library/bb500430(SQL.100).aspx

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,

Josh

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


View Complete Post


More Related Resource Links

CI Server: Redefine Your Build Process with Continuous Integration

  

Jay Flowers demonstrates how to set up and use a Continuous Integration server using both discrete tools and the more comprehensive CI Factory solution.

Jay Flowers

MSDN Magazine March 2008


All my server-controls became unrecognized!!! like there's compilation error or web.config missing!

  

hi!

please help - the problem is in post subject.

I have lots of warnings with following text:

"Warning 10 Element 'HyperLink' is not a known element. This can occur if there is a compilation error in the Web site, or the web.config file is missing. C:\Users\Pavel\Documents\Visual Studio 2010\WebSites\BioWebSite\ToScientist.aspx 26 18 C:\...\BioWebSite\" 

But web.confg is there! And there's no compilation error!

Site builds just fine. And If I upload it to my hoster - it works!

 

But with all these errors I cant add controls to pages - VS2010 adds hyperlink without ID, and intelisens stoped to work.

Strange, but in my other project (web-application) I have no such difficuty.


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

Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

  
Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

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.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

  
hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   

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.  

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server

  
System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server 

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

Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

  
Hello All, Suddenly, the sql server is down, in the log file, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG, I found the record as follows, 2007-03-05 15:40:31.59 Logon       Error: 17189, Severity: 16, State: 1.2007-03-05 15:40:31.59 Logon       SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 172.21.123.48] What else I can do to further investigate? Thanks Spencer

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

Failed to generate a user instance of SQL Server due to a failure in starting the process for the us

  
Hello,Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I'm using SQLServer2005 and VWD2010. Did the following below but to no avail. 1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart.  2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server. Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.I'm using SQLServer2005 and VWD2010. I Did the following below but to no avail.1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart. 2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server.Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.Thank You,-imperialx

COM Server process compiled with /clr option doesn't unload itself from memory when last COM client

  
I created Visual C++ ATL project in VS2010, exe type, imlemented COM object, then added /clr option to project. Project uses other C# dlls (WCF service). When last COM client disconnects and last COM object instance destroys, WCF service stopped, my COM server process doesn't unload itself from memory. All managed threads in C# dll are background, COM object doesn't create threads. How can I unload server process? Thank you in advance. 

Server Farm and machine.config machineKey value mismatch

  
Hi,I'm writing an application that is deployed on web server farm. I've tried to get the machineKey from all the servers but admins have denied my request stating security concern. I have no way of knowing if they match or not. This is the error I get sometimes-------------------------------------------------------------------------------------------------------------------------------------------------------------------------- System.Web.HttpException: Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster. ---> System.Web.UI.ViewStateException: Invalid viewstate.    Client IP: 93.84.191.140   Port: 49194   User-Agent: Mozilla/5.0 (iPhone Simulator; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Mobile/7A341   ViewState: /wEPDwUJOTczMzM0ODk3ZGSqcWCbsDoMeHnkNaxb9+0vLuiJVw==   Referer: http://mobile.cch.com/MobileZipSalesLookup/Result.aspx   Path: /MobileZipSalesLookup/Email.aspx ---> System.Web.HttpException: Unable to validate data.     at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& data

C# COM Client to Existing C++ out-of-process COM Server

  
I'm reposting this question since I've been having some problems with my MSDN subscription, hoping I might have some better assistance now that aforementioned problems seem to have been resolved. I'm trying to connect a COM client written in C# to an existing (legacy) out-of-process COM server written in C++. I have imported the tlb using tlbimp.exe and have referenced the RWC in my project. I can connect to the COM server using object scComm32ComObj = Marshal.GetActiveObject("ScComm32.Document"); But that is as far as I am able to get. I need to be able to call some methods on the ScComm32CommObj, but trying to cast it to an interface or a class usign the interface results in an exception. Thanks, Bill

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
Categories: 
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