Forum Discussion

felyoubi's avatar
felyoubi
Kudo Collector
10 years ago
Solved

Failed to connect to SQL Server

I am getting this error: Details: "Microsoft SQL: The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include t...
Need Help
  • felyoubi's avatar
    felyoubi
    10 years ago

    Special announcement!

    Those who are running their SQL Server Service on a custom port, this is what you need to do to be able to use Power BI:

    Use the SQL Instance Name comma Port as follow: MySQLInstance,2422

    That did it for me.

     

    Regards,

    Fahd

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

felyoubi In powerbi desktop, when you connect to sql server database specity your port. So as below.

 

 

  • felyoubi's avatar
    felyoubi
    Kudo Collector
    10 years ago

    While adding the port number to the SQL instance name fixed the issue (Thank you for that), it didn't help me set the data source in PBI Service (Cloud). I don't think it support Port numbers.

    Any clue on how to successfuly set up a gateway Data Source for auto refresh?

     

    Thanks,

    Fahd

    • felyoubi's avatar
      felyoubi
      Kudo Collector
      10 years ago

      Special announcement!

      Those who are running their SQL Server Service on a custom port, this is what you need to do to be able to use Power BI:

      Use the SQL Instance Name comma Port as follow: MySQLInstance,2422

      That did it for me.

       

      Regards,

      Fahd

      • cafeolai's avatar
        cafeolai
        Frequent Visitor
        8 years ago

        Hello all ,

         

        I succesfully connect to SQL on desktop using MySQLInstance,2422 format , but whan I publish my pbix, I always get :

        'You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway.'

        My Gateway name is MySQLInstance,2422 , I tried with MySQLInstance and MySQLInstance:2422 , nothing works .

        I also mention that my connection in Power Bi is succesful and  my Gateway shows as 'Connected' ...

         

        Thanks for your help