In SQL Server you can create users using T-SQL or using the options provided by SQL Server Management Studio. CREATE LOGIN sql_user WITH PASSWORD = 'sql_user_password' MUST_CHANGE , DEFAULT_DATABASE = defDB , CHECK_EXPIRATION = ON , CHECK_POLICY = ON...
Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. (Microsoft SQL Server, Error: 18486) SQL server has local password policies. If policy is enabled which locks down the account after X number...
Last day I was working on SQL server and I got this strange error --------------------------- Microsoft SQL Server Management Studio --------------------------- Cannot find template file for the new query ('C:\Program Files\Microsoft SQL Server\90\Tools...