Mozilla Firefox

The web interface for ReportServer does not work in Mozilla Firefox 1.0:
reports appear as blank pages.
Is this due to use of ActiveX controls in the browser, or is there some
other reason - and who's problem is it?
brianSomeone awhile back investigated this pretty extensively and I gather it has
to do with how the web interface was designed. It is not an active x
problem. If you want to provide support for Mozilla you will need to use
your own front end instead of the one provided by MS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Brian Smith" <bsmith@.NO.SPAM.schemiotics.co.uk> wrote in message
news:uwkkBk5OFHA.580@.TK2MSFTNGP15.phx.gbl...
> The web interface for ReportServer does not work in Mozilla Firefox 1.0:
> reports appear as blank pages.
> Is this due to use of ActiveX controls in the browser, or is there some
> other reason - and who's problem is it?
> brian

Moving the Reprot Server log files in 2005

I have just setup a SQL Server 2005 instance and am seperating the log files
on a seperate drive. Can the ReportServer and ReportServerTempDB log files be
moved just like any user database or are there special instructions for
moving the log file of these two databases? I have searched the MS Knowledge
Base and could only find an article about moving the entire RS databases to a
new server.
Any help would be appreciated.
Hi
"MACason" wrote:

> I have just setup a SQL Server 2005 instance and am seperating the log files
> on a seperate drive. Can the ReportServer and ReportServerTempDB log files be
> moved just like any user database or are there special instructions for
> moving the log file of these two databases? I have searched the MS Knowledge
> Base and could only find an article about moving the entire RS databases to a
> new server.
> Any help would be appreciated.
You should be able to move the location of the database log files like any
other database. You would need to stop Reporting Services before doing so.
John

Moving the Reprot Server log files in 2005

I have just setup a SQL Server 2005 instance and am seperating the log files
on a seperate drive. Can the ReportServer and ReportServerTempDB log files b
e
moved just like any user database or are there special instructions for
moving the log file of these two databases? I have searched the MS Knowledge
Base and could only find an article about moving the entire RS databases to
a
new server.
Any help would be appreciated.Hi
"MACason" wrote:

> I have just setup a SQL Server 2005 instance and am seperating the log fil
es
> on a seperate drive. Can the ReportServer and ReportServerTempDB log files
be
> moved just like any user database or are there special instructions for
> moving the log file of these two databases? I have searched the MS Knowled
ge
> Base and could only find an article about moving the entire RS databases t
o a
> new server.
> Any help would be appreciated.
You should be able to move the location of the database log files like any
other database. You would need to stop Reporting Services before doing so.
John

Moving the ReportServer database

I want to move the ReportServer database .mdf and .ldf files from the default directory to another drive (E:)

The ReportServer service is started, but when I run a sp_help_db from SQL Server management studio the ReportServer database is not listed. When I tried to detach it using sp_detach_db , the command reported succes but I'm wondering how this worked when the database is not in the sysdatabases table.

I haven't tried moving the ReportServerTempdb but I imagine that this would be ok, because this is in sysdatabases.

I can't seem to find anything in BOL about moving just the ReportServer database itself , anyone else come across this?

Thanks!

sp_helpdb will only return databases you have access to, so that may be part of it...also won't return databases that are offline and some other things, so not sure if that might be what you are seeing....

As for moving the database files, the RS catalog DB and RSTempDB's are just like any other user database, you can move the data files wherever you like, so long as SQL Server can see them. Note that the ReportServer service does not necessarily have to be running in order to see/move/modify/etc. the RS databases in SQL Server. The ReportServer service is simply a consumer of the SQL Server services to provide data storage in the RS and RSTempDB databases, that's all.

HTH,

|||

Thanks.

I'm using the sa login, so I would expect to be able to see it. There is nothing in sys.master_files for the ReportServer database and it does not show up in the list of databases in the management studio.

I haven't actually configured Reporting Services yet, only installed it. Is it possible that the database is not listed or attached until reporting services is up and running?

Cheers

Moving ReportServices databases. Failed!

We tried to move the two 2005 ReportServer databases to another platform. The actual db move worked fine (detatch/copy/attach) but when the report guy tried to change the connection info in Report Server he could not seem to make the change. So we backed-out the changes and regrouped.

This should be very cook-book. I have no experience with Report Server but I know some of you guys could to this with your eyes closed. After the databases are moved I think all we have to do is change the server name and credentials in Report Server. Is that correct? Do we have to bounce any services? Are there any tricks I can impress the other guys with?

Thanks,

Michael

Follow this link and look for SQL 2005 specific part i am sure it will help

http://support.microsoft.com/kb/842425

Thank s

Moving ReportServer databases example in error?

The following link shows an example of backing-up and restoring the databases supporting Repor Server. My question is not so much Report Server-related but I question the restore syntax for restoring the logs.

http://msdn2.microsoft.com/en-us/library/ms156421.aspx

I honestly do not see how the following code would work. At least, I was not able to until I deleted everything after the "NORECOVERY". Then it seemed to work fine but maybe I missed something!

-- Restore the report server log file to new instance folder
RESTORE LOG ReportServer
FROM DISK='C:\ReportServerData.bak'
WITH NORECOVERY, FILE=2
MOVE 'ReportServer' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer.mdf',
MOVE 'ReportServer_log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer_Log.ldf';
GO

Thanks a lot!

Your database is not ready if you stop after "with norecovery" restore. This basically puts the database in "recovering..." state (i.e. waiting to recover or roll forward/back transaction). You will have to run the following to recover the database.

-- Perform final restore
RESTORE DATABASE ReportServer
WITH RECOVERY
GO

-- Perform final restore
RESTORE DATABASE ReportServerTempDB
WITH RECOVERY
GO

|||

Everything you said is true and is actually included in the code sample on the link. I did not include it because it is not directly related to my question.

thanks

|||

you mean if you remove this portion of code

<code>

FILE=2
MOVE 'ReportServer' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer.mdf',
MOVE 'ReportServer_log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer_Log.ldf';

</code>

then it works? Well, there is a missing comma after "FILE=2" and before "MOVE". The correct syntax would be

<code>

FILE=2,
MOVE 'ReportServer' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer.mdf',
MOVE 'ReportServer_log' TO
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ReportServer_Log.ldf';

</code>

Moving ReportServer Databases

Followed the steps in Books Online to move the Reporting Services databases from one server to another. After resetting all the keys and configurations, the site comes up. However, all my shared datasources have lost their connection strings, and have reverted to requesting login information. Is this how it is supposed to work? If not, how do I fix this easily (as I have about 25 data sources)?

Hello,

Did you happen to backup the encryption key from your old reporting services instance?

Jarret

|||Nope. Didn't see that part until it was too late.
|||

In Books Online, it says...

After you move the report server database, you must reconfigure the connection information, which is stored as an encrypted value in the rsreportserver.confg file.

Here's a link that describes how to do this. http://support.microsoft.com/Default.aspx?id=842425

Hope this helps.

Jarret

|||

Sorry, but you're going to have to go back and set them up the way they were.

Jarret

Moving ReportServer and ReportServerTempDB to a different drive.

I need to move these databases from the C to the E driver on the existing server. I found instructions on how to move to a different server but I could not find specific instructions on moving these databases on what I need to dor. Has anyone been successfully in moving these databases to a different drive? If so, I would be grateful in you sharing your knowledge.

Thanks.

While these databases contain metadata for SSRS, they are not particularly special otherwise, just detach/re-attach them as you would any other database :)

If you're unclear on how to attach/detach, take a look at the sp_attach_db and sp_detach_db sprocs in books online (FYI, SSRS will need to be shut down while you do this or you won't be able to detach in the first place since it will have open connections)

Hope this helps!

|||I am familiar with the attach and detach stored procedures, so I will try this out on one of our virtual servers. Thanks a lot.

Moving Reporting Service Database

Hi, I need to move the both Reporting Service Databases "ReportServer" and
"ReportServerTempDB" to another SQL Server, only the both DB are moved, the
Server with installed RServices remains the same. Is there some dokument
about? Thnakssomething like this?
http://support.microsoft.com/kb/842425
"MV" <MV@.MV.MV> wrote in message
news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
> Hi, I need to move the both Reporting Service Databases "ReportServer" and
> "ReportServerTempDB" to another SQL Server, only the both DB are moved,
> the Server with installed RServices remains the same. Is there some
> dokument about? Thnaks
>|||Thank you a lot ! I needed exactly this, but how can I find out the password
from the user DOMAIN\MACHINE$ '
this is the user that have RSExecRole on the Database, this user must I give
as parameter to the RSConfig command line tool
Thanks
"Immy" <therealasianbabe@.hotmail.com> schrieb im Newsbeitrag
news:exaCzfVRHHA.3996@.TK2MSFTNGP04.phx.gbl...
> something like this?
> http://support.microsoft.com/kb/842425
> "MV" <MV@.MV.MV> wrote in message
> news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi, I need to move the both Reporting Service Databases "ReportServer"
>> and "ReportServerTempDB" to another SQL Server, only the both DB are
>> moved, the Server with installed RServices remains the same. Is there
>> some dokument about? Thnaks
>|||You will need to either use a domain account or sql account.
If you use a domain account, you need to see your system administrator who
should be able to give you the password.
Sorry - no trick to obtain the password (legally that I know of anyway) :-)
"MV" <MV@.MV.MV> wrote in message
news:Oo81aVeRHHA.2076@.TK2MSFTNGP05.phx.gbl...
> Thank you a lot ! I needed exactly this, but how can I find out the
> password from the user DOMAIN\MACHINE$ '
> this is the user that have RSExecRole on the Database, this user must I
> give as parameter to the RSConfig command line tool
> Thanks
>
> "Immy" <therealasianbabe@.hotmail.com> schrieb im Newsbeitrag
> news:exaCzfVRHHA.3996@.TK2MSFTNGP04.phx.gbl...
>> something like this?
>> http://support.microsoft.com/kb/842425
>> "MV" <MV@.MV.MV> wrote in message
>> news:OeURCYVRHHA.3316@.TK2MSFTNGP02.phx.gbl...
>> Hi, I need to move the both Reporting Service Databases "ReportServer"
>> and "ReportServerTempDB" to another SQL Server, only the both DB are
>> moved, the Server with installed RServices remains the same. Is there
>> some dokument about? Thnaks
>>
>