Join GitHub today
GitHub is home to over 28 million developers working together to host and review code, manage projects, and build software together.Sign up
Website for testing Kerberos delegation with SQL Server and/or Postgres
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
To deploy to an IIS Server -- I recommend using the publish as a zip file method and deploying with the command line utility created. That will deploy it and then you can modify the application pool and web application as follows: 1. Create a new app pool and configure the web app to use it 2. Run the app pool as NETWORK SERVICE with 32-bit applications enabled (v.4x framework, integrated mode) 3. On the web app itself, enable Windows Authentication and ASP.NET Impersonation. a. Under Windows Authentication: i. Extended Protection should be Off and the checkbox next to "Enable Kernel-mode authentication" should be UNCHECKED. ii. The only Enabled Provider should be "Negotiate: Kerberos". b. ASP.NET Impersonation should be set to the identity to impersonate of "Authenticated user". 4. In order for delegation to work, you will need to ensure that you have the appropriate SPN setup for your web service -- the service is HTTP and the address needs to be the same address in which you will access the KerbTest website. For instance, if my server name is WEBSERVER$ and I want to access it via webserver.company.com I need to: setspn -A HTTP/webserver.company.com webserver 5. Ensure that the WEBSERVER$ object is trusted for delegation. This can be configured via the Delegation tab on the computer object: Trust this computer for delegation to any service (Kerberos only) is the most straight-forward selection. Configuration: Once deployed, the configuration takes place within the web.config file. Specifically, all you need to change are the connection strings: 1. SQL Server connection string -- just point to the name of your sql server: <add name="SQLConnectionString" connectionString="Data Source=sql_server_fqdn;Initial Catalog=master;Integrated Security=True" providerName="System.Data.SqlClient" /> 2. Postgres -- just point to the name of the DSN you created for testing the postgres connection (or you can configure a connection string): <add name="PGConnection" connectionString="DSN=MBTASP_DSN" providerName="System.Data.Odbc"/> Testing: 1. Use Internet Explorer to test in order to easily use Kerberos. 2. Add the webserver you're using to the Trusted sites of your Internet Explorer instance in order to allow Kerberos/impersonation to work.