'System.Security.SecurityException' with .NET 2005 Only

microsoft.public.dotnet.languages.vb.upgrade isn't getting much
traffic, so I'll try here.

Ours is a VB6 shop exploring .NET.


First I wrote a new application with VB .NET 2003 to create a pdf
Crystal Report from a SQL Server 2000 table. I followed advice from
the MSDN article "Add Professional Quality Reports to Your Application
with Visual Studio .NET"
(http://msdn.microsoft.com/msdnmag/issues/02/05/Crystal/), and it
worked fine.


Then we got in VB .NET 2005, and I tried to open this solution
there, with the idea of deploying it as our first .NET server app in a
few days. The Wizard seemed to take it from 2003 to 2005 with no
problem, and I get a clean build. However, when I run, I can't connect

to the test SQL Server I've been using even though I am an
administrator.


Here's the code:


Friend WithEvents scnSQLConnection As _
System.Data.SqlClient.SqlConnection
Friend WithEvents sdaDataAdapter As _
System.Data.SqlClient.SqlDataAdapter
Friend WithEvents ndsMain As MySolutionName.MyDatasetClassName
.. . .
Public Sub FrmThatHasCrystalViewer_Load(ByVal sender As Object, _
ByVal e As System.EventArgs) Handles MyBase.Load
scnSQLConnection.ConnectionString = _
"Persist Security Info=False;Integrated Security=SSPI;database=" & _

"MyDatabase;server=OurTestSQLServer2000"
sdaDataAdapter.Fill(ndsMain)


It fails on the line above and, in the immediate window, I get:


A first chance exception of type 'System.Security.SecurityException'
occurred in System.Data.dll


When I click on view detail, I get:


System.Security.SecurityException was unhandled
Message="Request for the permission of type
'System.Data.SqlClient.SqlClientPermission,
System.Data, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed."
Source="mscorlib" . . .


The dialog box suggests clicking on "Add Permission to the Project." I

did that, and get a dialog box saying "The new permission has been
added to your application. However, the change will not take effect
until the debugging session is restarted."


Restart the debugging session, same problem again. Go all the way of
VS and back in again, still same problem. Reboot, same problem.


I could deploy the VS 2003 build, but it would be nicer startingt off
with a consistent current version inventory, not to mention that I
would like to understand more.


All ideas and suggestions will be appreciated.


Steve Eisenberg

.

Relevant Pages

  • After 2003 to 2005 Upgrade Wizard, Getting System.Security.SecurityException
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: System.Security.SecurityException with .NET 2005 Only
    ... Please show how you are initializaing the variablles and the sql text. ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error !!! SQL XML Bulkload Please help
    ... Irwin Dolobowsky ... > The schedule job gets run by SQL server Agent and the SQL server agent is ... > which has also got the administrator permission. ... Is the scheduled job running as a different user? ...
    (microsoft.public.sqlserver.xml)