Page 2 of 2 FirstFirst 12
Results 16 to 30 of 30

Thread: Login failed for user 'username"...

  1. #16
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    check your server network utility and see whether anybody disabled TCP/IP and Named pipes protocols.

    if so just enable it and recycle the sql services.

  2. #17
    Join Date
    Mar 2004
    Posts
    13
    SQL7.0 SP4.
    Reinstalling is my last option (maybe the only one). But I was trying to know if there was any specific repair for it that someone applied before.
    Thank you guys anyway for your time and answers.

  3. #18
    Join Date
    Sep 2002
    Posts
    5,938
    jtabio, you have windows accounts only expect sa from your list of sql logins. That means those users should connect to sql server with windows authentication. They have to logon windows with their account then choose windows authentication in either odbc dsn or other sql tools to connect to sql server, can't input their account/password there.

  4. #19
    Join Date
    Mar 2004
    Posts
    13
    Mr rmiao, if you read all my answers
    carefully you will understand that what you are point to is not related to this problem. Thanks anyway.

  5. #20
    Join Date
    Sep 2002
    Posts
    5,938
    This is from your fist post: 'How can be fixed this problemm, to have the Windows login accepted by the SQL server?'. And my response was that to have the Windows login accepted by the SQL server, you have to use windows authentication to connect to sql server.

  6. #21
    Join Date
    Mar 2004
    Posts
    13
    Yes, but read please the whole first post and you will see that I am referring that using the Windows logins
    is not possible to connect.
    If you follow the whole secuence of postings, you will realize that a whole set of possible checkings were already made in relation to Windows logins in the SQL server.

  7. #22
    Join Date
    Sep 2002
    Posts
    5,938
    I know you checked those accounts in sql, but my point is use which authentication model to connect to sql for those accounts.

  8. #23
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Re-Posting

    check your server network utility in your server and see whether anybody disabled TCP/IP and Named pipes protocols.

    if so just enable it and recycle the sql services.

  9. #24
    Join Date
    Mar 2004
    Posts
    13
    TCP/IP and Named pipes protocols are OK.
    I did that before sending the 1st posting.
    Also checked the SQL ErrorLog file for any possible problem in the ports. All is OK.

  10. #25
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Can you login to the server box and try to connect to sql server using windows authentication?

  11. #26
    Join Date
    Mar 2004
    Posts
    13
    That is the problem: not able to connect to the SQL with any windows logins. Only accepts the "sa" login.

  12. #27
    Join Date
    Sep 2002
    Posts
    5,938
    How did you connect windows account to sql server? Keep in mind that you can't type id/password for windows account, it's different from connect with sa. Have to choose windows authentication.

  13. #28
    Join Date
    Mar 2004
    Posts
    13
    Mr rmiao,
    Thanks, but I can't understand what you are talking about.

  14. #29
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. Please see attached document....
    2. Please see the server properties

    1. Open Enterprise Manager
    2. Click on your server name
    3. Right click on your server name
    4. Click Properties
    5. Click on the "Security" tab
    6. Select "SQL Server and Windows" as authentication.
    7. restart the sql service
    Attached Files Attached Files

  15. #30
    Join Date
    Sep 2002
    Posts
    5,938
    When you connect to sql server with query analyzer, you'll get login screen. You put sql server name there and have a choice of 'connect using'. When connect with sa, you choose 'sql server authentication'. Put sa as login name and type password then click on ok. When connect with windows account, you HAVE to logon windows with that account first, open query analyzer and choose 'windows authentication' then click on ok. Same for odbc dsn. By the way, can you tell us how did you do when try to connect to sql server with windows account in query analyzer?

Posting Permissions

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