change password

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » change password

change password

Rate Topic

Display Mode

Topic Options

Author

Message

charipg

Posted Wednesday, December 09, 2009 9:17 PM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 12:43 AM
Points: 378, Visits: 897

i am getting below error when i try to login,i am getting the same error after changing the password also.

Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

Post #831972

Jeff Moden

Posted Wednesday, December 09, 2009 10:01 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:21 PM
Points: 32,893, Visits: 26,765

http://tinyurl.com/ygapycy

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #831981

duocaiduoyi2009

Posted Tuesday, June 21, 2011 9:54 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, August 30, 2011 3:11 AM
Points: 5, Visits: 13

I think the easiest way to solve your problem is to reset your password.
Several days ago, i tried one application named SQL password recovery.
It is very useful, hope it can help you.

Post #1129438

Syed Jahanzaib Bin hassan

Posted Tuesday, June 21, 2011 11:34 PM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481

which user you are using SQL or Windows to access the SQL Server ?

If you are using the SQL Login then this will appear everytime when you try to connect the server because your server is in Windows Authtication Mode

change this mode first to SQL and Windows Authication Mode then connect with SQL User,you have required an admin account of windows to do this

Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com

Post #1129458

« Prev Topic | Next Topic »

Permissions