Post reply

Windows authentication flakey

  • November 10, 2006 at 10:20 am

    #170377

    On several occasions now I have had a Windows account suddenly lose login priveleges to the SQL sever, despite no changes to the SQL server.  The account/login is still there, but it can't login.  I supect that our domain admins fiddled with the account somehow, causing it to lose its tie to the SQL Login.  In two cases, dropping the login and readding it, along will all database access and permission, fixed the problem, but I'm not too keen on doing that every day.  I have always been told that Integrated Security is the way to go, but this kind of problem will kill that initiative real quick!  Has anyboey else experience this kind of problem?

  • November 10, 2006 at 11:26 am

    #671157

    if a backup of a database was created on SERVER A, and Restored on SERVER B, you would find that behavior...all users in the db are "orphaned";

    i'd guess that if someone keeps re-restoring the db in question, that that is what you are seeing.that's  what you are seeing.

    BOB on SERVER A is not necessarily BOB on server B. dropping and re-adding BOB establishes the tie from localdatabase..sysusers to master..syslogins again.

    syslogins has a unique SID that is used to determine who BOB really is.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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