Stockejozoze

 Just a quick post that you can use to check your SQL Server login properties Very helpful to keep an eye on the password policies and login state It's also something that you can use to see how many failed logins are occurring, and when /* login properties */ SELECT name SQLLogin, CASE WHEN is_policy_checked = 0 THEN 'Disabled' Right click the instance name and click Properties Select the Security page Change Server authentication to Windows Authentication mode for Windows logins only or SQL Server and Windows Authentication mode to allow local SQL logins and Windows logins Click OK to save changes SQL Server requires ALTER ANY LOGIN or ALTER LOGIN permission on the server SQL Database requires membership in the loginmanager role Create a login using SSMS for SQL Server In Object Explorer, expand the folder of the server instance in which you want to create the new login Rightclick the Security folder, point to New, and select Login Sql Server Logins Back To Basics Techne...