I have an ASP application which I am running Crystal Reports through. They run through a COM object on a seperate server and print out via PDF. Lately, sporadically, I am getting this error:
"There are not enough Concurrent Access Licenses to log you on. This system has 5 Concurrent Access Licenses. Please try again later, or contact your system administrator to obtain more licenses. Licenses can be purchased direct from Seagate Software or through the Seagate Software Online Store."
I know for a fact that I am not running 5 different reports at once. However, when I look through SQL Server via sp_who2 I can see that my machine name is tied to numerous SPID's and tying things up. However, I am NOT running anything. I can kill these SPID's and my QA guy can run a report on his machine and create all these SPID's again with my machine name tied to them, thus using up all of the 5 licenses.
Does Crystal have some sort of place it writes my machine name into and for whatever reason it's thinking my machine is firing off all these calls? The report I am running does have subreports in it, with calls to other stored procs, so maybe that has something to do with it.
I read something somewhere about setting the web.config file. timeout="" in the <sessionState> tag and I haven't tried that yet.
If anyone can think of anything, please let me know...
"There are not enough Concurrent Access Licenses to log you on. This system has 5 Concurrent Access Licenses. Please try again later, or contact your system administrator to obtain more licenses. Licenses can be purchased direct from Seagate Software or through the Seagate Software Online Store."
I know for a fact that I am not running 5 different reports at once. However, when I look through SQL Server via sp_who2 I can see that my machine name is tied to numerous SPID's and tying things up. However, I am NOT running anything. I can kill these SPID's and my QA guy can run a report on his machine and create all these SPID's again with my machine name tied to them, thus using up all of the 5 licenses.
Does Crystal have some sort of place it writes my machine name into and for whatever reason it's thinking my machine is firing off all these calls? The report I am running does have subreports in it, with calls to other stored procs, so maybe that has something to do with it.
I read something somewhere about setting the web.config file. timeout="" in the <sessionState> tag and I haven't tried that yet.
If anyone can think of anything, please let me know...