Professional Web Applications Themes

Access Denied to sqlConnection - ASP.NET Security

I am trying to make a connection to the Db and everytime I try to open the connection I get "access denied" "ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user." Now I have asp.net process running under a service ...

  1. #1

    Default Access Denied to sqlConnection

    I am trying to make a connection to the Db and everytime I try to open
    the connection I get "access denied"

    "ASP.NET is not authorized to access the requested resource. Consider
    granting access rights to the resource to the ASP.NET request
    identity. ASP.NET has a base process identity (typically
    {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if
    the application is not impersonating. If the application is
    impersonating via <identity impersonate="true"/>, the identity will be
    the anonymous user (typically IUSR_MACHINENAME) or the authenticated
    request user."


    Now I have asp.net process running under a service account which is
    part of the local admins.
    web.config settings
    <identity impersonate="false"/>
    <authentication mode="Windows" />

    I have IIS5 running intergrate security.

    The Connection string I used through the gui in vs.net which was able
    to see the tables. So it can see it.

    Does anyone have an idea what this is? Help me please. This is
    driving me crazy. I hate MS.

    Also, I had it under impersonate = true and the stupid app kept ask
    for my username\password\domain. Why is not using the sa account?
    Here is my connectiob string.
    this.sqlConnection1.ConnectionString = "workstation
    id=NYCNJGIBLIN;packet size=4096;user id=sa;data
    source=\"nycnjgiblin\\p" +
    "erfect\";persist security info=False;initial catalog=SitePages";

    any help would be appreciated.
    John
    John Giblin Guest

  2. #2

    Default Re: Access Denied to sqlConnection

    Are you using Windows authentication or moxed mode authentication on SQL
    Server?

    --
    Naveen K Kohli
    [url]http://www.netomatix.com[/url]
    "John Giblin" <jwgiblin3hotmail.com> wrote in message
    news:3d6785ec.0307150801.371426a2posting.google.c om...
    > I am trying to make a connection to the Db and everytime I try to open
    > the connection I get "access denied"
    >
    > "ASP.NET is not authorized to access the requested resource. Consider
    > granting access rights to the resource to the ASP.NET request
    > identity. ASP.NET has a base process identity (typically
    > {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if
    > the application is not impersonating. If the application is
    > impersonating via <identity impersonate="true"/>, the identity will be
    > the anonymous user (typically IUSR_MACHINENAME) or the authenticated
    > request user."
    >
    >
    > Now I have asp.net process running under a service account which is
    > part of the local admins.
    > web.config settings
    > <identity impersonate="false"/>
    > <authentication mode="Windows" />
    >
    > I have IIS5 running intergrate security.
    >
    > The Connection string I used through the gui in vs.net which was able
    > to see the tables. So it can see it.
    >
    > Does anyone have an idea what this is? Help me please. This is
    > driving me crazy. I hate MS.
    >
    > Also, I had it under impersonate = true and the stupid app kept ask
    > for my username\password\domain. Why is not using the sa account?
    > Here is my connectiob string.
    > this.sqlConnection1.ConnectionString = "workstation
    > id=NYCNJGIBLIN;packet size=4096;user id=sa;data
    > source=\"nycnjgiblin\\p" +
    > "erfect\";persist security info=False;initial catalog=SitePages";
    >
    > any help would be appreciated.
    > John

    Naveen K Kohli Guest

Similar Threads

  1. One With Access Denied, Another With Access, But NotFull
    By checkersam in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: May 10th, 06:43 PM
  2. Web Service + Anon Access, but getting 401 Access Denied Error
    By Alex Washtell via .NET 247 in forum ASP.NET Web Services
    Replies: 1
    Last Post: April 5th, 04:57 PM
  3. Custom Control design time access to SQLConnection on Web Page
    By Robin Shaw in forum ASP.NET Data Grid Control
    Replies: 3
    Last Post: August 12th, 02:19 PM
  4. Access denied when creating Access application object
    By Bill Murphy in forum ASP Database
    Replies: 7
    Last Post: July 31st, 05:37 PM
  5. access denied on data access pages
    By Bonnie in forum Microsoft Access
    Replies: 0
    Last Post: July 15th, 06:03 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139