Cloud Pak for Data

 View Only
  • 1.  Connection to Azure SQL DB

    Posted Mon April 27, 2020 04:58 PM
    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


  • 2.  RE: Connection to Azure SQL DB

    Posted Tue April 28, 2020 05:13 AM

    Hi,

    Did you manage to connect to this database using some other tools ?

    For example can you connect to it from your local laptop using SQuirreL SQL Client ?

    Thanks



    ------------------------------
    TOMASZ HANUSIAK
    ------------------------------



  • 3.  RE: Connection to Azure SQL DB

    Posted Tue April 28, 2020 11:21 AM
    Hi Tomasz,

    I am able to connect  to this Azure SQL DB through SSMS. 

    Thanks,
    Varma Rajakakarlapudi

    ------------------------------
    Varma Rajakakarlapudi
    ------------------------------



  • 4.  RE: Connection to Azure SQL DB

    Posted Wed April 29, 2020 05:17 PM
    You may need to set the Azure SQL server firewall through the Azure portal. Your CPD platform is trying to access your database from a different IP address that may not be allowed through the firewall. By default it's shut down pretty extensively.

    Dale.

    ------------------------------
    Dale Mumper
    ------------------------------



  • 5.  RE: Connection to Azure SQL DB

    Posted Tue May 30, 2023 12:53 AM
    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
    ------------------------------