Post reply

Server Login problem

  • July 16, 2007 at 1:48 pm

    #177446

    I set up all logins and users on SQL server and it worked fine. Then  a person at work who doesn't have technical background desided to restarted db server.

    After that users exist, logins and passwords are valid, but none of them cannot login, "this user is not associated with the trusted SQL Server connection".

    I deleted users, deleted logins, reseted logins and users but still get the same error.

    At the same time using Windows authentication I can still login.

    Was it something in the server settings itself that changed?

  • July 16, 2007 at 1:59 pm

    #719789

    have you checked that windows and sql logins are enabled on the security tab of the SQL servers properties?

  • July 16, 2007 at 2:10 pm

    #719791

    Yes and it was set to Windows only auth. Somehow when server went down, it resetted itself to Windows only. How is it possible? Now each time it goes down, it will reset itself again? Is it some kind of a default value?

     

  • July 16, 2007 at 2:25 pm

    #719795

    Not unless someone has setup a startup script or group policy is setting it, I wouldn't be suprised if someone just changed it by mistake.

  • July 16, 2007 at 2:38 pm

    #719799

    And where/how to check a group policy? I am sure there is no start up script, nobody is smart enough to do so

  • July 16, 2007 at 2:51 pm

    #719805

    If you have down time I would test restarting SQL or rebooting and see if this does set this, if not you are set, if it does you know to start digging.

  • July 16, 2007 at 2:54 pm

    #719807

    Thanks, I'll do that!

  • July 16, 2007 at 2:55 pm

    #719808

    You just need to change SQL Server to Mixed authentication mode, the steps are in the link below.

    http://msdn2.microsoft.com/en-us/library/ms188670.aspx

     

    Kind regards,
    Gift Peddie

  • July 16, 2007 at 3:15 pm

    #719814

    Thanks, it worked!

  • July 16, 2007 at 4:40 pm

    #719823

    SQL Server 2005 is a pain in the ass. Physical server, the machine went down again for some reason, nobody can figure out why, it's the third time today. When it was restarted and SQL server was restarted, users and logins were there, authentication was in the mixed mode, but user stopped working again, all settings were correct and SQL user cannot login. I had to delete user from the databases, had to delete login, then setup login nad user, then it started to work. This is just crazy.

  • July 16, 2007 at 5:25 pm

    #719830

    If you are using Window authentication you need to add all the users to SQL Server.  If not just use SQL authenthication and change your connection string.  Microsot have covered it below.

    http://support.microsoft.com/kb/889615

    Kind regards,
    Gift Peddie

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

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