Open Closed

Connect to sql db in Azure with domain service account #8225


User avatar
0
Anjaneyulu created
  • ABP Framework version: v6.0.0
  • UI Type: MVC
  • Database System: EF Core (SQL Server)
  • Tiered (for MVC) or Auth Server Separated (for Angular): no
  • Exception message and full stack trace:
  • Steps to reproduce the issue: 1. SQL server is in azure.
  • Till now my abp application is connecting with local username and password i.e., sa & xxxxx
  • But because of a security concern in the production, we are asked to connect to the azure sql db with domain service account (eg: abc@abp.com) and password.
  • What are the changes that i need to do to my connection string in my abp application.
  • I have already created a user in azure and given necessary permission in the db as well. But im not able to connect to the db with token invalid error.

1 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    with token invalid error.

    Can you share the full error?

    ABP will use EF Core to connect your database

    Maybe you can check this: https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-entity-framework-core-quickstart?view=azuresql&tabs=dotnet-cli%2Cservice-connector%2Cportal

Made with ❤️ on ABP v9.1.0-preview. Updated on November 01, 2024, 05:35