Post reply

Logon error in Query Analyzer

  • April 29, 2004 at 9:18 am

    #160859

    I have several SQL 2000 servers, all in mixed mode, all have my domain login set up as a user account. When I login as "windows authentication" I get the

    Unable to connect to server XXXX

    login failed for user 'NTAuthority\Anonymous Logon'

    If I login with a SQL account login it lets me in. This used to work just fine, it stopped working in the last week.

     

  • April 30, 2004 at 8:42 am

    #504841

    Sounds like your not really authenticated to the domain. Can you create a windows share on the server and grant authenticated users permission to the share then attempt to map a network drive to it. If you get prompted for a username and password, your not authenticated.

    Many things can interfere with authentication. My biggest problem is the Novell client and its workstation manager. If this is loaded, the machine is not authenticating to the domain.

  • April 30, 2004 at 8:47 am

    #504843

    Yes I am properly authenticated on the domain. I cna attach a drive mapping ot any share. We are not running the Novell Client here on our nwtwork. THis problem just started for no reason that I can find. It was working, and now stopped for every user.

  • April 30, 2004 at 8:53 am

    #504845

    bizarre,

    Can you login to the domain on the SQL server box?

  • April 30, 2004 at 9:02 am

    #504846

    Yup, everything else works flawlessly. the funny thing is one of the servers that is affected is a domain controller.

  • April 30, 2004 at 9:22 am

    #504849

    Are you getting any AD replication errors on the domain controllers? I would force a AD replication see http://www.winnetmag.com/Windows/Article/ArticleID/22007/22007.html for how to do this.

  • April 30, 2004 at 9:31 am

    #504853

    According to the logs AD is synchronizing successfully both ways.

  • May 2, 2004 at 7:28 pm

    #504942

    Have passwords / accounts expired?

  • May 4, 2004 at 12:34 am

    #505074

    By saying that user accounts have been set up, do you mean that the account has been added as a user in the databases?

    If that is the only step you have taken, you need to add the Windows NT logins to SQL server using sp_grantlogin.

    - Vani.

  • May 4, 2004 at 6:24 am

    #505114

    The logins have not expired, and the logins have been added to SQL server. As I stated earlier, the logins were working perfectly until about 2 weeks ago when they all of a sudden stopped working. Nothing was changed in that timeframe.

Viewing 10 posts - 1 through 9 (of 9 total)

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