cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Vasco
New Member

SQL Server Named Pipes Provider, error: 40

Hi Power BI Experts,

 

I have been using successfully Power BI Desktop connected to an Access Web App located in MS Cloud service.

 

Everything was running amazingly smoothly until now. The problem is when I try to refresh the data, I receive the following error message ( the text may not be 100% accurate as I am translating it from portuguese):

"Microsoft SQL: There was an error related with the network or specific to the instance when establishing the connection to Server. The server was not found or was not accessible. Verify the name of the instance is correct and the SQL Server is configured to allow remote connections.(provider: Named Pipes Provider, error: 40 - It was not possible to open a connection to the SQL Server)"

 

I have recently installed Windows 10 in my computer and this was one this difficulty started.
Do I need to install SQL Server on top of Windows 10? If yes, what version?

 

I have double-check the server name and the database name. I dont see any place to put the username and password.
Is there any other configuration I need to do?

 

Any help to overcome this difficulty will be very appreciated.

Thanks in advance,

Vasco from Sintra (Portugal)

1 ACCEPTED SOLUTION

Go to File -> Options & Settings -> Data Source settings. A window with all connections you have will appear. Select the SQL connection and at the bottom of the window click edit..Update the credentials.

 

Hope this is your problem

 

PowerBIDesktop.png

Konstantinos Ioannou

View solution in original post

4 REPLIES 4

No you don't need to install SQL Server. It seems that something has changed and you can no longer connect to the DB (but I guess you know that). It may not be related to Power BI at all - you need to test it. Are you able (or even know how) to connect to the DB not using Power BI?  I would try that first and see if you can connect. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

MAllington, thank you for your help in delimiting the problem.

I have successfuly connect to the same DB via an Excel Sheet. Power BI Service (Online) is refreshing smoothly also.
The problem is restricted to Power BI Desktop.
Any further help to solve this issue will be really appreciated.
Thanks in advance,

Vasco 

Go to File -> Options & Settings -> Data Source settings. A window with all connections you have will appear. Select the SQL connection and at the bottom of the window click edit..Update the credentials.

 

Hope this is your problem

 

PowerBIDesktop.png

Konstantinos Ioannou

View solution in original post

Thank you Konstantinos.

After some struggle with the credentials (I was confusing database credentials with Windows credentials) all is working fine now 🙂

What a relief...

Kind regards from Sintra (Portugal)

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.