Thursday, March 29, 2012

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 accessing database

When I launch a client program that reads the database, I
get the following error message
Error while reading information from database
Error Code Login failed for user 'sa'
Reason Not associated with a trusted SQL Server Connection.
Has anyone got ideas on how to Fix this?
Thanks in advance
DarrinHave a look at the server properties. You should see that the server is set
up to use Windows Authentication only. sa is not a windows account. You
are using sa in a client app. Most people would advise against this.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Darrin" <darrin.adams@.eei.ericsson.se> wrote in message
news:0a6801c3510d$b546da10$a501280a@.phx.gbl...
> When I launch a client program that reads the database, I
> get the following error message
> Error while reading information from database
> Error Code Login failed for user 'sa'
> Reason Not associated with a trusted SQL Server Connection.
> Has anyone got ideas on how to Fix this?
> Thanks in advance
> Darrin

Error access Custom Assembly in Deploying

Please,

i did a class in C# that return a array of bytes... in preview mode (design) i can see this return, but when i use Deploy (Server) i can′t see.

I already put the lines on of security in file srrsvpolicy.config and copy the file dll to folder, however i cant see the result.

Anybody help me?

I′m using:

- SQL 2005
- dll no strong name

Thanks

Jota

Assuming you have put the right security settings and deployed the assembly to the Report Server bin folder, your method may need additional CAS security rights depending on what your code is trying to do, as explained in more details here. What I suggest you do is put a breakpoint in your assembly code, attach to the ASP.NET process, and run the report so you can debug your code and see where the exception is thrown.

Error accesing RS

I change the windows authentication from the default site folder security and before I change again to windows authentication. But now when I want to open reportmanager It raises Unable to generate a temporaty class (result=1) . error CS2001: Source file 'C:\WINDOWS\TEMP\ugmf4j6-0.cs' could not be found error CS2008: No inputs specified.

Any ideas?
RS Services April CTP.
Thanks in advanceI need to solve this quickly!!! I have a presentation with a director.

I thinking in reinstall IIS.

What can I do?|||I found no solution to this. I finally reinstalled IIS.

Error accepting connection request via Net-Library 'SSNETLIB'

Hi,
I installed SP3 over SQL2K on NT Server SP6. The Server
hangs on startup. This is after I did an upgrade
installation of SQL 7 to SQL Server 2000 and applied SP3
over it. Everything runs fine for afew hours and then we
get the message below and some of our servers lose the
ability to connect to the sql server.
2003-12-18 10:20:08.84 spid65 Using 'xp_AltaMX.dll' version
'0002.00.00' to execute extended stored
procedure 'xp_AltaMX'.
2003-12-18 11:01:49.43 spid62 Using 'xpipass.dll'
version 'UNKNOWN'to execute extended stored
procedure 'xp_ipass_actualiza'.
2003-12-18 12:24:01.62 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:24:01.62 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:24:01.62 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:24:01.62 server Operating system error 1:
Incorrect function...
2003-12-18 12:31:58.09 server SQL Server could not spawn
process_loginread thread.
2003-12-18 12:31:59.09 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:31:59.09 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:31:59.09 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:31:59.09 server Operating system error 1:
Incorrect function...
2003-12-18 12:41:30.01 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:41:30.01 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:41:30.01 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:41:30.01 server Operating system error 1:
Incorrect function...
2003-12-18 12:51:21.10 server SQL Server is disallowing new
connections due to 'pause' request from Service Control
Manager.
2003-12-18 12:53:09.60 spid3 SQL Server is terminating due
to 'stop' request from Service Control Manager.
I would be greatful if anyone has any ideas on how to deal
with this ?
I already reviewed this article but me it has not been
helpful.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;811887&Product=sql2k
I am of course afraid that someday we will not be able to
access the
sql server.
Regards,
LeoWho supplied you with
xp_AltaMX
xpipass.dll
xp_ipass_actualiza
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
The development area supplied them. Let me tell you=20
something, when this server was working under SQL 7, this=20
error never appeared. After upgrade the error appeared.
Do you think that the problem may be are the xp=B4s?
thanks,
Leo|||Drop /remove the xp's and see if the problem persists. Do this in your
Test environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql

Error about Report builder

I login in my server do report with report builder , when i run report , the error is:

The permissions granted to user 'ADSYSTEC-CZW\users11' are insufficient for performing this operation.

1. The server and my machine are not the same computer,My machine name is adsystec-czw.

2. The reports web site's Authentication is Integrated Windows Authentication.

3. I use the given user(users11) login in belongs to the user groups.


thanks for helps!

Since you are saying you get the error when running the report, I am assuming you have no problem launching Report Builder, viewing Models, and creating and saving a Report to the server. Have you tried running your report directly from the server, after saving it there?

It sounds like your problem may be that the datasource your report uses is not set up correctly. If the data you are trying to retrieve is on a different server than your Report Server, you may need to check the "Use Windows credentials" checkbox in (ie. edit your Datasource in Report Manager).

|||I login in the server's report builder with the URL http://adsystec-czw/reportserver/reportbuilder/reportbuilder.application If I use the server's administrators to login in the server's report server, That error doesn't exist.

Error about OLAP Admin permissions

Hi iam executing this code and iam getting the error

Unable to connect to the registry on the server (SQLSERVER), or you are not a member of the OLAP Administrators group on this server.

The code is

Private Sub cbDataBaseList_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cbDataBaseList.SelectedIndexChanged

Dim dsoServer As New DSO.Server

Dim dsoDB As DSO.MDStore

Dim dsoCube As DSO.MDStore

' Create a connection to the Analysis server.

dsoServer.Connect("Localhost")

' Step through the databases in the server object.

For Each dsoDB In dsoServer.MDStores

' Print the name of the database into drop down box

cboDbName.Items.Add(dsoDB.Name)

Next dsoDB

listCubes.Items.Clear()

Dim strDataBaseName As String
strDataBaseName = cbDataBaseList.SelectedItem

Dim dsoDb As DSO.MDStore

If dsoServer.MDStores.Find(strDataBaseName) Then

dsoDb = dsoServer.MDStores.Item(strDataBaseName)

Dim dsoCube As DSO.MDStore
For Each dsoCube In dsoDb.MDStores
listCubes.Items.Add(dsoCube.Name)
Next

End If

End Sub


I donno whats that error and how to fix it if some one could help me it would be great.

Thank You

Emily

There are two common causes of this error that I am aware of

1) You are not a member of the OLAP Administrators group on the server (obviously, but I assume you have double checked this)

2) The server has had a service pack applied, but the client has an older version of the DSO libraries.

If item 1) is not your issue then what I would suggest is to find out what service pack has been applied to the server.

To find out the current level of Windows 2000 Analysis Services, start the Analysis Manager, right-click on the Analysis Servers node, and select "About Analysis Services." (Note that this tells you the SP that is on the machine running Analysis Manager - so you might want to run this check on the server console)

Once you have the version number, then match it to the list below to find which SQL Server service pack you are using.

2000.8.0.2039 Analysis Services SP 4 2000.8.0.760 Analysis Services SP 3 2000.8.0.532 Analysis Services SP 2 2000.8.0.382 Analysis Services SP1 2000.8.0.194 Analysis Services "gold" release, no SP