Professional Web Applications Themes

Using Integrated Security for Accessing SQL on Remote Server - ASP.NET Security

Hello, I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet) I am following this article [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskaccessingsqlserverwithexplicitcredentials.as[/url] So far I hav 1. Set the Web.config file to impersonate a specific domain use <identity impersonate="true" userName = "myDomain\myUserName" password="password"/ 2. Created the login in the SQL server and given it appropriate permission 3. Used Integrated Security = SSPI in the connection strin 4. IIS does not allow anonymous access on the site and is using Windows Integrated Securit So far it's a no go I've also gone as far as ...

  1. #1

    Default Using Integrated Security for Accessing SQL on Remote Server

    Hello,

    I am currently trying to use integrated security to access the SQL database for the ASP.NET application (deployed on an intranet)

    I am following this article
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskaccessingsqlserverwithexplicitcredentials.as[/url]

    So far I hav
    1. Set the Web.config file to impersonate a specific domain use
    <identity impersonate="true" userName = "myDomain\myUserName" password="password"/
    2. Created the login in the SQL server and given it appropriate permission
    3. Used Integrated Security = SSPI in the connection strin
    4. IIS does not allow anonymous access on the site and is using Windows Integrated Securit

    So far it's a no go

    I've also gone as far as to set the same user (that maps to the SQL login) as the user for the processModel and still nothing
    (do you need to reboot the box before changes in machine.config take place?

    I read a previous thread that said you need to enable Kerberos delegation for any identity to be passed acrossed machines. Is that the case? If so I really don't understand how the article that I mentioned above could work

    Thank
    - e
    eRic Guest

  2. #2

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    What is the error you are getting ? "Login Failed for NT Authority/System" ?

    --
    -------------------------------------------------------
    [url]http://www.qnal.net/inkabletype[/url]

    "eRic" <anonymousdiscussions.microsoft.com> wrote in message
    news:31B32D04-56B7-42F9-AA57-C5FF28ECFB9Fmicrosoft.com...
    > Hello,
    >
    > I am currently trying to use integrated security to access the SQL
    database for the ASP.NET application (deployed on an intranet).
    >
    > I am following this article:
    >
    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskaccessingsqlserverwithexplicitcredentials.asp[/url]
    >
    > So far I have
    > 1. Set the Web.config file to impersonate a specific domain user
    > <identity impersonate="true" userName = "myDomain\myUserName"
    password="password"/>
    > 2. Created the login in the SQL server and given it appropriate
    permissions
    > 3. Used Integrated Security = SSPI in the connection string
    > 4. IIS does not allow anonymous access on the site and is using Windows
    Integrated Security
    >
    > So far it's a no go.
    >
    > I've also gone as far as to set the same user (that maps to the SQL login)
    as the user for the processModel and still nothing.
    > (do you need to reboot the box before changes in machine.config take
    place?)
    >
    > I read a previous thread that said you need to enable Kerberos delegation
    for any identity to be passed acrossed machines. Is that the case? If so I
    really don't understand how the article that I mentioned above could work.
    >
    > Thanks
    > - e

    Kunal Guest

  3. #3

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    No message that I can see, the app just can't access the SQL Sever.
    eRic Guest

  4. #4

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    When you step through the code..the application is probably throwing a
    SQLException with some message indicating the login failure....see if you
    can post that here..


    --
    -------------------------------------------------------
    [url]http://www.qnal.net/inkabletype[/url]

    "eRic" <anonymousdiscussions.microsoft.com> wrote in message
    news:3BF46B8F-4304-412C-BBA9-774E7238D3AEmicrosoft.com...
    > No message that I can see, the app just can't access the SQL Sever.

    Kunal Guest

  5. #5

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    Ok here's one thing i've see

    Cannot initialize SSPI package.
    eRic Guest

  6. #6

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    Thanks for the article, the issue I am having, however, involves the SQL Server on a remote computer(not the same box as the web server)

    Thanks
    eRic
    eRic Guest

  7. #7

    Default Re: Using Integrated Security for Accessing SQL on Remote Server

    Have you taken a look at this:
    [url]http://support.microsoft.com/?id=811889[/url]

    --
    -------------------------------------------------------
    [url]http://www.qnal.net/inkabletype[/url]

    "eRic" <anonymousdiscussions.microsoft.com> wrote in message
    news:67D48650-74F8-4758-99B5-680B7C30F87Emicrosoft.com...
    > Ok here's one thing i've seen
    >
    > Cannot initialize SSPI package.

    Kunal Guest

Similar Threads

  1. Accessing remote server
    By Hccnet in forum MySQL
    Replies: 2
    Last Post: August 30th, 08:03 PM
  2. Replies: 3
    Last Post: August 16th, 08:45 PM
  3. Accessing a script on a remote server
    By Spidah in forum PHP Development
    Replies: 2
    Last Post: October 7th, 05:34 AM
  4. Setting up integrated security to SQL Server
    By Dave in forum ASP.NET General
    Replies: 1
    Last Post: August 11th, 03:23 PM
  5. Accessing a Crystal Report on a remote server
    By Shannon Cayze in forum ASP.NET Security
    Replies: 0
    Last Post: July 7th, 09:07 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