I'm trying to setup a new data source. I keep getting the error of "Login failed". When I look at the SQL log I can see the following error. Login failed for user 'GenericUser'. Reason: Password did not match that for the login provided. Yet I can use the same login credentials in SSMS and it connects just fine. I'm using a local SQL ID. Any ideas what I am missing?
For the SSMS connection, can the login do a USE DatabaseName and also run a query in that window? The data source likely is specifying a database name, whereas the SSMS connection is not. I suspect a contained database or an orphaned account.
This has been resolved. When I'd get the login error I'd simply type in the password again. Apparently it wasn't updating the information upon submission. So, I checked an alternate option and then went back to check my initial option for username and password. It accepted the credentials finally. Really odd.Thanks for the assist.