Post reply

cant login using 'sa' in MSDE

  • June 10, 2003 at 7:58 pm

    #80368

    Everytime I do, (using SQL Query Analyzer), I get a message like this

     Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

    I already modified the password using EM. Still no luck. Please help.


    "The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett

  • June 10, 2003 at 10:12 pm

    #460682

    SQL Server has to be configured with 'windows and SQL Server' authentication. You can do it from EM --> Propereties --> security tab.

  • May 2, 2004 at 2:36 pm

    #504938

    I have the same problem but I've tried by creating a new account with owner rights to all databases and I still get the following error when connecting with query analyzer

    Unable to connec to server SERVERNAME

    Server: Msg 17, Level 16, State1

    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

    [font="Verdana"]Sal Young[/font]
    [font="Verdana"]MCITP Database Administrator[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

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