Craig, That's interesting that the AS version is faster. According to their web site the ISAPI version is the "high-performance" product and the AS version has the "greatest architectural flexibility" http://www.newatlanta.com/products/servletexec/product_info/configuratio ns.jsp. I think I will try it on my dev server.
Windows Server 2003 IIS ARS 6.3, 7.01 Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carter, Craig J Civ ARPC/DPD Sent: Wednesday, October 11, 2006 4:55 PM To: [email protected] Subject: Re: SQL Server Reporting Services Don't bother creating a separate website--it won't help. I tried all of that before finally figuring out what the problem is. The AS version was actually recommended by Remedy Support and they stated it was faster than the ISAPI version based on their testing. We've been using it for almost a year now and have found it to be at least as fast. It's actually nicer than the ISAPI version because it runs as a Windows service and can be restarted whenever you want (unlike the ISAPI version). Since it runs as a service, it doesn't have the conflict with Reporting Services like the ISAPI version. Go to the New Atlanta web site and click on the download page. Once there, you'll see an option to download either the Windows ISAPI version or the Windows AS version. Once downloaded, you'll want to uninstall the ISAPI version from the server and install this one. Your existing license will work with the AS version. Once installed, open the ServletExec manager from the start menu and add the Remedy information. My recommendation is you open the ISAPI version you currently have installed and print out the configuration information the Remedy installer built for you. After you uninstall the ISAPI version and install the AS version, you simply open the ServletExec manager and enter the same information manually. Since you are installing ServletExec AS manually, you want to bypass the servlet installation in the midtier install. You do this by clicking the other checkbox on the servlet page in the wizard. This sounds like a lot but it's really pretty easy. Uninstall everything, install ServletExec AS, install Remedy midtier with no servlet install, open ServletExec and add the configuration information. Everything should now work including reporting services. CRAIG J. CARTER -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of ud Sent: Wednesday, October 11, 2006 1:15 PM To: [email protected] Subject: Re: SQL Server Reporting Services Craing, I installed ServletExec v.5 which comes with Midtier 6.3 patch18 installation. It is definitely ISAPI filter on default www level, which is preventing RS from working. I'm not sure what you mean by AS version, not ISAPI and which website I could downloaded from. Could you please, explain? I wanted to create second website on the box and try to work RS of it. But if there is any other than this solution, I would definitely try. Thanks, Urszula Carter, Craig J Civ ARPC/DPD wrote: > > No, it works fine with 6.3 patch 16. I haven't upgraded to patch 18 > but it shouldn't be a factor. > > We're running Win Server 2003, ARS Midtier 6.3 patch 16 and SSRS 2000. > We're getting ready to upgrade everything to SQL Server 2005 and ARS 7. > > What version of ServletExec are you running? You need to use the AS > version. The ISAPI version that you can install with the midtier > software will not work. You simply download the version from the web > site and use the same license. When you install the midtier, you > select other for the servlet and then configure it manually afterwards > (just use the same settings you use for the ISAPI version). > > CRAIG J. CARTER > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of ud > Sent: Tuesday, October 10, 2006 2:22 PM > To: [email protected] > Subject: Re: SQL Server Reporting Services > > Hi all, > I have the same problem as Craig. I was using successfuly SSRS with > Midtier 6.0. We migrated the server to Win 2003 and ARsystem 6.3. Now > SSRS is not working. Craig, do you mean, you downgraded Midtier to > ver.6 to make it work? > Urszula > > Carter, Craig J Civ ARPC/DPD wrote: >> >> Hi Curtis, >> >> We've been using SSRS (version 2000) for several months now against >> Remedy >> v6.3 without any real issues. The biggest obstacle initially was >> figuring out why it wouldn't run on the same server as the midtier. >> It ended up being ServletExec (ISAPI version) competing with SSRS. >> Once we swapped out the ISAPI version with the AS (Application >> Server) version, it was smooth sailing. >> >> If you use SSRS directly against the database, it doesn't matter what >> version of Remedy you are using--you'll just need to make sure only >> authorized people are allowed to open the reports. This can be >> controlled via form access or with permissions in SSRS. >> >> If you have a choice, I'd recommend installing version 2005--it >> provides a much better installation and validation process. >> >> //SIGNED// >> CRAIG J. CARTER >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Curtis Gallant >> Sent: Monday, September 11, 2006 3:10 PM >> To: [email protected] >> Subject: SQL Server Reporting Services >> >> Has anybody successfully used the SQL Server Reporting Services to >> generate reports against a Remedy system of any version? >> >> If so could you please let us know any gotchas you might have had to >> overcome. >> >> Cheers, >> >> ------------------------------ >> Curtis Gallant >> Burntsand Inc. >> Systems Integration Specialist >> >> Office: 416-234-3861 >> Cell: 416-786-2842 >> Email: [EMAIL PROTECTED] >> Web site: www.burntsand.com >> >> >> > ________________________________________________________________________ ____ >> ___ >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> >> > ________________________________________________________________________ ____ > ___ >> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> >> > > -- > View this message in context: > http://www.nabble.com/SQL-Server-Reporting-Services-tf2255071.html#a6744 617 > Sent from the ARS (Action Request System) mailing list archive at > Nabble.com. > > ________________________________________________________________________ ____ > ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > ________________________________________________________________________ ____ ___ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > > -- View this message in context: http://www.nabble.com/SQL-Server-Reporting-Services-tf2255071.html#a6762 757 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
