Reply
Regular Visitor
Posts: 25
Registered: ‎04-12-2016
Accepted Solution

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 the following: the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)"

 

SQL Server is setup on a custom port and I am able to access from my local using SSMS but not through PowerBI Desktop or Enterprise Gateway. Any idea?

 

Thanks


Accepted Solutions
Regular Visitor
Posts: 25
Registered: ‎04-12-2016

Re: Failed to connect to SQL Server

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

View solution in original post


All Replies
Highlighted
Super Contributor
Posts: 1,662
Registered: ‎12-15-2015

Re: Failed to connect to SQL Server

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

 

 

Capture.PNG

Regular Visitor
Posts: 25
Registered: ‎04-12-2016

Re: Failed to connect to SQL Server

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

Regular Visitor
Posts: 25
Registered: ‎04-12-2016

Re: Failed to connect to SQL Server

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