Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.
I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today.
Question: Can Admin Rename SA Account in SQL Server?
Answer: Yes, of course. The syntax for to rename SA account is very simple:
During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role.
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.
In this blog we would talk about fixing error 7416 – Access to the remote server is denied because no login-mapping exists.