Venkatesannn


Hi all,
guys i need a help, i want to know what are the software requirements to install sql 2000 reporting services, in both windows xp and windows 2003 server.
basically i ve installed sql 2000 reporting services in my local machine in which my system has sql 2000 database developer edition, visual studio .net 2003, so i didnt find any difficulty in working on reporting services, now my reports are ready, which i ve to upload the reports in a server, which is a windows 2003 server edition, as its server we ve only IIS installed in that, we have a separate database server, which used for our database purposes.
Now what my question is
What are the softwares required to be installed in the application server to deploy the reporting services, i need reportserver and report manager to manage the reports
i checked in microsoft website and it says : it requires visual studio .net 2003 ,mdac, and sql 2000 reporting services also, but iam not allowed to do it in a single server, is it possible to install only the sql 2000 reporting services in the application server which has IIS and use the report server and report manager
so anyone please please please please help me in this issue.
How to set it make it work
Please.............Please..............
waiting for a reply soon

Thanks
Venkat.





Re: software requirements for installing reporting services

Shyam Sundar


Check out Table 5 in the following link:

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

Shyam






Re: software requirements for installing reporting services

Venkatesannn

Thanks a Lot, it was very useful.
Regards
Venkat.






Re: software requirements for installing reporting services

Venkatesannn

hi,
Again a problem, when i install the reporting services in my server machine which has the s/w requirements(mdac,iis,etc..) it gives me a error ie : "login failed for user'(null)' Reason : Reason: Not associated with a trusted SQL Server connection. " some blah blah with a error code 1603 , i dont know what to do, pls some one help me in this issue , what could be wrong ........
waiting for a reply soon
Thanks
Venkat.





Re: software requirements for installing reporting services

Venkatesannn

Hi all,
finally made it, i installed sql 2000 reporting services, i found some useful information from these links below to install it,

http://weblogs.sqlteam.com/tarad/archive/2004/08/09/1895.aspx

http://support.microsoft.com/kb/867872

http://geekswithblogs.net/ranganh/archive/2005/05/25/40503.aspx

http://msdn2.microsoft.com/en-us/library/aa179654(SQL.80).aspx


Thanks
Venkat.