Reporting Services for SQL 2005 Standard

How do you enable reporting services in SQL 2005? When i initially installed SQL 2005 i allowed everything to be installed, but now i do not see how to get into reporting services to get it started. I also look in the Surface Area Configuration Tool to see how to enable it but did not find anything. Can someone please help me?

Can you find the RS Config tool by going to Start->Programs->Microsoft SQL Server 2005->Configuration Tools->Reporting Services Configuration? Also, can you get to Report Manager by going to http://<servername>/Reports? Not sure if this is what you are looking for.

Thanks,
Sharmila

|||I cannot get to neither one. The first one is not available and the second cannot be displayed|||

Do you have IIS installed?

Thanks,
Sharmila

|||IIS 6.0|||

To check if RS was installed successfully, you can look at the following two locations.

%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt - Check if RS was installed successfully.

Also, if it was installed in the default location, %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services.

Thanks,
Sharmila

|||Only the second line is there. I cannot find any Setup bootstrap directory|||

Can you launch the RS Config tool from,

%programfiles%\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe ?

Thanks,
Sharmila

|||yes, but it does not the correct instance as a choice|||

If it does not display the correct instance as a choice in the config tool, then I guess the instance did not install properly. Can you try to re-install and see if the problem goes away? Without the RS setup logs it's hard to tell what the problem is.

Thanks,

Sharmila

|||Should i just try reinstalling Report Services? I cannot reinstall the entire SQL 2005, because it host a database on the web. Will reinstalling report services affect anything else?