Post reply

Connection failed: SQLState: '28000' SQL Server Error: 18456 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'User'.

  • January 4, 2008 at 12:30 am

    #119510

    Hi I have a new server with a 2000 instance and a 2005 instance where the 2000 instance is the default.

    Connecting to the 2000 instance is a breeze but the 2005 instance is a bit complicated.

    First of all the users has been set up correctly and I can connect to the 2005 instance. But some people on the same network can connect and some cant. For those that cant the error Login failed for users comes up. Some guy's can connect and then cant connect anymore after a while. I myself have been able to connect remotely every single time.

    Any Ideas on what this could be?

  • January 4, 2008 at 11:21 am

    #764930

    Please, post the error message. If it is Integrated authentication and the message "Login Failed for User NULL" or Login Failed for User "Dude'sComputer\IamTheAdmin" then they are not logging in as users in the same domain. For example, if some dude logs in as a domain user and you gave permissions for domain users, he will be able to connect. If the same dude logs in locally to his computer or some other domain as a local admin with the name "IamTheAdmin", as them, developers, do, in this case he will get these messages. What particular message depends on the domain trust.

    Also in 2005 logins can be locked out. Check the login properties for those who can not connect, if there is Locked Out checked on Status tab

    Regards,Yelena Varsha

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

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