Fix:VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’
Yesterday, one of the app user was complaining that he is not able to execute some of the queries and…
7 years ago
logins
Fix Error 15190: There are still remote logins for the server ‘DBSERVER’.
I got this error 15190 while renaming SQL Server Instance name. I was not able to drop the existing SQL…
7 years ago
How to Find When SQL Server was Installed?
Have you ever thought when SQL Server instance was installed on your machine? If you don't have idea about finding…
7 years ago
Fix Error 18452: Login failed. The login is from an untrusted domain
Recently a user has reported error 18452 while connecting to database server. Full description of this error is given below:…
7 years ago
Fix SQL Server Error 4064: Cannot open user default database. Login failed.
Today, I got Microsoft SQL Server error 4064 while I was trying to connect to my SQL Server Instance using…
7 years ago
SQL Server Alwayson Error 35250: Joining database on Secondary Replica resulted in an error
We got this Microsoft SQL Server error 35250 while configuring Alwayson Availability Group on one of the SQL Server Instance.…
8 years ago
Fix SQL Server Error 976: Cannot connect to Secondary Replica of AlwaysON Availability Group
Today an application user has reported that he is not able to connect to the secondary replica of AlwaysOn Availability…
8 years ago
Fixing Error “User is not in the sudoers file. This incident will be reported.”
I got this error during one of the activity when i was not able to perform it because my user…
8 years ago
Fix SQL Server Error 15433, Level 16, State 1: Supplied parameter sid is in use
I got Microsoft SQL Server error 15433 during fixing orphaned users on a SQL Server Instance where AlwaysON Availability Group…
8 years ago
Create a Logon Trigger to Restrict sysadmin logins to connect to SQL Server for given Time Interval
I was struggling with unwanted modifications of SQL Server configurations by random SQL Server sysadmin logins who were part of…
8 years ago
Fixing SAP Connectivity issue after AOAG Automatic failover
We have Alwayson Availability Group configuration for our SAP systems. We faced SAP connectivity issue when application team tried to…
8 years ago
Fix SQL Server Error 15170: Login owns one or more Agent Jobs
I got Microsoft SQL Server error 15170 while removing a SQL Server login on one of SQL Server Instance. Microsoft SQL…
8 years ago
Fix SQL Server Error 15434: Could not drop login ‘Domain\abc’ as the user is currently logged in
Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to…
8 years ago
Fix SQL Server Error 15141: The server principal owns one or more endpoint(s) and cannot be dropped
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn…
8 years ago
Fix SQL Server Error 15173: Revoke the permission(s) before dropping the login.
A login was failed to drop from a SQL Server instance with an error code 15173. As Microsoft SQL Server…
8 years ago