DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)
-   MS SQL (http://www.daniweb.com/forums/forum127.html)
-   -   check this error in login (http://www.daniweb.com/forums/thread121553.html)

Jihad Apr 29th, 2008 10:01 am
check this error in login
 
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

peter_budo Apr 30th, 2008 7:10 am
Re: check this error in login
 
Official Microsoft solution, plus more from google


All times are GMT -4. The time now is 5:20 am.

Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC