SSRS Connection Strings Password Length

Posted on 2011-10-19
Last Modified: 2012-05-12
In Report Manager, when I go to the Connection Strings I have created and then Credentials stored securely in the report server, I have hardcoded an ID and Password.  It seems like when I tried an 11 digit password, the report would fail.  Does anyone know the criteria for the password here?
Question by:DueFrom
    LVL 28

    Expert Comment

    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.
    LVL 25

    Expert Comment

    Nice explanation sammySeltzer. I really appreciate that.

           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.

    Author Comment

    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)

    LVL 25

    Accepted Solution

    Basically there shouldn't be any limit for the maximum password length. Here is a very good link you want to check.

    You can check the password policy in the sql server node and reporting service node. The steps are told in the reference provided:-

    To determine the password policies of the local computer
    1.On the Start menu, click Run.

    2.In the Run dialog box, type secpol.msc, and then click OK.

    3.In the Local Security Settings application, expand Security Settings, expand Account Policies, and then click Password Policy.

    The password policies are described in the results pane.


    Author Closing Comment

    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.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
    Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now