Use a server-level credential when you need to use the same credential for multiple databases on the server. Use a database-scoped credential to make the database more portable. When a database is ...

The previous vendor never gave credentials to the SQL server, and there's a reason that they are the PREVIOUS vendor. IT manager claims that we should be able to use the Server admin to get into ...

To ensure that both the SID and the password are the same, Microsoft has written a stored procedure, SP_HELP_REVLOGIN, to aid in our transfer. SP_HELP_REVLOGIN will return a complete list of the ...

We have our SQL server configured to only allow Windows accounts (i.e. not mixed). However, in some cases we are connecting from non-domain boxes and we want to specify a domain account to connect ...

Sentrigo issued a free tool this week to erase stored passwords in SQL Server. Microsoft recommended end-users review its security guidance and guidelines literature.