Configure RS in sql express

Reporting Services Log

The Reporting Services installation options you specified in Setup determine whether further configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed just the program files, you must run the Reporting Services Configuration tool to deploy the report server.
I just installed sql express without sql developer or enterprise edition, I dont see Reporting Services on virtual directorys on IIS. I dont know how to acess the report server and configure it.

Tks

i have the same problem
i serch information about instalation RS on express edition and i find nothink, only info about futures
probably there are no RS in SQL Express setup, maby later...|||But Microsoft has a page where they say sql express has reporting services. Where is it?|||Yes. SQL Server Express has RS. However, not now. it will be available in the first half of the next year.

Alejandro Leguizamo
SQL Server MVP
Colombia|||Thank you Alejandro for answering to my email.

So the solution for this I think will be easy.

I will create my database on sql server express, I also will install sql server 2005 enterprise edition and make the reports in there, when the sql express with reporting services has been released the only thing I need to change will be the deployment options and thats it.

Correct me if I am wrong.|||

We have a client who requires RS 2005 (cause RS2004 has bugs), however is not ready to update to SQL 2005 (yet). The plan was to install Express with RS 2005, however it has been pointed out that RS is not packaged yet.

Is it possible to install Reporting Services off the developer edition cd onto a SQL Express instance? (Without using the developer licence in doing so).

Thanks

David

|||

No, this is not possible. A specific "package" which includes SQL Express and SSRS (Called SQL Server Express Edition with Advanced Services) will be available next year. This "Express SSRS" is the only version that will function against an Express database. I've had a customer or two try what you've suggested already, and it doesn't work.

I'm also not sure this idea would be "legal" (as you'd be putting SQL Developer into production which you may not do until the more recent MSDN SKUS), but that's above and beyond the technical part of the answer, anyway.