[SQL 2012] multiple instance failover solution |
| multiple instance failover solution Posted: 26 Apr 2013 02:15 AM PDT I need to create a solution for a mutl instance (needed by 3rd party app) 2012 failover solution. I will have 2 physical high end servers (128 gig of RAM), plenty of CPU power. It will be implemented on Standard edition (could possibly change that) 1st thought was an simple active passive cluster (I am assuming you can do this with the multiple instances?). ANy other ideas on a novel approach? |
| SSIS Project Dynamic OLEDB question Posted: 26 Apr 2013 12:54 AM PDT I have a project which I will need to deploy to servers not in our network and thus will not know certain attributes such as the server and database names. So I set up a parameter in the "Project.params" area. In this string parameter I placed: "Data Source=" + @[$Project::ServerName] + ";User ID=" + @[$Project::UserName] + ";Initial Catalog=" + @[$Project::InitialCatalog]; + "Provider=SQLNCLI11.1;Persist Security Info=True;" I copied the connection from the original one I set up before attempting this.When I set the project level OLEDB Connection manager to this parameter in an expression (for the connection string), I get the string just as I typed and not the values of the other parameters. In other words when evaluated the expression appears just as above. Doing so invalidates all of the components in the package which use the connection. Any ideas on what I am doing wrong? Thank you in advance. |
| Posted: 25 Apr 2013 08:13 AM PDT We just recently upgraded from SSRS 2005 to SSRS 2012. I have a report with two tables using two different datasets. The first table displays data correctly, but the second displays no data found (custom). If I run the report and do a SQL Server Profiler trace, I see the stored procedure and the parameters passed hitting the database server. If I copy the stored procedure execute statement from profiler and paste it into SSMS, data is returned. Any ideas why my table is not being populated with the data? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment