While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.
SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode
The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we will discuss an error about REBUILDDATABASE.
SQL SERVER – Difference Between Login Vs User – Security Concepts
In this blog post, we discuss the difference between Login Vs User – Security Concepts. They look the same but actually, they are totally different.
SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)
I recently had a very simple and interesting error received while I was performing an upgrade mode with Docker and Persistence Storage for my upcoming workshop.
SQL SERVER – Error: 18456, State 149 – Login-based Server Access Validation Failed With an Infrastructure Error. Login Lacks Connect Endpoint Permission
Sometimes while reproducing a situation results in another new error and I get an idea for a new blog. In this blog we would talk about an error Login-based server access validation failed with an infrastructure error. Login lacks connect endpoint permission.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
One of the most successful offerings from me has been Comprehensive Database Performance Health Check. Sometimes during my assistance, some random issues appear which I try to solve as well. In a recent engagement, one of their developers asked a question about an error which he was receiving while running sp_dropserver. In this blog, we would see how to fix error 15190 – There are still remote logins or linked logins for the server.
SQL SERVER – How to Generate Random Password? – Enhanced Version – Part 2
I have previously written about Random Password before in the blog posts here, here and here. This blog is sent by James Curran, who has created the following generate random password stored procedure keeping the base of the original solution of Tim Cartwright. Thanks to both of this individual SQL Server Expert who has helped me to come up with a more robust solution for a random password.