Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
Not sure what I am doing wrong so I have included the parameters I used which I used the existing login and this article for reference: http://itproguru.com/expert/2014/09/how-to-fix-login-failed-for-user-microsoft-sql-server-error-18456-step-by-step-add-sql-administrator-to-sql-management-studio/ Whatever I do I get the Error: 18456 message.
Ok found the answer after an hour of trying various options.
Server properties - Security (see image)
Shame there is no warning message somewhere when you create SQL Authentication users that they have no access.
