I'm trying to upgrade my sql 2005 to sql 2008. In the setup I'm ale to get as
far as the Reporting Services Authentication screen when I encounter the
error: "Instance os SQL server that hosts report server database - Unknown"
and at the bottom of the screen I get "Check whether the report server is
correctly configured". I have no idea what the report server is or how to get
past this. Any thoughts?

Maybe don't choose Reporting Services as one of the components you want to
upgrade?


On 10/9/09 4:02 PM, in article
06381540-2303-44AA-89C1-B44B5CA317F9...soft (DOT) com, "Don Powell"
<DonPowell (AT) discussions (DOT) microsoft.com> wrote:

Tried that but all of the options are forced (greyed out) for upgrades.
Thanks anyway, just paid my $259 tithing to Microsoft and got it resolved.

Thanks again

"Aaron Bertrand" wrote:

Can you share what the actual problem was? You might save the next person
who has the problem $259.




On 10/9/09 7:11 PM, in article
35C21ADF-7A0F-4871-9CA1-21F14CB25B8A...soft (DOT) com, "Don Powell"
<DonPowell (AT) discussions (DOT) microsoft.com> wrote:

Since this was the only thread I could find on the web with the same error I was getting, I thought I'd share the solution to save others the frustration. This error comes from having an improper setup on the Report Server for SQL Server. This can be caused by a handful of things, in my case it was due to having changed the computer name after installation of SQL Server 2008.

To solve it, update the report server configuration file using rsconfig. Follow the instructions found here:

http://msdevelopers.blogspot.com/200...ilable-on.html

Restart the Report Server Service, and hopefully you can continue your upgrade.



Aaron Bertrand wrote:

Can you share what the actual problem was?
10-Oct-09

Can you share what the actual problem was? You might save the next person
who has the problem $259.




On 10/9/09 7:11 PM, in article
35C21ADF-7A0F-4871-9CA1-21F14CB25B8A...soft (DOT) com, "Don Powell"

Previous Posts In This Thread:

On Friday, October 09, 2009 4:02 PM
Don Powell wrote:

attempting to upgrade to SQL 2008
I am trying to upgrade my sql 2005 to sql 2008. In the setup I am ale to get as
far as the Reporting Services Authentication screen when I encounter the
error: "Instance os SQL server that hosts report server database - Unknown"
and at the bottom of the screen I get "Check whether the report server is
correctly configured". I have no idea what the report server is or how to get
past this. Any thoughts?

On Friday, October 09, 2009 6:23 PM
Aaron Bertrand wrote:

Maybe do not choose Reporting Services as one of the components you want
Maybe do not choose Reporting Services as one of the components you want to
upgrade?


On 10/9/09 4:02 PM, in article
06381540-2303-44AA-89C1-B44B5CA317F9...soft (DOT) com, "Don Powell"

On Friday, October 09, 2009 7:11 PM
Don Powell wrote:

Tried that but all of the options are forced (greyed out) for upgrades.
Tried that but all of the options are forced (greyed out) for upgrades.
Thanks anyway, just paid my $259 tithing to Microsoft and got it resolved.

Thanks again

"Aaron Bertrand" wrote:

On Saturday, October 10, 2009 11:21 AM
Aaron Bertrand wrote:

Can you share what the actual problem was?
Can you share what the actual problem was? You might save the next person
who has the problem $259.




On 10/9/09 7:11 PM, in article
35C21ADF-7A0F-4871-9CA1-21F14CB25B8A...soft (DOT) com, "Don Powell"


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorials...-synopsis.aspx