Forum Discussion
Unable to Connect to SQL Server
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!
6 Replies
- Could be protocol encryption, see here:
https://social.technet.microsoft.com/Forums/sqlserver/en-US/7984cce4-1d1c-4fba-94c8-28d62b7c4bec/error-occurred-during-the-prelogin-handshake?forum=sqlreportingservices
and here:
http://dbaspot.com/sqlserver-server/458011-error-occurred-during-pre-login-handshake-microsoft-sql-server-error-10054-a.html
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-ssl-provider-error-0
Could also be a firewall issue.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.
- 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.
Hi,
Thank you for your response. I will be trying your suggestions and post if they solved my problem
Thanks!
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
I was able to resolve the issue by entering the port number along with the server name eg
Server: LINWDP3A,13164
