Post reply

How to get the password for User 'Sa'

  • February 17, 2010 at 10:08 pm

    #386331

    Hi,

    I have SQL server 2005 installed on my machine. I am able to log on to server using windows authentication, but when I try to use SQL server authentication, using user as 'sa' and the default paswrd, It gives me error as "Login failed for user 'Sa'. This user is not associated with a trusted SQL connection.

    How do I know passwrd for user sa.

    Thanks in advance.

  • February 17, 2010 at 10:18 pm

    #1120654

    What is the authentication mode for this server? From the error it seems that you are using Windows authentication mode. If you want to use SQL logins it needs to be set in mixed mode. More info about the error can be found here. It's a page for SQL 2000 but the idea is the same. To change the authentication mode have a look at this from MSDN.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • February 17, 2010 at 10:39 pm

    #1120664

    Is this your local desktop? Or is it a server that is used by several people?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 17, 2010 at 10:53 pm

    #1120668

    Thanks a lot..

    my problem got solved now:):)...

  • February 17, 2010 at 10:54 pm

    #1120670

    Would you mind divulging how you solved it?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • February 18, 2010 at 2:18 am

    #1120737

    Hi,

    I have changed the authentication mode of my sql server.

    earlier it was selectd as "Windows Authentcation".. have changed it to SQL Server and Windows Authentication Mode...

  • February 18, 2010 at 10:46 am

    #1121118

    Thanks for posting back. Good to know it is working now.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply