Results 1 to 3 of 3

Thread: Query Analyzer

  1. #1
    Join Date
    Feb 2002
    Location
    India
    Posts
    38

    Unanswered: Query Analyzer

    hi to every one
    i have been working with query analyzer in Client tools
    When ever i try to open a query analyzer it is locating my Database but it is always asking the sa password ( my db has sa password ).

    So my question is how to save my password for all times.

    Will it be possible.

    Thanks.
    -- Prasad --

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    if you are using server side authentication you will always be asked to supply a userid and password. Each new instance of a query in Query Analyzer starts a new connection. You can not store this info. Can you use NT Authentication? This would solve your problems.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    May 2002
    Location
    Montréal, Canada
    Posts
    28
    In EM, disable the option 'always prompt for login name and password' on the 'Registered SQL Server properties' panel, for the account sa.
    Data Climber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •