Follow these steps to establish a secure connection to T-SQL Azure using Azure SQL Database MFA:
- Launch Visual Expert
- Open Visual Expert and click [New] in the ribbon menu to start the "Create Project" wizard.
- In the pop-up, select [Transact-SQL] for Azure connection setup.
- Choose SQL Database
- On the SQL DB connection page, click [SQL Database] to proceed with the SQL Database authentication with Azure MFA.
- On the SQL DB connection page, click [SQL Database] to proceed with the SQL Database authentication with Azure MFA.
- Enable Azure MFA
- Select the [Azure MFA] radio button.
- Provide the required details for Microsoft Entra and SQL authentication.
- Provide Server Information
- Enter the server name and your user ID (email address). This is critical for Azure Active Directory T-SQL integration.
- Enter the server name and your user ID (email address). This is critical for Azure Active Directory T-SQL integration.
- Test the Connection
- Click [Test Connection] to verify the connection.
- Once the connection is successful, select a database name from the dropdown menu to analyze.
- Finalize the Setup
- Click [Next] and follow the wizard to start analyzing the source code for the selected Azure SQL Database MFA project.
More from Managing VE Projects
- Analyze Several PB Applications
- Analyze PB + Oracle code
- Analyze PB + SQL Server code
- Analyze Several SQL Server DBs