In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud.
In Part 1, we will cover the basics on getting prepared.
Here is what we will need.
1. Sign up for a Free Trial here - https://console.cloud.google.com/freetrial
Once logged in, head over to the Hamburger Menu to the left and choose Compute Engine --> VM Instances
This tutorial will help you on how to create a VM Instance
This following link will show you on how to create a SQL Server instance
For the purposes of this exercise you may either choose Windows combination with SQL Server 2012/2016.
After you create the instance, create a firewall rule to allow access to SQL Server on your instance. The default SQL Server port is 1433.
Testing it in Management Studio
Use the SQL Server Management Studio to configure SQL Server databases. You can download and install the SQL Server Management Studio on your local workstation, and use it to connect to the database engine on your instance remotely.
If you cannot install the Management Studio on your local workstation, connect to the instance through RDP and run the Management Studio on the instance itself. SQL Server 2012 and SQL Server 2014 both include the SQL Server Management Studio by default. For SQL Server 2016, you must download the SQL Server Management Studio from the Microsoft website and install it on the instance.
By default, SQL Server uses Windows Authentication mode to control remote access to SQL Server itself. If you need to use SQL Server Authentication mode, change the authentication mode.
Stay tuned for Part II to discuss on how to configure the Repository for setup and firewall ports needed specifically for that implementation.