Login suspended (determine from which server)

  • I have several SQL Server machines which use the same login for the services. All of these servers (10) use the same domain account. Somehow this account is becoming suspended. My security team is not being very helpful in helping me determine which machine is logging in incorrectly (and thus causing the suspension). Is there anyone with any ideas on how I can determine what machine is logging in incorrectly ( it may not even be one of my servers).

    Thanks

    Bob Horkay

  • Check the event logs on each server. And set a different account for each SQL Server, it prevents this.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

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

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