wey97
Jul 16th, 2007, 11:27 AM
Is the Reporting Services add-on for SQL Server 2000 no longer available?
I assume not since I can't find it in my MSDN Subscriber downloads, only the service packs.
If I have to use 2005 Reporting, I need help with choosing the best options.
Currently I have a SQL Server 2000 server we'll call serverSQL2000 and an asp.net 1.1 web server we'll call serverWeb with a forms authentication web application that I need to add reporting capability to.
I've read it's better to install Reporting Services on a separate server other than the main SQL server so that will add a third server we'll call serverSQL2005.
So I assume I can point my reports on my serverSQL2005 machine to the SQL 2000 database on serverSQL2000, right? so if I want reports available from my web app on serverWeb, I just redirect to serverSQL2005 and if I need any parameters, pass them in the query string?
Since I'm using forms authentication on serverWeb, how can I pass the user credentials to authenticate the user on serverSQL2005 so the user can view the report?
I assume not since I can't find it in my MSDN Subscriber downloads, only the service packs.
If I have to use 2005 Reporting, I need help with choosing the best options.
Currently I have a SQL Server 2000 server we'll call serverSQL2000 and an asp.net 1.1 web server we'll call serverWeb with a forms authentication web application that I need to add reporting capability to.
I've read it's better to install Reporting Services on a separate server other than the main SQL server so that will add a third server we'll call serverSQL2005.
So I assume I can point my reports on my serverSQL2005 machine to the SQL 2000 database on serverSQL2000, right? so if I want reports available from my web app on serverWeb, I just redirect to serverSQL2005 and if I need any parameters, pass them in the query string?
Since I'm using forms authentication on serverWeb, how can I pass the user credentials to authenticate the user on serverSQL2005 so the user can view the report?