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
Recommended Answers
Jump to PostPassword length probably hasn't changed, I think SQL just standardizes how it displays the ******* so people can't tell how long it realy is. Password (and correct me if I am wrong), I do not think is kept by SQL as plain text.
With respect to the log-in, check …
All 4 Replies
ericstenson
5
Posting Whiz in Training
Team Colleague
majestic0110
commented:
A valuable and helpful poster, good work!
+2
ericstenson
5
Posting Whiz in Training
Team Colleague
Jihad
0
Light Poster
majestic0110
187
Nearly a Posting Virtuoso
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.