Post reply

Connection problems

  • July 15, 2004 at 10:08 am

    #86155

    I have one user (Windows Authentication) that can no longer connect to the SQL Server on Server A, but can on 30 other SQL Servers. She had been able to connect until she changed her Windows password.

    Things I have tried. I have completely removed all references to the logon on the entire SQL Server. Recreated the logon. Still errors out. I have booted the server and she still errors out.

    Msg 18456, level 16, state 1.

    She can connect to a share on the server.

    This is SQL Server 2000 on windows 2003.

    Thanks for your time


    Stacey W. A. Gregerson

  • July 15, 2004 at 11:44 am

    #514714

    Are those 30 SQL Server also running on Windows 2003?

  • July 15, 2004 at 11:46 am

    #514715

    10 are.


    Stacey W. A. Gregerson

  • July 15, 2004 at 11:51 am

    #514717

    Could it be possible that user belongs to group which has been denied to access the SQL Server?

  • July 15, 2004 at 12:10 pm

    #514723

    I thought of that too. No there are currently no groups that have been denied. The problems did not occure until after she changed her Windows password.


    Stacey W. A. Gregerson

  • July 15, 2004 at 12:13 pm

    #514724

    Try to logoff from the network and login again.

  • July 15, 2004 at 12:15 pm

    #514725

    That has been done also along with cycling the server and having her logon a differnt PC and attept to connect. All ended withthe same result.


    Stacey W. A. Gregerson

  • July 16, 2004 at 2:08 am

    #514798

    Hi Stacey,

    Are you guys using Active Directory Groups, one problem I have encountered quite often, if when one server is in a different domain, to the logged in user.

    There AD settings dont propogate in time, if at all.

    To determine what PDC she is logged into (assuming you have more than one) goto a command promp and issue 'set L' which will return something like

    \\WAYNE

    (in my case, we had our SQL Box on \\GEORGE and most of our users on \\WAYNE (as we had Load Balancing also enabled for logged in users).

    Give that a go and let me know either way, if its still not working, I'll look a little further into it for y'all ..

    take care,

    Alex

  • July 16, 2004 at 4:58 am

    #514805

    Thanks Alex for your responce. No we are still (thats another internal issue) not on active directory. We have tried forcing all of the BDC to update but that did not help either. We are only running a single domain as far as anything she has been working with.

    Thanks for the suggestion though.


    Stacey W. A. Gregerson

  • July 16, 2004 at 6:04 am

    #514814

    I assume, she has a valid server login on the SERVER aswell as a valid database user, in the database?

     

     -- Alex

  • July 16, 2004 at 6:43 am

    #514822

    Once again the ID10T error stikes. She was apart of a group that was denied access to the server. I know I looked at these earlier, but I missed it. Sorry to waste everyones time. I must now go and bow my head in shame while wearing the t-shirt that says "I am just another user and not a DBA"


    Stacey W. A. Gregerson

  • July 16, 2004 at 6:46 am

    #514825

    neat. you have one of those t-shirts too ..

  • July 16, 2004 at 9:20 am

    #514891

    Is it possible that her account has been locked on the SQL server, after too many failed login attempts?  What does her entry in the syslogins table look like?

Viewing 13 posts - 1 through 12 (of 12 total)

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