cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
felyoubi Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
felyoubi Regular Visitor
Regular Visitor

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

6 REPLIES 6
ankitpatira Super Contributor
Super Contributor

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

felyoubi Regular Visitor
Regular Visitor

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

felyoubi Regular Visitor
Regular Visitor

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

cafeolai Frequent Visitor
Frequent Visitor

Re: Failed to connect to SQL Server

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  

 

cafeolai Frequent Visitor
Frequent Visitor

Re: Failed to connect to SQL Server

ok , I found what my problem was , I misunderstood when I red the connection name must be the same in the gateway and in Power Bi Desktop.  What must match are the NAME OF THE SERVER and the name of the connection in Desktop.  So I matched ( case sensitive ) the name of the server and my Destop connection and TADA !!  works fine .

Highlighted
kristianr New Member
New Member

Re: Failed to connect to SQL Server

I have used hours on this problem, but luckily I found the solution that worked for me here:

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Schedule-Refresh-doesn-t-work-because-o...

 

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 54 members 864 guests
Please welcome our newest community members: