Check the Amazon RDS for SQL Server address and account authentication details have been entered correctly
Use the Amazon RDS for SQL Server connection details dialog in the Spotlight Cloud Diagnostic Server Application to run these checks.
Amazon RDS for SQL Server address
Check the address is a valid fully qualified server name. If aliases are used then an incorrect alias on the Spotlight Cloud Diagnostic Server host can cause connections to fail. Check the alias name of the instance.
Authentication
The connection will fail if the account permissions are insufficient to allow Spotlight Cloud to collect the data it needs.
When filling in the User and Password fields, ensure the user has sufficient account permissions to retrieve performance data from the Amazon RDS for SQL Server instance.
Typically the account will be a Master login that was created via the RDS instance creation. Alternatively an account can be configured with the necessary privileges as documented by grant account permissions.
Connection to the Amazon RDS for SQL Server
Ensure connectivity from the Spotlight Cloud Diagnostic Server to the Amazon RDS for SQL Server.
SQL Server firewall connectivity
Ensure port 1433 is open for outbound connections on all firewalls between the Spotlight Cloud Diagnostic Server host and the internet. Test the connectivity between the Diagnostic Server and the Amazon RDS for SQL Server using SQL Server management Studio (SSMS), a UDL file, ping, or telnet.
Try an external tool such as Telnet to test the connection across the network. Install Telnet using Control Panel | Programs and Features. Open a Command Prompt window and enter:
Telnet <server name> <port number>