Skip to main content

How to access a remote SQL Server Database (not exist in same network domain) from ASP.NET Web Application Without Credentials

How to access a remote SQL Server Database (not exist in same network domain) from ASP.NET Web Application Without Credentials. Enable the Windows Authentication | Trust Domain | Impersonation / Delegation vs. Trusted Subsystem | Using Constrained Delegation through Multiple Tiers | Application Pool Settings/ ASP.NET Security Content Page /Web.Config encrypt/ SPN Double Hop Issues for IIS Server & SQL Server

How to access a remote SQL Server database

As I mentioned in my previous post about "How to access SQL Server Database from ASP.NET Web Application Without Credentials", I just continued my research towards finding a better approach for enable the Windows Integration Authentication between Web Server (IIS) and SQL Server that exists in different network domain or remote server.

During this span of analysis, I found various new technical terms such as “Trust Domain”, “User Delegation”, ”Set SPN”, which are basically Windows Active Directory and Domain oriented changes that should be done by System Administrator. It seems an Asp.Net developer could not be done anything except specifying the domain account in Application Pool in IIS for that Application.


=========================================================
Advertisement: Choosing .NET Core Worker Services OR Windows Services?

=========================================================


Having said, the analysis has taught me that it requires lot more changes from Server and Network part and could be a tedious job also. I posted in MSDN forum and got various valid references which helped me to proceed further.

Here are the references links:

Impersonation / Delegation vs. Trusted Subsystem:
http://msdn.microsoft.com/en-us/library/ff647396.aspx#paght000008_trustedsubsystems

Using Constrained Delegation through Multiple Tiers:
http://msdn.microsoft.com/en-us/library/ms998355.aspx

About Application Pool Settings/ ASP.NET Security Content Page /Web.Config encrypt/ SPN Double Hop Issues for IIS Server & SQL Server and lot more discussed in this thread.
http://forums.iis.net/p/1183327/2003313.aspx#2003313

Connecting to SQL Server on a Workgroup PC, from a Domain PC, using Windows Authentication/ Trust Domain:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/174dc3c6-2be3-4b60-91c6-9aaab9731174/

Hope this helps to implement the technical changes according to your requirements.

Happy Learning!.
Labels:

Comments

Anonymous said…
You just grouped relevant links at one place. Thamks
Dec 8, 2011, 11:43:00 PM
Post a Comment

Popular posts from this blog

Fix: "Cannot set a credential for principal 'sa' . (Microsoft SQL Server, Error: 15535)" and “User is not associated with a trusted sql server connection" Errors

Recently, I had happen to struck with the following errors when I tried to reset the SA password through the SQL Server 2008 R2 Express. " Cannot set a credential for principal 'sa' . (Microsoft SQL Server, Error: 15535) " and then, “ User is not associated with a trusted sql server connection " From my research I have found the solution and that perfectly worked in SQL management studio. Hence, I thought of sharing my findings with others. ========================================================= Advertisement: Choosing .NET Core Worker Services OR Windows Services? ========================================================= Steps to reset the password in SQL Server 2008 R2 Express and fix for the errors: Step 1. Go to SQL Server Instance -> Properties/Security tab and change the mode to SQL Server authentication mode. Step 2. Go to Security/Logins, then open 'sa' login properties,          a. Uncheck the "Enforce passwor...
59 comments
Read more

How to Set Up SonarQube in IntelliJ: A Step-by-Step Guide

SonarQube in IntelliJ: (Looking for SonarLint then check here:  How to install and execute Sonarlint ) Setting up SonarQube in IntelliJ can significantly enhance your code quality by identifying bugs and vulnerabilities. Follow these steps to integrate SonarQube with IntelliJ: Step 1 :  Install SonarLint PluginOpen IntelliJ and navigate to Settings. Go to Plugins > Marketplace. Search for SonarLint, install it, and restart the IDE. Step 2 : Configure SonarLint Click on SonarLint at the bottom left of IntelliJ. Select Configure SonarLint. In the popup, check the box for Bind project to SonarQube/SonarCloud and click on Configure the connection. Step 3 :  Set Up the ConnectionIn the new popup, click the + icon to add a new connection. If the + icon is not visible, go to File > Settings > New UI and disable it. Apply changes and restart the IDE. Name your connection and select SonarQube. Enter the SonarQube URL (e.g., https://sonar.prod.company.com) and click Next....
Post a Comment
Read more

How to implement JUnit 5 in Your Maven or Gradle Project: A Step-by-Step Guide for Java Testing

Unit Testing JUnit Learn how to integrate JUnit 5 in your Maven or Gradle project for efficient Java testing. This guide covers adding dependencies, creating test classes, writing test methods, and running tests in IntelliJ IDEA and Visual Studio Code to ensure robust and error-free code. Step 1: Create a Simple Java Application Create a simple Java application, for example, “Copilot Demo,” and select Maven or Gradle as the build system through IntelliJ IDEA or Visual Studio Code. Step 2: Add JUnit Dependency For Maven: Add the following dependency to your pom.xml file inside the <dependencies> tag: XML <dependency> <groupId>org.junit.jupiter</groupId> <artifactId>junit-jupiter-engine</artifactId> <version>5.11.2</version> <scope>test</scope> </dependency> For Gradle: Add the following dependencies to your build.gradle file: dependencies { testImplementation 'org.junit.jupiter:junit-jupiter-engine:5.11.2' } Step ...
Post a Comment
Read more