Thanks to you, my pain is over. It is working like a charm. I even did not touch Mid Tier, only removed ISAPI Servletexec and install AS, as you suggested. I do appreciate your help. And ... you are right, it is working faster! Urszula.
Carter, Craig J Civ ARPC/DPD wrote: > > 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#a6744617 >> 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#a6762757 > 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#a6767239 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
