I just installed a new instance of SQL Developer Edition - All my apps run on SQL Express and I am testing them on the new Edition. My Web Service connects to the new instance, my integration tests can access the new instance... However
For a Windows Service - I get this error every time it tries to connect.
Login failed for user 'MyUser'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
But the password is most definitely not wrong. I can copy/paste the password into SSMS and it connects just fine. I can get the service to print the connection string to the event log, then copy/paste the password into SSMS and the login works.
I can use the same connection string in a console application from visual studio, and it can connect.
There must be something dodgy about my Windows service - but I created the same login and password on my SQL Express edition - and it works!
What possible setting in the server or database could cause this behaviour?