SSRS Connection Strings Password Length

Let me clarify one thing.

In SQL Server Object Explorer window, under Security context, did you first create the account you are using?

If no, then that's your issue.

Expand Security, expand Logins, click create new Login.

Enter Username, password and use SQL Server Authentication Mode.

If you prefer to use windows Authentication mode, then be sure to create the account first in windows.

Once you have done this, then go to the database that your report will be pointing to, right-click on it.

Select Properties, Select Permissions, then give it whatever permission level -SELECT , Execute, Update, Delete, Insert, etc.

Now, go back to Report Manager, use that report and it should work.

Let us know if you have already done all of these.

Nice explanation sammySeltzer. I really appreciate that.

DueForm,
       Can you also post your error msg? Moreover, can you reply on sammy's query?


Let us know if you have already done all of these.

Yes, the ID i'm using exists in SQL and also has permissions to the database my report is querying.  My issue is that on an earlier date, i found that my report would not generate when my SQL password was 11 digits long, I changed it to 6 digits and it worked.  (SQL accepted the 11 digit length password, and i could use the password to log into SQL directly, just SSRS didn't like it)  So now I'm wondering if anybody knows the password guidelines for SQL connection.   (SQL 2005)

Thanks!

Thank you for the info.  That worked, within my 11 digits i happened to have "admin" in there.  The link you gave me said there are 5 words that can't be in the password at all, so that must have been the reason.