Error accessing registry value in report

We store environment specific information in the registry to ease moving from
dev, test and production environments. I'm making a call in the code window
to read from the registry and am getting this error:
Failed to load expression host assembly. Details: Request for the permission
of type System.Security.Permissions.RegistryPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
(rsProcessingError) Get Online Help
Just as a test I've changed all code access security zones to Full Trust but
this hasn't helped.
Please advise.This is what I had to do to get this working, if anyone's interested:
Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\rssrvpolicy.config and modify the entry in the
Report_Expressions_Default_Permissions CodeGroup and change it from Execute
to FullTrust.
"Aaron" wrote:
> We store environment specific information in the registry to ease moving from
> dev, test and production environments. I'm making a call in the code window
> to read from the registry and am getting this error:
> Failed to load expression host assembly. Details: Request for the permission
> of type System.Security.Permissions.RegistryPermission, mscorlib,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
> (rsProcessingError) Get Online Help
> Just as a test I've changed all code access security zones to Full Trust but
> this hasn't helped.
> Please advise.
>|||Giving FullTrust to Report_Expressions_Default_Permissions totally opens
your server for hacker attacks. Now all expressions incliding VB.NET
snippets in Report.Code have fulltrust which allows them to perform any
operations, including formatting drives, reading and writing files etc...
The better way is to create a custom assembly with functions to read
registry and call this assembly from your reports. You will then give only
RegistryPermission to that assembly.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:281FF58C-043F-40DA-AFCF-4C413BFC2A49@.microsoft.com...
> This is what I had to do to get this working, if anyone's interested:
> Edit C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\rssrvpolicy.config and modify the entry in the
> Report_Expressions_Default_Permissions CodeGroup and change it from
Execute
> to FullTrust.
>
> "Aaron" wrote:
> > We store environment specific information in the registry to ease moving
from
> > dev, test and production environments. I'm making a call in the code
window
> > to read from the registry and am getting this error:
> >
> > Failed to load expression host assembly. Details: Request for the
permission
> > of type System.Security.Permissions.RegistryPermission, mscorlib,
> > Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.
> > (rsProcessingError) Get Online Help
> >
> > Just as a test I've changed all code access security zones to Full Trust
but
> > this hasn't helped.
> >
> > Please advise.
> >|||Aaron I have done similar kind of thing, If your still facing the problem
write to me, I can help you out to fix the issue.
My Email ID:
balajikkrishnan [AT] rediffmail [DOT] com
Thanks
Balaji
--
Message posted via http://www.sqlmonster.comsql

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis
|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
Dennis
"Tibor Karaszi" wrote:

> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Devic
e
activation error. The physical filename...maybe incorrect. File...cannot b
e
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the consol
e
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root.
Are you saying that the restore executed without error message but you didn'
t see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the da
tabase.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Dev
ice
> activation error. The physical filename...maybe incorrect. File...cannot
be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the cons
ole
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:

> Are you saying that the restore executed without error message but you did
n't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the
database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
>
>

Error 5123: CREATE FILE encountered operating system error 32

I'm moving a database from Server A to Server B. When I tried to restore
from the .BAK file in Enterprise Manager I got an error message about "Device
activation error. The physical filename...maybe incorrect. File...cannot be
restored to...Use WITH MOVE to identify a valid location for the file."
So I tried to restore from Query Analyzer with...
RESTORE FILELISTONLY
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
RESTORE DATABASE USQL_Data
FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
WITH NORECOVERY,
MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
The 2 files are physically restored as named in the MOVE statement. In
Enterprise Manager the restored database name does not show up in the console
root. I tried to attach the restored database but get an error message
"Error 5123: CREATE FILE encountered operating system error 32..."
What do I need to do to use the restored database in Enterprise Manager?
--
Dennis> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root.
Are you saying that the restore executed without error message but you didn't see the database in
EM? If so, it is most likely that you need to do refresh in EM to see the database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> I'm moving a database from Server A to Server B. When I tried to restore
> from the .BAK file in Enterprise Manager I got an error message about "Device
> activation error. The physical filename...maybe incorrect. File...cannot be
> restored to...Use WITH MOVE to identify a valid location for the file."
> So I tried to restore from Query Analyzer with...
> RESTORE FILELISTONLY
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> RESTORE DATABASE USQL_Data
> FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> WITH NORECOVERY,
> MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> The 2 files are physically restored as named in the MOVE statement. In
> Enterprise Manager the restored database name does not show up in the console
> root. I tried to attach the restored database but get an error message
> "Error 5123: CREATE FILE encountered operating system error 32..."
> What do I need to do to use the restored database in Enterprise Manager?
> --
> Dennis|||Yes. The restore executed without error from Query Analyzer, but the
database didn't show up in EM console root after the restore. I tried a
refresh. Still didn't show up. I did get the restore to work through EM
since my first post. I copied and pasted the path from Windows Explorer
rather than typing it and it worked.
--
Dennis
"Tibor Karaszi" wrote:
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root.
> Are you saying that the restore executed without error message but you didn't see the database in
> EM? If so, it is most likely that you need to do refresh in EM to see the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dennis" <Dennis@.discussions.microsoft.com> wrote in message
> news:A47A4F39-4343-4BBE-AC3B-65CEBD957D6A@.microsoft.com...
> > I'm moving a database from Server A to Server B. When I tried to restore
> > from the .BAK file in Enterprise Manager I got an error message about "Device
> > activation error. The physical filename...maybe incorrect. File...cannot be
> > restored to...Use WITH MOVE to identify a valid location for the file."
> >
> > So I tried to restore from Query Analyzer with...
> > RESTORE FILELISTONLY
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> >
> > RESTORE DATABASE USQL_Data
> > FROM disk = 'C:\Dennis\OCT2004_POST_INVENTORY.BAK'
> > WITH NORECOVERY,
> > MOVE 'usql_data' TO 'C:\Dennis\FY2004.mdf',
> > MOVE 'usql_log' TO 'C:\Dennis\FY2004.ldf'
> >
> > The 2 files are physically restored as named in the MOVE statement. In
> > Enterprise Manager the restored database name does not show up in the console
> > root. I tried to attach the restored database but get an error message
> > "Error 5123: CREATE FILE encountered operating system error 32..."
> >
> > What do I need to do to use the restored database in Enterprise Manager?
> >
> > --
> > Dennis
>
>