Error when moving a report server database to another server

We have a new server (SRV63) and I followed the instructions at http://msdn2.microsoft.com/en-us/library/ms156421.aspx to move the report server database from our old server (SRV38). Everything appeared OK, however, when I went to initialize the instance in the Reporting Services Configuration tool, it shows an initialized instance (checkbox is checked) for SRV38 and and uninitialized instance for SRV63 (checkbox is not checked). Please note that I am not trying to create a scale-out deployment. I tried to initialize SRV63 but received the error below.

--

ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)

This is the only thing stopping me from shutting down SRV38 and bringing SRV63 into production. Can someone assist me with this issue?

Chuck-

Just curious if you figured this out. I have the exact same problem and can't figure out how to resolve it.

Thanks!

Laura

|||

Hi Laura. I was a bit surprised that I did not receive any response to help me with this issue as I was sure I was not the first to have experienced this issue. As I was short on time; I opted to reinstall Reporting Services and recreated all my user / group folders and securities and re-registered all my reports to the correct report folders. It was like starting from scratch; however it works and I do not have to worry about legacy items from the old server causing issues now. I believe I could have avoided this issue by turning off the Reporting Services on the old server before installing them on the new server therefore only the new Reporting Services instance would show. You might give this a try and see if it works. Sorry I don't have a more definitive answer for you.

Good luck.

|||

I was also able to solve the problem by deleting the report databases and then recreating them through the Reporting Services Configuration. Thanks for your response!

Laura

sql

Error when deploying forms authentication sample

Hello

I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

My particular mistake was in the line Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll" because I had the path wrong. I corrected that and corrected the problem.

Hope this helps.

The RSSrvPolicy.config that has to be changed:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll"
/>
</CodeGroup>

Error when deploying forms authentication sample

Hello

I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

My particular mistake was in the line Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll" because I had the path wrong. I corrected that and corrected the problem.

Hope this helps.

The RSSrvPolicy.config that has to be changed:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll"
/>
</CodeGroup>

Error when deploying forms authentication sample

Hello

I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.

This has been driving me crazy for a while now. Any help would be greatly appreciated!

Thanks in advance

Dominic

Have a look at this.

http://blog.devstone.com/aaron/archive/2005/03/31/502.aspx

Also, try using www.sysinternals.com filemon and regmon to track down permission issues.

cheers,

Andrew

|||

I am also facing the same problem. Due you get the solution ?I

|||

I was having the same problem. I solved it changing the RSSrvPolicy.config as explained in http://msdn2.microsoft.com/en-us/ms160724.aspx

My particular mistake was in the line Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll" because I had the path wrong. I corrected that and corrected the problem.

Hope this helps.

The RSSrvPolicy.config that has to be changed:

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll"
/>
</CodeGroup>

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/defaul...;312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro CastaldiI strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/defaul...;312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro CastaldiI strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error using CDOSYS in a process

Hi !
I created a backup process that sends me an email (CDOSYS) with the result
of this operation, following the instructions at
http://support.microsoft.com/default...312839&sd=tech
The problem is that the stored procedure sp_send_cdosysmail crashes if it's
run inside a SQL Server 2000 SP3a process (schedule or manual execution is
the same) but it run fine if I use query analyzer to exec the sp. Process
and query analyzer window have a single TSQL instruction (exec...) but the
SQL Server Agent keeps on stopping after a while with an error (I don't
remember the message but it was something like "not responding after 30
secs") if I run the process.
What could it be ? Thank you.
Mauro Castaldi
I strongly suggest using CDO within sp_OACreate. Try using xp_smtp_sendmail
instead... http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"Mauro Castaldi" <no.spam.kastaldi@.hotmail.com> wrote in message
news:41e10c24$0$8209$5fc30a8@.news.tiscali.it...
> Hi !
> I created a backup process that sends me an email (CDOSYS) with the result
> of this operation, following the instructions at
> http://support.microsoft.com/default...312839&sd=tech
> The problem is that the stored procedure sp_send_cdosysmail crashes if
it's
> run inside a SQL Server 2000 SP3a process (schedule or manual execution is
> the same) but it run fine if I use query analyzer to exec the sp. Process
> and query analyzer window have a single TSQL instruction (exec...) but the
> SQL Server Agent keeps on stopping after a while with an error (I don't
> remember the message but it was something like "not responding after 30
> secs") if I run the process.
> What could it be ? Thank you.
> Mauro Castaldi
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:
> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> > New to SQL Server, have never backed up a database before, in any DB
> > system.
> > I am following a set of instructions that spell out how to copy a source
> > db
> > and then copy it to a target db. Steps:
> > 1) log onto server
> > 2) start SQLServer Enterprise Manager
> > 3) select source db and then Tools->Backup Database
> > Here's where my questions lie - The correct db shows, I have Back-up
> > Database-Complete selected, and Backup to disk. There is one destination
> > identified from an earlier backup. I tried creating a new destination,
> > but
> > when I click OK, I get the error "The volume on device {my new destination
> > name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> > be
> > used to form a new media set"
> >
> > I don't see an option for BACKUP WITH FORMAT.
> >
> > I thought of trying to use the existing destination, but I'm not sure
> > whether to append or overwrite it. I am trying to get a full copy to put
> > into a test db.
> >
> > Help!
> >
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destinat
ion
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destin
ation
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiti
ng
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!
Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>
|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>