SQL Server Service fails to start after applying patch. Error: CREATE SCHEMA failed due to previous errors.

In this post we would like to explain one of the interesting issues that we encountered while upgrading a SQL Server Instance. Symptoms SQL Server Service fails to start after applying SQL patch due to misconfiguration in MSDB. Error:- 2016-06-28 19:23:41.22 spid5s    Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error…

0

Setting up Service Broker where the initiator database is part of the AG

  There have been several posts on setting up Service Broker where the database is part of the Availability Group. This is a one stop blog for setting up Service Broker where the initiator database is part of the AG What happens when the AG fails over? Should there be any additional steps in setting…

0

Error configuring distribution- "Publishing and distribution are supported only in SQL Server version 7.0 or later"

  I recently installed an instance of SQL Server 2016 on one of my server. Later when I tried to configure the new instance as Distributor I faced the below error: Error: —————————— TITLE: Configure Distribution Wizard —————————— ‘Prod\SQL16’ cannot be configured for publishing and distribution. Publishing and distribution are supported only in SQL Server…

1

How to find which user deleted the user database in SQL Server

  In one of the recent scenarios we noticed that a user database was deleted and customer wanted to which user has dropped the database. We know that multiple user had full access on that database. In this post I’ll be sharing the steps to find the details of user who drop the database. Method-1…

0

Snapshot agent fails with Error: 241, Severity: 16, State: 1 (Conversion failed when converting date and/or time from character string)

ISSUE Let’s say you are monitoring Replication Agent status and noticed that the Snapshot Agent has failed with the following error while generating a snapshot, particularly during creation of BCP files. Error: 241, Severity: 16, State: 1 Conversion failed when converting date and/or time from character string. To further investigate the above error and to…

1

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