Post reply

SSRS - Login failed for user error

  • August 26, 2009 at 1:03 pm

    #385253

    Hello! I hope that someone may be able to help as I've been unsuccessful in getting this to work.

    I have several reports (using SSRS 2008) that use the same shared data source. The data source is set up to use Stored Credentials with a windows account/password. When I updated the data source through Report Manager and entered my username/password, all is OK until I click the 'Use as Windows credentials when connecting to the database' box. At that point, I get an error 'The password is not valid. Please retype the password.' I know that my password is correct as I've been able to use it successfully in other places.

    When I run any reports using this data source, I get the following error (probably due to the fact that the report is trying to run as a SQL account --

    * An error occurred during client rendering.

    o An error has occurred during report processing. (rsProcessingAborted)

    + Cannot create a connection to data source 'XXXX'. (rsErrorOpeningConnection)

    # Login failed for user 'XXXX\XXXX'.

    *where the X's are my data source and domain\account.

    I have even tried deleting and redeploying to no avail. The strange thing is, is that I have another data source that works in the same manner that is working OK...unless of course I click the above mentioned box off, then I get the same error about the password being invalid.

    Thanks!

    Danielle

  • June 18, 2013 at 1:50 am

    #1624889

    Not sure if your issue is fixed by now. I got the same error today. I created the datasource, entered the credential and did test connection. It was successful. That indicated the password was correct. But if I browse away from the data source and come back again to do a test connect for the DS, it gave "Invalid username/password error".

    I found the problem. In my case the problem was in the data source connection string.Earlier it was definef as below. If you notice there was a new line character.

    Data Source=<server name>

    ;Initial Catalog=<DB Name>

    When I removed the new line character and gave the connection string in a single line it worked.

    My new connection string :

    Data Source=<server Name>;Initial Catalog=<DB Name>

    Hope this helps to someone.

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

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