Hello Varma Rajakakarlapudi,
Based on the error message you shared, it seems that there might be an issue with the connection details you provided when trying to connect to the Azure SQL Database. Here are a few things you can check to resolve the error:
Double-check the connection details: Make sure the hostname, database name, username, and password you entered are correct. It's important to ensure that there are no typos or missing characters.
Verify the port number: The default port for Azure SQL Database is indeed 1433, so it seems you've provided the correct port. However, ensure that there are no network restrictions or firewalls blocking outbound connections on this port.
Check network connectivity: Ensure that your network allows outbound connections to the Azure SQL Database. Sometimes, corporate or firewall settings may block certain connections.
Validate Azure SQL Database settings: Make sure the Azure SQL Database is running and accessible. Double-check the database server name, as it should include the fully qualified domain name.
Consider SSL encryption: If your Azure SQL Database requires SSL encryption, make sure you have enabled the "Encrypt connection" option in your connection settings.
If you've verified these details and are still facing issues, please provide additional information such as the specific error code or any additional error messages you encounter. This information can help in troubleshooting the problem further.
Remember, it's always a good idea to consult with an Azure architect certified or refer to the Azure documentation for detailed guidance on connecting to Azure SQL Database.
I hope this will help you.
------------------------------
Eden Wheeler
------------------------------
Original Message:
Sent: Mon April 27, 2020 04:12 PM
From: Varma Rajakakarlapudi
Subject: Connection to Azure SQL DB
Hello All,
I am a beginner on this Cloud Pak for Data . I created a 7 day free trial account . As part of learning, I tried to create a connection with Azure SQL Database. I have given the correct Host name, Database name, DB Username, Password. I gave port number as 1433. When I clicked on test connection, it displayed a error message as " Invalid Connection Details" . Can anyone please help me how to resolve this error.
I am attaching the screenshot of the error message.
Thanks,
Varma Rajakakarlapudi.
------------------------------
Varma Rajakakarlapudi
------------------------------
#CloudPakforDataGroup