Connection String Without Including Username/Password
1 post
• Page 1 of 1
- voidinutah
-
- Posts: 20
- Joined: 25 Sep 2014, 13:59
Connection String Without Including Username/Password
Hello,
We're trying to determine a solution for connection to our database using Helicon Ape, but not including the username and password in the connection string. I was successful in completing this task on our DEV environment, however, it will not work on PROD. The reason is PROD's using Azure Managed SQL Instance, and you only have access to the SQL Server accounts or AD accounts. We thought about using AD, but the current configuration of the IIS app pool requires us to use an account associated with our storage instance.
Is there a way to use the connection string without showing the username/password? Web server uses IIS 10 and database using Azure Managed SQL Instance.
Thanks,
Marc
We're trying to determine a solution for connection to our database using Helicon Ape, but not including the username and password in the connection string. I was successful in completing this task on our DEV environment, however, it will not work on PROD. The reason is PROD's using Azure Managed SQL Instance, and you only have access to the SQL Server accounts or AD accounts. We thought about using AD, but the current configuration of the IIS app pool requires us to use an account associated with our storage instance.
Is there a way to use the connection string without showing the username/password? Web server uses IIS 10 and database using Azure Managed SQL Instance.
Thanks,
Marc
1 post
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 10 guests