Post reply

Weird login problem

  • February 5, 2010 at 10:34 am

    #138580

    I'm having a weird login problem, and am hoping that someone might be able to help.

    We're life-cycling some servers, and bringing up a new one. It's been configured to accept remote logins, and with mixed authentication.

    There are a couple of sql logins defined. These were scripted out from the old server w/ sp_help_revlogin, and applied to the new server.

    One user cannot use one of these logins... the logs are always indicating an incorrect password (state=8). This same user can login with the other login.

    No other users are having an issue with this login.

    This user does know what their doing. However, this user works remotely, and logs in through a VPN. I have just logged in over the VPN with this login.

    I have tried:

    1. changing the pw for the login.

    2. dropping the login, and recreating it.

    Any ideas out there for resolving this?

    Thanks,

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • February 8, 2010 at 6:52 am

    #1115445

    Might be to do the local keyboard/language set on the remote system.

    Set up another remote machin with vpn and try that, bu if other users are fine, then its gonna be local or user error.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • February 9, 2010 at 8:48 am

    #1116170

    Is this login for a 3rd party application? I ask because I discovered an interesting issue with MS Dynamics that uses SQL Logins for each user version 8. You had to create / update passwords through the application which would create and update the associated SQL Login account on the SQL server. Reason, the app would encrypt a hash of the password and send that to SQL Server for authentication. So, as you can imagine if you typed the password into SSMS it would not match the same password in the application. Or visa versa, the only way I discovered this was to run profiler to see what was happening. May not be anything to do with your case, but thought I'd share since my problem had similar symptoms.

  • February 9, 2010 at 9:54 am

    #1116235

    Schadenfreude-Mei (2/8/2010)

    Might be to do the local keyboard/language set on the remote system.

    Set up another remote machin with vpn and try that, bu if other users are fine, then its gonna be local or user error.

    This doesn't seem likely. The same user can properly use one login/pw, but the second one fails.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • February 9, 2010 at 9:56 am

    #1116239

    SQL Dude-467553 (2/9/2010)

    Is this login for a 3rd party application? I ask because I discovered an interesting issue with MS Dynamics that uses SQL Logins for each user version 8. You had to create / update passwords through the application which would create and update the associated SQL Login account on the SQL server. Reason, the app would encrypt a hash of the password and send that to SQL Server for authentication. So, as you can imagine if you typed the password into SSMS it would not match the same password in the application. Or visa versa, the only way I discovered this was to run profiler to see what was happening. May not be anything to do with your case, but thought I'd share since my problem had similar symptoms.

    No, but this is indeed interesting. This particular login is used by a select group of "system-matter-experts" / SMEs to log into the SQL server via SSMS to run some specific queries.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 5 posts - 1 through 5 (of 5 total)

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