Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    13

    Unanswered: MS SQL 2005 Express Authentication

    I have trouble with Authentication.

    In SQL Server Configuration Manager I clicked on Properties;
    There are 3 tabs: Log On, Service, Advanced
    Under Log On there are:
    Built-account
    This account
    At "This account" I'm able to set only Windows credentials which are used for logging on to system, also. This is done.

    From Microsoft Server Management Studio Express I choose SQL Server Authentication, type Windows credentials;
    I get Error message which shows that Login and Password are incorrect.
    Suddenly, when I chose Windows authentication -login is successful.


    How can I log on via SQL Server Authentication (Login, Pass)?


    Regards

    P.S.
    SQL Server Authentication is necessary

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Tokajac
    In SQL Server Configuration Manager I clicked on Properties;
    There are 3 tabs: Log On, Service, Advanced
    Under Log On there are:
    Built-account
    This account
    At "This account" I'm able to set only Windows credentials which are used for logging on to system, also. This is done.
    This refers to the account the SQL Server service runs on.

    Quote Originally Posted by Tokajac
    From Microsoft Server Management Studio Express I choose SQL Server Authentication, type Windows credentials;
    I get Error message which shows that Login and Password are incorrect.
    Suddenly, when I chose Windows authentication -login is successful.
    This is using an account to authenticate a connection with SQL Server. You either authenticate with Windows, or you create a SQL Server login and password that you can then use to authenticate a connection.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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