Overview
This KB Article contains a guide on how to do a basic setup of the ER/Studio Repository in an Azure SQL database.
How Install and Set Up a ER Studio Repository on a Azure SQL Database
- Azure Portal Login and Resource Creation: Start by logging into the Azure portal and navigating to the resource creation section to select SQL Database.
- Subscription and Resource Group Selection: Choose a subscription and Resource Group, then name the new database instance and create a new SQL Server.Be sure to specify a region.
- Authentication and Configuration: Select SQL authentication and configure it with your requirements.
- Networking Configuration: Choose the networking options required. We recommend a private endpoint for a more robust security.
- Review and Creation: Review the configuration and start the creation process.
- Deployment Completion and Resource Access: After the deployment is complete, navigate to the created resource to view connection strings.
- Login and Verification: Log in and verify that the database is created successfully.
- Once the Database is created you can run the Team Server installer and go through the installation process pointing to this new database created.
More information available at:
Installing ER Studio Repository on Azure SQL Database