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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

This is most likely caused by your project residing in an old folder that
doesn't have the necessary .Net security permissions. When you open the
project you may have received an error message stating something about
unsafe location. Also, this would happen if you save your project to a
network folder that is not a part of the .Net security framework. I can't
recall everything to be exact but the quickest way to test to see if this is
the case is to save your project to the project folder the initial VB.net
installation has created for you and run it from there. Read more about the
..Net Configuration tool to setup your security for a networked folder.

<steveeisen@xxxxxxxxx> wrote in message
news:1144592449.189906.127730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: Network shares cannot connect
    ... Changed value to 0 just waiting to re-boot the server and test logins. ... Workstation Name: - ... let's focus on the Users Shared Folder first. ... To check this permission, please click the Advanced button, select ...
    (microsoft.public.windows.server.sbs)
  • Re: Network shares cannot connect
    ... Changed value to 0 just waiting to re-boot the server and test logins. ... Workstation Name: - ... let's focus on the Users Shared Folder first. ... To check this permission, please click the Advanced button, select ...
    (microsoft.public.windows.server.sbs)
  • MCSA/MCSE Self-training book from MS PRESS for exam 70-215 incorrect on file permission questions?
    ... includes the AccountingDept folder, which contains documents specific to the ... accounting department. ... The Accounting group includes all members of the ... AccountingDept folder by granting Read permission to the Accounting group ...
    (microsoft.public.win2000.file_system)
  • Re: Network shares cannot connect
    ... User Name: SERVER$ ... Regarding the shares accessing problem, I suggest you try following steps ... let's focus on the Users Shared Folder first. ... To check this permission, please click the Advanced button, select ...
    (microsoft.public.windows.server.sbs)
  • Re: Practice Test with Wrong Answers?
    ... "The Modify permission does not include the Delete Subfolders and Files ... so permanent employees cannot delete files form the Progress ... When I try this out the modify permissions for the parent folder get ...
    (microsoft.public.cert.exam.mcsa)