Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. Question about SqlClientPermission - SecurityException

Question about SqlClientPermission - SecurityException

Scheduled Pinned Locked Moved C#
csharphelpquestiondatabasesql-server
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • Y Offline
    Y Offline
    yboc
    wrote on last edited by
    #1

    I can run my C# .net application in the system I use to develop it, but when I deployed the application to a windows 2000 system with .netframework installed, I got below message: System.Security.SecurityException: Request for the permission of type System.Data.SqlClient.SqlClientPermission,System.Data, Version= 1.0.5000.0, Culture= neutral, PublickeyToken=b77a5c561934e089 failed. at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet grantedSet,PermissionSet deniedSet, CodeAccessPermission demand,PermissinToken permToken, ..... It seems that I can't get the permission to access Sql server. Could you pls tell me how to resolve this issue? Can anyone help to let me know how to set the permission to the application / user ? Thanks. coby

    T 1 Reply Last reply
    0
    • Y yboc

      I can run my C# .net application in the system I use to develop it, but when I deployed the application to a windows 2000 system with .netframework installed, I got below message: System.Security.SecurityException: Request for the permission of type System.Data.SqlClient.SqlClientPermission,System.Data, Version= 1.0.5000.0, Culture= neutral, PublickeyToken=b77a5c561934e089 failed. at System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet grantedSet,PermissionSet deniedSet, CodeAccessPermission demand,PermissinToken permToken, ..... It seems that I can't get the permission to access Sql server. Could you pls tell me how to resolve this issue? Can anyone help to let me know how to set the permission to the application / user ? Thanks. coby

      T Offline
      T Offline
      TigerNinja_
      wrote on last edited by
      #2

      Just curious, does the credentials in your connection string have the proper security access ?


      R.Bischoff .NET, Kommst du mit?

      A 1 Reply Last reply
      0
      • T TigerNinja_

        Just curious, does the credentials in your connection string have the proper security access ?


        R.Bischoff .NET, Kommst du mit?

        A Offline
        A Offline
        Anonymous
        wrote on last edited by
        #3

        It seems that the issue is because the .net framework can't get the permission to run sql store procedure locally. What I can saw is the connection string can get the server and uid but the pwd is cut. Actually, I did nothing to cut it in the program. Really strange, isn't it?

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups