Set up a group managed service account for SQL Server Engine and Agent, then verify permissions, SPNs, and Kerberos connections.
SQL SERVER – Upgrade Error: The Server Principal is Not Able to Access the Database “msdb” Under the Current Security Context
The Upgrade Error messages shown in ERRORLOG was “The server principal “SQLAuthority\AuthOwner” is not able to access the database “msdb”
SQL SERVER – DBCC CLONEDATABASE Error – Msg 2601: Cannot Insert Duplicate Key Row in Object ‘sys.sysowners’ With Unique Index ‘nc1’.
Another DBCC CLONEDATABASE error, Msg 2601: cannot insert duplicate key row in object ‘sys.sysowners’. Here is why it happens and the workaround.
SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure
First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.
SQL SERVER – FIX: Msg 7416 – Access to the Remote Server is Denied Because No Login-mapping Exists
In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.
SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted
In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.
SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File
While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.