Login failed: Password did not match that for the login provided.

Question

Login failed: Password did not match that for the login provided.

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

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

C-M-A SSC-Addicted Points: 407 More actions · Answer 1

It sounds like you already have it set, but mixed mode authentication is on, right?

The only other thing I would suggest doing is running a trace and setting up checks for exceptions, user errors, and failed logins to see if there is another underlying error this login is receiving.

tom 69406 SSC-Addicted Points: 446 More actions · Answer 2

Yes its mixed mode. The Trace log is useful, as there are some connections happening for that user. If I connect before starting the SqlDependency - it works; after the SqlDependency there are logon failures.

So I think the Service Broker setup is incorrect for the service user

It all works now for NT AUTHORITY\SYSTEM - with trusted_connection

Which is good enough for now.