filegroup is offline after restore

I am using SQL-2005 Beta. I created 7 filegroups and associate them to
a table "Myhour" through partition function and schema. It works fine.
Then I tried the following statements to backup and retore the first
filegroup:
BACKUP DATABASE Mydb
FILE='20050204' -- my first filegroup
TO DISK='C:\backup\20050204.bak'
GO
RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
GO
The execution is OK. However, after that, I could not access data from
Myhour table:
SELECT * from Myhour
GO
The error message is that '20050204' filegroup is offline. I tried
many ways. I could not figure out how to bring this filegroup online.
I event tried to remove the filegroup. I got the same offline message.
Any way to bring filegroup online?
David Chu
Information regarding filegroup restore is available in Books Online. Basically, you restored part
of the database to an earlier point in time. You don't want SQL Server to be all happy and let you
use this possibly inconsistent database? So you need to apply the transaction log backups since the
database backup was performed so that SQL Server can re-apply the work that has been performed for
that filegroup. New for SQL Server 2005 is that you can set that filegroup to read-only (before the
backup and not change it back to read write) and then restore of transaction logs are not necessary
as SQL Server would know that no data has been changed in the filegroup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502090925.2966a624@.posting.google.c om...
>I am using SQL-2005 Beta. I created 7 filegroups and associate them to
> a table "Myhour" through partition function and schema. It works fine.
> Then I tried the following statements to backup and retore the first
> filegroup:
> BACKUP DATABASE Mydb
> FILE='20050204' -- my first filegroup
> TO DISK='C:\backup\20050204.bak'
> GO
> RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
> GO
> The execution is OK. However, after that, I could not access data from
> Myhour table:
> SELECT * from Myhour
> GO
> The error message is that '20050204' filegroup is offline. I tried
> many ways. I could not figure out how to bring this filegroup online.
> I event tried to remove the filegroup. I got the same offline message.
> Any way to bring filegroup online?
> David Chu
|||OK. I may do something not correctly to restore filegroup. For my
current position, is there way to bring my offline filegroup
(20050204) back on line? Without it back on line, I could not do
anything about my table Myhour because 20050204 is a partition of the
table.
|||Try backing up the transaction log, restore the file group and then restore the transaction log
backup. But check Books Online first. It was a while since I worked with filegroup backup and
restore, so I might be a bit rusty on the details.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502100818.72e989f3@.posting.google.c om...
> OK. I may do something not correctly to restore filegroup. For my
> current position, is there way to bring my offline filegroup
> (20050204) back on line? Without it back on line, I could not do
> anything about my table Myhour because 20050204 is a partition of the
> table.

filegroup is offline after restore

I am using SQL-2005 Beta. I created 7 filegroups and associate them to
a table "Myhour" through partition function and schema. It works fine.
Then I tried the following statements to backup and retore the first
filegroup:
BACKUP DATABASE Mydb
FILE='20050204' -- my first filegroup
TO DISK='C:\backup\20050204.bak'
GO
RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
GO
The execution is OK. However, after that, I could not access data from
Myhour table:
SELECT * from Myhour
GO
The error message is that '20050204' filegroup is offline. I tried
many ways. I could not figure out how to bring this filegroup online.
I event tried to remove the filegroup. I got the same offline message.
Any way to bring filegroup online?
David ChuInformation regarding filegroup restore is available in Books Online. Basica
lly, you restored part
of the database to an earlier point in time. You don't want SQL Server to be
all happy and let you
use this possibly inconsistent database? So you need to apply the transactio
n log backups since the
database backup was performed so that SQL Server can re-apply the work that
has been performed for
that filegroup. New for SQL Server 2005 is that you can set that filegroup t
o read-only (before the
backup and not change it back to read write) and then restore of transaction
logs are not necessary
as SQL Server would know that no data has been changed in the filegroup.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502090925.2966a624@.posting.google.com...
>I am using SQL-2005 Beta. I created 7 filegroups and associate them to
> a table "Myhour" through partition function and schema. It works fine.
> Then I tried the following statements to backup and retore the first
> filegroup:
> BACKUP DATABASE Mydb
> FILE='20050204' -- my first filegroup
> TO DISK='C:\backup\20050204.bak'
> GO
> RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
> GO
> The execution is OK. However, after that, I could not access data from
> Myhour table:
> SELECT * from Myhour
> GO
> The error message is that '20050204' filegroup is offline. I tried
> many ways. I could not figure out how to bring this filegroup online.
> I event tried to remove the filegroup. I got the same offline message.
> Any way to bring filegroup online?
> David Chu|||OK. I may do something not correctly to restore filegroup. For my
current position, is there way to bring my offline filegroup
(20050204) back on line? Without it back on line, I could not do
anything about my table Myhour because 20050204 is a partition of the
table.|||Try backing up the transaction log, restore the file group and then restore
the transaction log
backup. But check Books Online first. It was a while since I worked with fil
egroup backup and
restore, so I might be a bit rusty on the details.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502100818.72e989f3@.posting.google.com...
> OK. I may do something not correctly to restore filegroup. For my
> current position, is there way to bring my offline filegroup
> (20050204) back on line? Without it back on line, I could not do
> anything about my table Myhour because 20050204 is a partition of the
> table.

filegroup is offline after restore

I am using SQL-2005 Beta. I created 7 filegroups and associate them to
a table "Myhour" through partition function and schema. It works fine.
Then I tried the following statements to backup and retore the first
filegroup:
BACKUP DATABASE Mydb
FILE='20050204' -- my first filegroup
TO DISK='C:\backup\20050204.bak'
GO
RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
GO
The execution is OK. However, after that, I could not access data from
Myhour table:
SELECT * from Myhour
GO
The error message is that '20050204' filegroup is offline. I tried
many ways. I could not figure out how to bring this filegroup online.
I event tried to remove the filegroup. I got the same offline message.
Any way to bring filegroup online?
David ChuInformation regarding filegroup restore is available in Books Online. Basically, you restored part
of the database to an earlier point in time. You don't want SQL Server to be all happy and let you
use this possibly inconsistent database? So you need to apply the transaction log backups since the
database backup was performed so that SQL Server can re-apply the work that has been performed for
that filegroup. New for SQL Server 2005 is that you can set that filegroup to read-only (before the
backup and not change it back to read write) and then restore of transaction logs are not necessary
as SQL Server would know that no data has been changed in the filegroup.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502090925.2966a624@.posting.google.com...
>I am using SQL-2005 Beta. I created 7 filegroups and associate them to
> a table "Myhour" through partition function and schema. It works fine.
> Then I tried the following statements to backup and retore the first
> filegroup:
> BACKUP DATABASE Mydb
> FILE='20050204' -- my first filegroup
> TO DISK='C:\backup\20050204.bak'
> GO
> RESTORE DATABASE Mydb FROM DISK='C:\backup\20050204.bak'
> GO
> The execution is OK. However, after that, I could not access data from
> Myhour table:
> SELECT * from Myhour
> GO
> The error message is that '20050204' filegroup is offline. I tried
> many ways. I could not figure out how to bring this filegroup online.
> I event tried to remove the filegroup. I got the same offline message.
> Any way to bring filegroup online?
> David Chu|||OK. I may do something not correctly to restore filegroup. For my
current position, is there way to bring my offline filegroup
(20050204) back on line? Without it back on line, I could not do
anything about my table Myhour because 20050204 is a partition of the
table.|||Try backing up the transaction log, restore the file group and then restore the transaction log
backup. But check Books Online first. It was a while since I worked with filegroup backup and
restore, so I might be a bit rusty on the details.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"David Chu" <chudq@.hotmail.com> wrote in message
news:ec313994.0502100818.72e989f3@.posting.google.com...
> OK. I may do something not correctly to restore filegroup. For my
> current position, is there way to bring my offline filegroup
> (20050204) back on line? Without it back on line, I could not do
> anything about my table Myhour because 20050204 is a partition of the
> table.

File Share Data Processing Extension Sample

Hi all, I am very new to this Reporting Services and I want to follow this
sample that comes with SQL Server 2005 Beta. However, I tried everything
according to the documentation (build the sample, deploy it by modifying the
config files, etc.). Unfortunately, when I create a new report (using the
Report Wizard) in Visual Studio 2005, I still cannot see the File Share
Information.
Searching this newsgroup pointed me to this
http://blogs.msdn.com/bryanke/archive/2004/05/14/132110.aspx#148541
However, this does not help me either.
Any help is greatly appreciated!
Thanks a lot!
JennyHi Jenny,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to deploy
FsiDataExtension and then use it in the Report Manager. If I have
misunderstood your concern, please feel free to point it out.
Based on my knowledge, here is a sample in Reporting Services 2000 but I am
not sure whether it is available in SQL Server 2005 Reporting Services.
For SQL Server 2005's issue, please post the question in the link below
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
For SQL Server 2000 Reporting Services, you could follow the steps below as
described in MSDN Online
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
m/rss_sampleapps_v1_16g2.asp
- Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
report server. The default location for report server extensions is
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin.
- Copy the assembly to Report Designer. The default location for
extensions for Report Designer is C:\Program Files\Microsoft SQL
Server\80\Tools\ReportDesigner.
- Add the following entry to both the RSReportServer.config and
RSReportDesigner.config files under the Data element.
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
- To enable the generic query designer for the sample data processing
extension, add the following entry to the RSReportDesigner.config file
under the Designer element.
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Michael
Thanks for the reply. Please see my questions inline. Thanks in advance!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to deploy
> FsiDataExtension and then use it in the Report Manager. If I have
> misunderstood your concern, please feel free to point it out.
Yes you're right.
> Based on my knowledge, here is a sample in Reporting Services 2000 but I am
> not sure whether it is available in SQL Server 2005 Reporting Services.
> For SQL Server 2005's issue, please post the question in the link below
> http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
> cid=us
It's available and the steps look the same to me! Anyway, I have posted my
question in that beta newsgroup as well. Thanks!
> For SQL Server 2000 Reporting Services, you could follow the steps below as
> described in MSDN Online
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/ht
> m/rss_sampleapps_v1_16g2.asp
> - Copy Microsoft.Samples.ReportingServices.FsiDataExtension.dll to the
> report server. The default location for report server extensions is
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\bin.
> - Copy the assembly to Report Designer. The default location for
> extensions for Report Designer is C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner.
I interpreted 'Copy the assembly' as 'copy the dll' as in the previous step.
Is this correct?
> - Add the following entry to both the RSReportServer.config and
> RSReportDesigner.config files under the Data element.
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> - To enable the generic query designer for the sample data processing
> extension, add the following entry to the RSReportDesigner.config file
> under the Designer element.
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
>
I did all the above plus the steps in 'To configure code access security for
the sample'. I didn't know where exactly to put the CodeGroup info in the
config files unfortunately. I have tried a few spots and none succeeds. :-(
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>|||Hi
For you questions
>>I interpreted 'Copy the assembly' as 'copy the dll' as in
>>the previous step. Is this correct?
Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
destination.
>> I did all the above plus the steps in 'To configure code access security
for
>> the sample'. I didn't know where exactly to put the CodeGroup info in
the
>> config files unfortunately. I have tried a few spots and none succeeds.
:-(
snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
SQL Server\80\Tools\Report Designer for your reference.
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
oft.ReportingServices.DataExtensions" />
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
osoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
er,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
soft.ReportingServices.DataExtensions"/>
<Extension Name="FSI"
Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
rosoft.Samples.ReportingServices.FsiDataExtension"/>
</Data>
<Designer>
<Extension Name="SQL"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="ODBC"
Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
rvices.Designer"/>
<Extension Name="FSI"
Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
ngServices.Designer"/>
</Designer>
If you have any questions or concerns, don't hesitate to let me know. We
are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi there
Thank you for your help, but what I wanted was where to put the following
code group info in both the rssrvpolicy.config and rspreviewpolicy.config.
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="FSICodeGroup"
Description="Code group for my FSI data processing extension">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\bin\Microsoft.Samples.ReportingServices.FsiDataExtension.dll"
/>
</CodeGroup>
Thanks again and I appreciate your help!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi
> For you questions
> >>I interpreted 'Copy the assembly' as 'copy the dll' as in
> >>the previous step. Is this correct?
> Yes, I copied Microsoft.ReportingServices.Interfaces.dll from C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Extensions\FsiDataExtension\cs\bin\Debug to the
> destination.
> >> I did all the above plus the steps in 'To configure code access security
> for
> >> the sample'. I didn't know where exactly to put the CodeGroup info in
> the
> >> config files unfortunately. I have tried a few spots and none succeeds.
> :-(
> snippet from my RSReportServer.config in C:\Program Files\Microsoft SQL
> Server\MSSQL\Reporting Services\ReportServer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> snippet from my RSReportDesigner.config file in C:\Program Files\Microsoft
> SQL Server\80\Tools\Report Designer for your reference.
> <Data>
> <Extension Name="SQL"
> Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Micros
> oft.ReportingServices.DataExtensions" />
> <Extension Name="OLEDB"
> Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Micr
> osoft.ReportingServices.DataExtensions"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapp
> er,Microsoft.ReportingServices.DataExtensions"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Micro
> soft.ReportingServices.DataExtensions"/>
> <Extension Name="FSI"
> Type="Microsoft.Samples.ReportingServices.FsiDataExtension.FsiConnection,Mic
> rosoft.Samples.ReportingServices.FsiDataExtension"/>
> </Data>
> <Designer>
> <Extension Name="SQL"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="OLEDB"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ORACLE"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="ODBC"
> Type="Microsoft.ReportDesigner.Design.VDTQueryDesigner,Microsoft.ReportingSe
> rvices.Designer"/>
> <Extension Name="FSI"
> Type="Microsoft.ReportDesigner.Design.GenericQueryDesigner,Microsoft.Reporti
> ngServices.Designer"/>
> </Designer>
> If you have any questions or concerns, don't hesitate to let me know. We
> are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>|||Oh I see! Thanks for your help. I finally see the File Share Extension in
the list, but when I want to do more with that, I got this error:
"The designer extension FSI could not be loaded. Check the configuration
file RSReportDesigner.config." [OK]
Am I still missing something?
Thanks a lot!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Actually, I have figured it out. I got the Assembly name wrong. Once I
fixed it, I could see it in the list and load it as well. The report preview
looks good too. :-)
Unfortunately, I couldn't deploy the report. The Report Server cannot be
started for unknown reasons. When I browse http://localhost/ReportServer,
the error is
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) "
What did I do wrong? I have tried re-setting these config files but it
still doesn't work. :-(
rssrvpolicy.config
rsreportserver.config
Please help!! Thanks!!
Jenny
"Michael Cheng [MSFT]" wrote:
> Hi Jenny,
> I have attached rssrvpolicy.config and rspreviewpolicy.config for your
> reference.
> Put the <CodeGroup > like other <CodeGroup> does will be OK. Something like
> this
> <CodeGroup
> class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="Dundas_Strong_Name"
> Description="This code group grants
> Dundas assemblies. ">
> <IMembershipCondition
> class="StrongNameMembershipCondition"
> version="1"
> PublicKeyBlob="0024000004800000940000000602000000240000525341310004000001000
> 10043D98F8A9067EF3BCD442ADE2DD48CC6A6FACBCEB1C42DE2847B0A464096C02EEBF6FD87E
> 3889BEED32B9ABD1525A11A282232CD4C46CC8123F8CC08A113CD435429646220969FF444734
> 8D1C21874670834C7A7E89EA8956FC00E0F84FD3DF6FB3EBF21774438AF9E760414FDE06BC2C
> 3AF35FF3DD87578630ED13FE12CBDBC"
> />
> </CodeGroup>
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Name="FSICodeGroup"
> Description="Code group for my FSI data processing extension">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="C:\Program Files\Microsoft SQL
> Server\80\Tools\ReportDesigner\bin\Microsoft.Samples.ReportingServices.FsiDa
> taExtension.dll"
> />
> </CodeGroup>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Jenny,
The error message seems to indicate that you do not set congifuration file
rssrvpolicy.config and rsreportserver.config correctly. Please double check
configuration files again and my attachment file is just a sample file for
your reference. You cannot use them directly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.