Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5778

JDBC connection details still remains even after removing from Options tab for MsSQL connections.



    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: GA
    • Fix Version/s: 7.1.0 GA
    • Component/s: None
    • Labels:
    • Story Points:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Tatooine (Maint)


      Pentaho Version :
      Operating System on which Report Designer is installed : Windows 7
      Operating system on which Pentaho Server : RHEL.
      Installation Method : Installer.
      Java Version : Default Java with Installer.

      JDBC connection details remains even after deleting them. Please refer the screencast attached. You will notice that even though I remove the instance parameter, upon reopening the report, the instance gets added.

      However, the issue is on a Customers environmnent. In the customers installation, they do have a parameter in the Options tab called CE. They do try to remove the parameter, but upon reopening the report in Report Designer and see the OPtions tab they do see the CE parameter being added back.
      When they try to test the connection, they are receiving the below error message,

      Error connecting to database: (using class com.microsoft.sqlserver.jdbc.SQLServerDriver)
      The connection string contains a badly formed name or value.

      When they try adding any arbitrary value to this property, they do get a Connection Test Successful message. I have asked the client to record a screencast for this and has been attached to this ESR along with the error message and prd.log file.


        1. case68616_After_Carlos_suggestion.swf
          8.79 MB
        2. ErrorMessage.txt
          9 kB
        3. prd.log
          4.53 MB
        4. Recording #1.mp4
          874 kB

          Issue Links



              Yury_Hetman Yury Hetman (Inactive)
              nprakash Nikhil Prakash
              0 Vote for this issue
              10 Start watching this issue