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.
Thanks
Jihad 0
Light Poster
peter_budo 2,532
Code tags enforcer Team Colleague Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.