I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode.
Then I created a login, named it jihad and changed the password for that login. Then I gave that login some roles. I logout. Tried to login with jihad, got this error message:
Cannot connect to myserver.
login failed for user 'jihad'. The user is not associated with a trusted SQL server connection.
(Microsoft SQL Server, Error: 18452)
I login in with windows authentication again and noticed that the length of the password for login jihad has changed.
I need to know whats wrong with the login, and why the password length has changed.