asked on

version of SQL and SSRS- is there any conflict or co-relation?

I did a standalone SSRS install.I chose default instance.. then i applied SP4 on this.

The DB engine was already in this machine with SP4..

ReportServer and ReportServerTempDB databases were configured from the tool..

The db version is t.0.8.54 in the config tool but i am told to expect c.0.8.54. (the default report server url does not work)

sachitjain

Have you followed up this link to configure the URL correctly

http://technet.microsoft.com/en-us/library/ms159261(v=sql.90).aspx

25112

ASKER

Yes, i have- basically i chose the default options throughout...

like in the picture below.. every green light is on
http://social.msdn.microsoft.com/Forums/en-US/sqlservermigration/thread/326fe78d-be61-4ea7-bdfa-c71e191a67cc/

except initialization..

only thing is that the DB version is not right.
I don't understand the last line in that post

"Turned out that the reason the version is different is because of the database name was tied to the ReportServerTempDB instead of ReportServer."

Where are they talking about?

sachitjain

Access Reporting Services Configuration Manager through your START->Programs-MS SQL Server->Configuration Tools and once the Reporting Services Configuration Manager window opens, you would find different tabs for different settings. There one tab is for Database where you could view/edit Database mapped with your ReportingServices.

25112

ASKER

sachitjain,
if sql engine is sql 2005 sp4 and ssrs is rtm or sp1/2 is that a concern?

ASKER CERTIFIED SOLUTION

sachitjain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial