 |
|
|
|
Next: "Level Zero Only" and "Allow in Pr..
|
| Author |
Message |
External
Since: Jul 27, 2005
Posts: 3
|
(Msg. 1) Posted: Wed Apr 12, 2006 10:58 am
Post subject: .Net 2.0 Framework error when running EXE remotely
Archived from groups: microsoft>public>sqlserver>setup (more info?)
|
|
|
Hi,
I am building a VB.Net 2005 application that will access a SQL Server
2005 database. If I run the EXE locally on the computer running SQL
Server _or_ copy the EXE to a remote computer, the application works as
expected. (Note I am logged in as administrator for all these test)
However, if I try to run the EXE remotely, I get this error:
Microsoft.Net Framework (title of dialog box)
"Application attempted to perform an operation not allowed by the
security policy. To grant the application the required permission,
contact your network administrator, or use the Microsoft .NET Framework
Configuration tool."
In .Net 1.1 there were tools to configure the Framework. I found
reference ..
"Starting with the .NET Framework 2.0, Mscorcfg.msc is installed with
the .NET Framework SDK."
I only installed the .Net Framework Version 2.0 Redistributable Package
(22+ M), so I need to get the entire SDK (354M!) for something that
sounds so simple?
Thanks in advance
Richard Fagen
If the Details section...
************** Exception Text **************
System.Security.SecurityException: Request for the permission of type
'System.Data.SqlClient.SqlClientPermission, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.PermissionSet.Demand()
at System.Data.Common.DbConnectionOptions.DemandPermission()
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at
System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection
outerConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables,
Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at
TestSQL.SteriliteDataSetTableAdapters.CustomerTableAdapter.Fill(CustomerDataTable
dataTable)
at TestSQL.Form1.Form1_Load(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at
System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
msg, IntPtr wparam, IntPtr lparam)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Data.SqlClient.SqlClientPermission
The Zone of the assembly that failed was:
Intranet |
|
| Back to top |
|
 | |
External
Since: Apr 12, 2006
Posts: 3
|
(Msg. 2) Posted: Wed Apr 12, 2006 10:58 am
Post subject: RE: .Net 2.0 Framework error when running EXE remotely [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Check in IIS to make sure that .net version 2 is allowed - check under web
service extensions under websites - this should sort it I think. Don't supose
you got any clused on my sql 2000 licensing question below? You seem to be
using a similar structure to us?
"Richard Fagen" wrote:
> Hi,
>
> I am building a VB.Net 2005 application that will access a SQL Server
> 2005 database. If I run the EXE locally on the computer running SQL
> Server _or_ copy the EXE to a remote computer, the application works as
> expected. (Note I am logged in as administrator for all these test)
>
> However, if I try to run the EXE remotely, I get this error:
>
> Microsoft.Net Framework (title of dialog box)
> "Application attempted to perform an operation not allowed by the
> security policy. To grant the application the required permission,
> contact your network administrator, or use the Microsoft .NET Framework
> Configuration tool."
>
> In .Net 1.1 there were tools to configure the Framework. I found
> reference ..
> "Starting with the .NET Framework 2.0, Mscorcfg.msc is installed with
> the .NET Framework SDK."
>
> I only installed the .Net Framework Version 2.0 Redistributable Package
> (22+ M), so I need to get the entire SDK (354M!) for something that
> sounds so simple?
>
> Thanks in advance
>
> Richard Fagen
>
>
>
> If the Details section...
> ************** Exception Text **************
> System.Security.SecurityException: Request for the permission of type
> 'System.Data.SqlClient.SqlClientPermission, System.Data,
> Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
> at System.Security.CodeAccessSecurityEngine.Check(Object demand,
> StackCrawlMark& stackMark, Boolean isPermSet)
> at System.Security.PermissionSet.Demand()
> at System.Data.Common.DbConnectionOptions.DemandPermission()
> at System.Data.SqlClient.SqlConnection.PermissionDemand()
> at
> System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection
> outerConnection)
> at
> System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory)
> at System.Data.SqlClient.SqlConnection.Open()
> at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
> DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
> srcTable, IDbCommand command, CommandBehavior behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables,
> Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
> behavior)
> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
> at
> TestSQL.SteriliteDataSetTableAdapters.CustomerTableAdapter.Fill(CustomerDataTable
> dataTable)
> at TestSQL.Form1.Form1_Load(Object sender, EventArgs e)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Windows.Forms.Form.OnLoad(EventArgs e)
> at System.Windows.Forms.Form.OnCreateControl()
> at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
> at System.Windows.Forms.Control.CreateControl()
> at System.Windows.Forms.Control.WmShowWindow(Message& m)
> at System.Windows.Forms.Control.WndProc(Message& m)
> at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
> at System.Windows.Forms.ContainerControl.WndProc(Message& m)
> at System.Windows.Forms.Form.WmShowWindow(Message& m)
> at System.Windows.Forms.Form.WndProc(Message& m)
> at
> System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
> msg, IntPtr wparam, IntPtr lparam)
> The action that failed was:
> Demand
> The type of the first permission that failed was:
> System.Data.SqlClient.SqlClientPermission
> The Zone of the assembly that failed was:
> Intranet
> |
|
| Back to top |
|
| |
External
Since: Jul 27, 2005
Posts: 3
|
(Msg. 3) Posted: Wed Apr 12, 2006 1:11 pm
Post subject: Re: .Net 2.0 Framework error when running EXE remotely [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Hi,
You are right, they moved things around. I found the DotNet config tools.
Initially I was using SQL Express that didn't need IIS so I didn't
install that on my test PC. I installed the Express Versions as I
downloaded the great VB eBook and the tutorial movies.
Now I want to check out the full blown versions and SQL Std Ed. requires
IIS for reporting, so I installed IIS and now I found the config tool
Thanks!
Richard
rich wrote:
> Check in IIS to make sure that .net version 2 is allowed - check under web
> service extensions under websites - this should sort it I think. Don't supose
> you got any clused on my sql 2000 licensing question below? You seem to be
> using a similar structure to us?
>
> "Richard Fagen" wrote:
>
>
>>Hi,
>>
>>I am building a VB.Net 2005 application that will access a SQL Server
>>2005 database. If I run the EXE locally on the computer running SQL
>>Server _or_ copy the EXE to a remote computer, the application works as
>>expected. (Note I am logged in as administrator for all these test)
>>
>>However, if I try to run the EXE remotely, I get this error:
>>
>>Microsoft.Net Framework (title of dialog box)
>>"Application attempted to perform an operation not allowed by the
>>security policy. To grant the application the required permission,
>>contact your network administrator, or use the Microsoft .NET Framework
>>Configuration tool."
>>
>>In .Net 1.1 there were tools to configure the Framework. I found
>>reference ..
>>"Starting with the .NET Framework 2.0, Mscorcfg.msc is installed with
>>the .NET Framework SDK."
>>
>>I only installed the .Net Framework Version 2.0 Redistributable Package
>>(22+ M), so I need to get the entire SDK (354M!) for something that
>>sounds so simple?
>>
>>Thanks in advance
>>
>>Richard Fagen
>>
>>
>>
>>If the Details section...
>>************** Exception Text **************
>>System.Security.SecurityException: Request for the permission of type
>>'System.Data.SqlClient.SqlClientPermission, System.Data,
>>Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
>> at System.Security.CodeAccessSecurityEngine.Check(Object demand,
>>StackCrawlMark& stackMark, Boolean isPermSet)
>> at System.Security.PermissionSet.Demand()
>> at System.Data.Common.DbConnectionOptions.DemandPermission()
>> at System.Data.SqlClient.SqlConnection.PermissionDemand()
>> at
>>System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection
>>outerConnection)
>> at
>>System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
>>outerConnection, DbConnectionFactory connectionFactory)
>> at System.Data.SqlClient.SqlConnection.Open()
>> at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
>>DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
>>srcTable, IDbCommand command, CommandBehavior behavior)
>> at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables,
>>Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
>>behavior)
>> at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
>> at
>>TestSQL.SteriliteDataSetTableAdapters.CustomerTableAdapter.Fill(CustomerDataTable
>>dataTable)
>> at TestSQL.Form1.Form1_Load(Object sender, EventArgs e)
>> at System.EventHandler.Invoke(Object sender, EventArgs e)
>> at System.Windows.Forms.Form.OnLoad(EventArgs e)
>> at System.Windows.Forms.Form.OnCreateControl()
>> at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
>> at System.Windows.Forms.Control.CreateControl()
>> at System.Windows.Forms.Control.WmShowWindow(Message& m)
>> at System.Windows.Forms.Control.WndProc(Message& m)
>> at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
>> at System.Windows.Forms.ContainerControl.WndProc(Message& m)
>> at System.Windows.Forms.Form.WmShowWindow(Message& m)
>> at System.Windows.Forms.Form.WndProc(Message& m)
>> at
>>System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
>> at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
>> at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32
>>msg, IntPtr wparam, IntPtr lparam)
>>The action that failed was:
>>Demand
>>The type of the first permission that failed was:
>>System.Data.SqlClient.SqlClientPermission
>>The Zone of the assembly that failed was:
>>Intranet
>> >> Stay informed about: .Net 2.0 Framework error when running EXE remotely |
|
| Back to top |
|
| |
External
Since: Jul 27, 2005
Posts: 3
|
(Msg. 4) Posted: Wed Apr 12, 2006 1:17 pm
Post subject: Re: .Net 2.0 Framework error when running EXE remotely [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
I think I found something....
The DotNet config tool is on the server but not on the XP clients'
stations. I guess mscorcfg.msc got installed when I installed the
non-express versions (either Visual Studio Pro or SQL Server Std).
On the server, the menu shortcut points to:
"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\mscorcfg.msc"
Do I configure .Net 2.0 on the server once, or do I have to do something
to all the XP stations' configuration?
Richard
Richard Fagen wrote:
> Hi,
>
> I am building a VB.Net 2005 application that will access a SQL Server
> 2005 database. If I run the EXE locally on the computer running SQL
> Server _or_ copy the EXE to a remote computer, the application works as
> expected. (Note I am logged in as administrator for all these test)
>
> However, if I try to run the EXE remotely, I get this error:
>
> Microsoft.Net Framework (title of dialog box)
> "Application attempted to perform an operation not allowed by the
> security policy. To grant the application the required permission,
> contact your network administrator, or use the Microsoft .NET Framework
> Configuration tool."
>
> In .Net 1.1 there were tools to configure the Framework. I found
> reference ..
> "Starting with the .NET Framework 2.0, Mscorcfg.msc is installed with
> the .NET Framework SDK."
>
> I only installed the .Net Framework Version 2.0 Redistributable Package
> (22+ M), so I need to get the entire SDK (354M!) for something that
> sounds so simple?
>
> Thanks in advance
>
> Richard Fagen >> Stay informed about: .Net 2.0 Framework error when running EXE remotely |
|
| Back to top |
|
| |
| Related Topics: | What ports do i need to unblock on client and server (runn.. - What ports do i need to unblock on client and server (running msvsmon.exe) to debug remotely from my client box with visual studio 2005 pro? When I attach to remote process a connection shows up in msvsmon.exe on the remote machine, however, the clien...
Error Running Script: Replsys.SQL(1) during SQL 2000 SP3 u.. - Hey guys I was attempting to upgrade my SQL 2000 Developer version when I rcvd the message Error running script:Replsys.sql(1). When I hit the OKAY button to the error message it closed down the install. How do I correct and reinstall from that point....
Error Running Script: replsys.sql during installation SP4 .. - When I try to install SP4 on a W2003-Server with SQL 2000 Developer (both German version), I get the error message with "replsys.sql". I tried alread the following hints - stop many services - create C:\TMP and C:\TEMP directory for TMP and TE...
Can't connect remotely to SQL Server Express - I have installed SQL Server Express on a Windows 2003 platform. I have set the Windows firewall to allow sqlservr.exe and sqlbrowser.exe and udp port 1434. SQL browser is running. I have enable tcp/ip protocol. The SQL Server 2005 Surface Area ..
Installation freezes at .NET Framework 2.0 - I tried to install SQL Server 2005 Enterprise Edition (evaluation verison) on Windows Server 2003. I mounted the image file using Power ISO, but installation freezes after it gets to point where it installs .NET Framework 2.0. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
