sonuverghese

We are using SQL Server 2012.

We are running Jasperserver Professional 5.6 on a Windows Server 2012 R machine. We receive the following error message: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host xx.xx.x.xxx, port 1433 has failed. Error: "No buffer space available (maximum connections reached?): connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall." Increasing the number of sockets to 65000 helped for a while. The error is now reoccuring. Is there a fix for this issue? Thank you.

We are testing JasperReports Server 5.5, when connecting to the server using localhost and running a report which uses a Multi-Select Query Input Control we see 'All None Inverse Close' as options, when we connect to the server using the server name, only 'Close' is available. 'All None Inverse' disappear. Does anybody know why this is happening? Is there a fix?

Thank you.

I need to filter input controls based on the logged in user name. iReport 5.1 had Domain Parameters which could be added to the Report. How do I accomplish this in Jaspersoft Studio? Thank you.

We are trying to create a filter in Ad Hoc on a Date field in Jasperserver 5.2. The database is Microsoft SQL Server. The filter does not seem to recognize that the field is a date, we cannot use date ranges or >= operators. Switching the datatype in the database to datetime resolves this issue. Please let us know if there is a way to resolve this issue. Thank you.

Thanks, Thomas. I was hoping there was a way to do it without Administrator intervention.

Ankur, In Jaspersoft Pro there is an option for users to save the selected input control values. I was wondering if there was a way these values could be saved so that they were not visible to any other regular users. Thank you.