Unable to install SCOM 2012 Reporting Services

Problem description: you are trying to install SCOM 2012, and the SQL Server reporting service 2012 part failed.   Error message:          –> Inside SCOM Setup installation, you got the error message below eThe specified SQL Server instance is not valid.  The possible causes of this problem include the following:* SSRS has not been configured correctly*…

0

How to create a dependency between two or more Availability Groups

Hi all,   Problem description: I got a specific scenario where I have to failover two or more AlwaysOn Availability Groups in the same time.  To explain by another way, I have to create a dependency between 2 Availability Groups. If one of them failover, the second one has to move also on the same…

1

How configure correctly AlwaysOn readable secondary replica for applicationIntent

  Hi all,   I would like to share with you an issue that I got recently because  I didn’t set  up correctly AlwaysOn to enable readable database on the secondary replica.   Problem description: When I am trying to connect to my application with .Net or PowerShell, I got the following issue only when I…

1

Keyword not supported: 'applicationintent'

  Problem description: When you try to connect to  your SQL Server by using powershell, .Net, sqlcmd… you got this error message: System.ArgumentException: Keyword not supported: ‘applicationintent’.   at System.Data.SqlClient.SqlConnectionStringBuilder.set_Item(String keyword, Object value)   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)   Cause: The message occurs when you include ApplicationIntent=ReadOnly (AlwaysOn Availability Groups properties) in your connection string. And  the server…

0

Installation of SQL Server 2008 clusters on Windows 2008 Step 4 : Add a new node

Installation step by step of SQL Server 2008 clustering on Windows 2008     Step 1 : Validation wizard    Step 2 : Pre-check    Step 3 : Installation of the first node    Step 4 : Add a new node     Step 5: Apply a service pack or hotfix on a SQL cluster 1. Start the installation from…

0

Installation of SQL Server 2008 clusters on Windows 2008 Step 2 : Pre-check

Installation step by step of SQL Server 2008 clustering on Windows 2008     Step 1 : Validation wizard    Step 2 : Pre-check    Step 3 : Installation of the first node    Step 4 : Add a new node     Step 5: Apply a service pack or hotfix on a SQL cluster 1. Pre-check the system to…

0

Installation of SQL Server 2008 clusters on Windows 2008 Step 1 : Validation wizard

Installation step by step of SQL Server 2008 clustering on Windows 2008     Step 1 : Validation wizard    Step 2 : Pre-check    Step 3 : Installation of the first node    Step 4 : Add a new node     Step 5: Apply a service pack or hotfix on a SQL cluster Before to  begin I invite…

1

Installation of SQL Server 2005/2008 clusters on Windows 2003/2008

Installation SQL Server 2005/2008 failover clusters on MSCS Windows 2003/2008 The installation process between SQL Server 2008 and 2005 failover clusters are different. With SQL Server 2008 in cluster you must run the setup process for SQL Server individually on each node of the failover cluster. To add a node to an existing SQL Server…

0