Common issues faced while configuring AlwaysOn listener on Azure VM cluster

We have MSDN article [Tutorial: Listener Configuration for AlwaysOn Availability Groups (http://msdn.microsoft.com/en-us/library/dn425027.aspx) which provides detailed steps to configure AlwaysOn listener on Azure VM cluster. This article provides steps that can be followed to resolve commonly faced issues. Important consideration: All SQL Server virtual machines on Azure should be in the SAME cloud service for AlwaysOn…

0

Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group

  When you are auditing successful logins attempts using SUCCESSFUL_LOGIN_GROUP action group through SQL Audit, you will see that there will be too many entries in the audit file. You may see this behavior for successful logins when connections are made through SQL Server Management Studio. This occurs because for every successful login through SSMS…

0

Script level upgrade for master database failed

  In this post I would like to explain one of the interesting issues that I encountered while upgrading a SQL Server Instance. Symptoms · SQL Server instance is upgraded using a service pack or any other update. · After the upgrade SQL server service starts but it stops in next few seconds. · When…

0

Merge Replication: Expired Subscription Clean Up Job / sp_expired_subscription_cleanup / sp_MScleanup_conflict fails with error Msg 1934, Level 16, State 1 AND Msg 20709, Level 16, State 1, Procedure sp_MScleanup_conflict…??

  Issue: If you have a Merge Replication, you may encounter the below error message thrown by Expired Subscription Cleanup job (sp_expired_subscription_cleanup) with a mention of conflict table of an article for the publication as below: Msg 1934, Level 16, State 1, Line 1 DELETE failed because the following SET options have incorrect settings: ‘ANSI_NULLS,…

0

SQL Server 2014 Setup Error: ‘BIDS’ is not a valid value for setting ‘FEATURES’

SQL Server Data Tools (a.k.a. SSDT) used to part of product installation media in SQL Server 2012. We can install it by selecting "SQL Server Data Tools" from shared features section. Alternately we can install it using SQL Server 2012 setup.exe using command prompt setup.exe /QUIET /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES="BIDS" /INDICATEPROGRESS=True. But in SQL Server 2014,…

1

Troubleshooting : Error: 8624, Severity: 16, State: 21. Internal Query Processor Error: The query processor could not produce a query plan.

Sometimes we see the below error in SQL Server 2008 R2 SP1 when executing a query in SQL Server Management Studio: ————————————————————– Error: 8624, Severity: 16, State: 116. Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. ————————————————————–   So, how to handle this…

3

How to move databases configured for SQL Server AlwaysOn

How to move databases configured for SQL Server AlwaysOn   This article describes how to change the location of the data files and the log files for any Microsoft SQL Server 2012 database which are configured with SQL Server AlwaysOn with minimal downtime. Considerations We have three node windows 2008/2012 cluster where SQL server is…