Unable to Connect to SQL Server

[giannicerdeno]

Hi,

I am new to Power BI Desktop, and I've been wanting to connect to our company's SQL Server, but whenever I try to, this message shows up:

In case the image doesn't show, the error says: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Named Pipes Provider, error: 0 - The pipe has been ended.)"

I have searched the net for a solution to the problem, and have tried connecting with the encryption off, but a different error pops up, saying "Microsoft SQL: Invalid object name 'sys.databases'."

Thank you for your help!

[vhistrionics]

I was able to resolve the issue by entering the port number along with the server name eg

Server: LINWDP3A,13164

[vhistrionics]

I was getting the same error.. but was able to resolve it.....you will need to add the port number along with the server name example,

Server: LINWDP3A,13164

[Greg_Deckler]

Could be protocol encryption, see here:
https://social.technet.microsoft.com/Forums/sqlserver/en-US/7984cce4-1d1c-4fba-94c8-28d62b7c4bec/err...

and here:
http://dbaspot.com/sqlserver-server/458011-error-occurred-during-pre-login-handshake-microsoft-sql-s...

Could be something else like a third party security product, see here:
http://stackoverflow.com/questions/15393398/net-4-5-forms-app-connecting-to-sql-server-2012-fails-ss...

Could also be a firewall issue.

[giannicerdeno]

Hello again,

It seems I just needed to fill in even the optional requirements for connecting to the SQL Server.

After specifying a database and filling in an SQL query for when connecting to the server, it pulled the data from the query.

As I was under the impression I can access the whole server if I connect to it, I did not try this beforehand.

Again, thank you. I will try to learn as much as possible regarding Power BI.

[Greg_Deckler]

Hmm, you should be able to browse databases and tables if you do not put in a query but perhaps you do not have that level of access within SQL? I'll have to give this a try again to verify.

[giannicerdeno]

Hi,

Thank you for your response. I will be trying your suggestions and post if they solved my problem

Thanks!