SQL Server访问问题 [英] SQL Server Access Problem

问题描述

我正在研究.NETCore项目(该项目具有登录/注册页面，如果您正确登录，则打开主页...您可以想象一个基本的网页)
 并且我尝试在本地运行项目.当项目运行时，打开登录页面，然后正确输入帐户信息，然后单击登录"按钮.主页正在加载 几分钟，但页面已重定向到再次登录页面.
在本地调试时，我认为B2C租户位置是美国，而SQL Server位置是西欧，因此发生了防火墙问题.我创建了一个新的B2C租户，该租户位于西欧，并在本地正确运行项目.

在将Web应用程序路径更改为本地Web应用程序路径后，我将同一项目部署为Azure.打开登录页面，然后输入帐户信息，正在加载主页，但再次打开了登录页面.

I'm study on .NETCore project(the project have sign in/sign up page and if you sign in correctly, home page open... You can imagine a basic web page)
 and I tried to run project in local. When the project is runnig, sign-in page is open, and then I enter account information correctly and click sign in button. Home page is loading  for a few minute but page is redirected to sign in page again.
When I debuged in local, I reliazed that B2C tenant location is United State and SQL server location is West Europe, so firewall problem is occurs. I created a new B2C tenant which locate is West Europe, and run project correctly in local.

I deployed same project to azure after change web app path to local web app path. Sign-in page is opened and then I entered account information, home page is loading but the sign-in page opened again.

如何解决此问题?

推荐答案

Czlnkr，您好

Hi Czlnkr,

您是否要使用应用程序令牌认证或AD原则名称和密码?如果我阅读并理解您的问题，则希望实施AD原则名称+密码.请看一看 使用Azure AD身份进行连接.请确保您已阅读 其他注意事项.

Do you desire to use Application token authentication or AD principle name and password? If I read and understand your question, you wish to implement AD Principle Name + Password. Please take a look at Connecting using Azure AD Identities. Please ensure you read through the additional considerations. 

该文档涵盖了配置/设置过程:

This document covers the configuration/set-up process: Configure and manage Azure Active Directory authentication with SQL

此致

迈克

这篇关于SQL Server访问问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！