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 Implement Lombok in IntelliJ for Java Projects: A Step-by-Step Guide

Lombok in IntelliJ for Java Projects Implementing Lombok in your Java project can streamline your code by reducing boilerplate. Follow these steps to set up Lombok in IntelliJ: Step 1 :  Ensure Java SDK Version. Ensure that your project is using Java 8 or higher.  You can check and set the Java SDK version in pom.xml: XML <properties> <maven.compiler.source>1.8</maven.compiler.source> <maven.compiler.target>1.8</maven.compiler.target> </properties> Step 2 : Add Lombok Dependency to pom.xmlOpen the pom.xml file in your project. Add the following Lombok dependency inside the <dependencies> section: XML <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.24</version> <scope>provided</scope> </dependency> Step 3 : Download Lombok Plugin for IntelliJ IDEAGo to File > Settings (or press Ctrl+Alt+S). Navigate to Plugins. Search for Lombo...
Post a Comment
Read more

How to create a GenAI Talking Avatar ChatBot using Streamlit and Anthropic Claude LLM Model

GenAI Talking Avatar ChatBot   using Streamlit and Anthropic Claude LLM Model GenAI-Talking-Avatar-Chatbot is a web application that allows users to interact with an AI-powered talking chatbot with a static avatar. The chatbot uses AWS Bedrock for generating responses and Google Text-to-Speech (gTTS) for voice output. The backend is built with FastAPI, and the frontend uses Streamlit for the user interface. Features API Backend (api.py) Provides an API endpoint to handle chat requests. Uses AWS Bedrock to generate AI responses in a specified JSON format. Ensures the responses include the message, avatar expression, and voice tone. Includes a health check endpoint to verify the API status. Chat UI (chat_frontend.py) Chat Interface: Provides a chat interface where users can input their queries and receive responses from the AI assistant. Avatar Display: Displays an avatar that changes expressions based on the AI assistant's responses and actions (e.g., thinking, speaking). AI Respons...
Post a Comment
Read more