Jaspersoft MSSQL Dynamic ports

During an installation of Jaspersoft  it has been setup with "dynamic ports" into the MS SQL Server 2012 database, however the application (CA PPM 14.2) that uses that instance of jasper does not support "dynamic ports".

Does anyone know where in the myriad of configuration files I can find where dynamic ports is set?
How do I set it to a specific port such as 1433?
LVL 50
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
There are 2 ways to resolve your problem:
1. Change Jasper to use the Dynamic port of SQL Server that is currently allocated by modifying it in the datasources in the below format by replacing 1433 with the assigned value.
  Ÿ  Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
  Ÿ  Sample URL: jdbc:sqlserver://hostname:1433;databaseName=yourDatabase
2. Change SQL Server port used in SQL Server Configuration Manager to  use 1433 if no other instance of SQL Server is using it by following the below steps:
1. Open SQL Server Configuration Manager with Run as Administrator.
2. Click on SQL Server Network Configuration.
3. Click on Protocols for your instance.
4. Click on TCP/IP and Go to IP Addressed tab.
5. Go to the end of the page and in IP All, Clear the values in TCP Dynamic Ports and enter 1433 for TCP Port.
6. Click OK and then restart your SQL Server services.
PortletPaulfreelancerAuthor Commented:
I now see my question is ambiguous, so sorry. SQL Server is fine, it has already been set to a static port.

The problem is changing Jaspersoft to recognise and use the same port.

& if recommending changes in a file could you identify the path to the file?
PortletPaulfreelancerAuthor Commented:
My tech guys are going to re-install, I suspect this may make this question redundant. I will let you know.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Hi Paul,

Kindly let me know whether you have tried Option 1 and modified the port in Jasper Connection string..
PortletPaulfreelancerAuthor Commented:
& if recommending changes in a file could you identify the path to the file?

is that connection string found under Jasper? Tomcat? Java?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Ok, then you might need to login to your JasperServer probably http://localhost:8080/jasperserver-pro.
Under Folders, you should be able to see the list of Data Sources that are currently created.
Try modifying the port mentioned in your data source connection string to the required value and try it once..
PortletPaulfreelancerAuthor Commented:
Raja, sorry the product was re-installed and the problem resolved that way.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PortletPaulfreelancerAuthor Commented:
Appreciate the help offered but the problem was only resolved by re-installation.
Apologies for late resolution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.