Post reply

Finding ReportServer and ReportServerTempDB

  • January 9, 2007 at 3:18 pm

    #153373

    How can I find which server is holding the RS metadata databases in SSRS 2000? I've only been able to figure out how to use the rsconfig to change the server, but I'd like to know which server it currently is on. Thanks!

    N

  • January 12, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • January 17, 2007 at 3:53 am

    #683680

    Hi Nate,

    Well according to Microsoft :

    To manage connections between the report server and report server database, and to find out which database is used for a particular report server instance, you can use Database Setup page in the Reporting Services Configuration tool. To learn more about the report server connection to the report server database, see Configuring a Report Server Database Connection.

    Hope that helps

     

    Rich

  • January 17, 2007 at 9:48 am

    #683790

    Thanks Rich,

    However, that's a SSRS 2005 feature. There isn't anything like that in 2000, that I can find at least. Any other way of finding it out?

  • January 17, 2007 at 10:19 am

    #683798

    In truth I'm having similar problems to you at the moment (I'm trying to reverse engineer some reports I built on the eval 2005 back to a 2000 installation with a licence), I'd been to the site earlier and read your post, then found that while trawling to solve my own problem...

    I'll let you know if I find anything else.

  • January 17, 2007 at 9:49 pm

    #683899

    I too had to reverse engineer some stuff.  I used a nifty little utility that I found at http://www.sqldbatips.com/showarticle.asp?ID=62 to generate the RDL of the report and then I was able to open up the XML files and see everything that I needed. 

    SJ

    Accepting all invites

  • January 22, 2007 at 8:50 am

    #684722

    Hmmm... Ok, I can see how that can help going one way. What about the other?

    I am at a bit of an impasse at the moment. I've discovered that 2005 has some RDL that isn't compatible with 2000, and I started trying to manually edit the XML to try and make the 2005 reports compatible with 2000 reports, I got the namespace sorted then hit a load of resizable column definitions....

    Hmmm.. Then I thought, well it might be quicker to rewrite them.

    Then I found out that SQL 2000 Reporting Services isn't compatible with SQL 7.0 (whereas 2005 is), so I'm thinking the only way I can get the £*(%& things to work is to run through a linked server on my 2000 server (and can I remember the syntax for this query??? Of course not - if anyone can please let me know, it'll save me a lot of time.)

    Any salient thoughts appreciated - I let my no. 2 write this stuff and he went at it with such great gusto he immediately got offered a better job, and I'm left having to get them up quickly without a good grounding or frame of reference.....

    At least nobody can accuse me of not offering good career progression

    Thanks

    Rich

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply