Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
L0bst3rGuy
Starting Member
4 Posts |
 Posted - 2015-05-06 : 18:02:55
|
| 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?Regards,Marcus |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-05-06 : 18:46:28
|
| Are you typing in the password or using copy/paste? Use copy/paste for both the data source and the SSMS connection to make sure they are identical.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
L0bst3rGuy
Starting Member
4 Posts |
Posted - 2015-05-06 : 19:03:54
|
| Yes. Still comes up with that error. That's why it' so perplexing. |
|
|
|
L0bst3rGuy
Starting Member
4 Posts |
Posted - 2015-05-06 : 19:08:42
|
| I've even gone so far as to change the password. And again I can login with SSMS without incident. Yet when I'm setting up and testing from SSRS and the web interface (http://servername/reports/Pages/DataSource.aspx?ItemPath=%2fMoveOnDMZ_Reporting%2fMoveOnDMZReportDSN) I keep getting login failed when I test the connection. The ID I'm using has db_datareader access. Is that sufficient permissions? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-05-06 : 19:08:59
|
| Is it a contained database?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-05-06 : 19:10:54
|
| 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.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
L0bst3rGuy
Starting Member
4 Posts |
Posted - 2015-05-07 : 12:24:34
|
| 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.Marcus |
|
|
|
|
|
|
Data Source Setup Issue