title: Cannot connect to SQL Server using Microsoft Excel Power Query
body: <p>I'm having trouble connecting to a SQL Server 2008 R2 data source using Excel 2013 Power Query.</p>
  
  <p>I have created a new Power Query query, and created a new SQL Server datasource.  I have specified the server name and database, but have not specified any specific query.</p>
  
  <p>I am using SQL Server authentication to login to the database, and the connection is encrypted.</p>
  
  <p>When I attempt to set up the connection in Excel Power Query, I get an error message: DataSource.Error:</p>
  
  <p>No further error details are supplied.</p>
  
  <p>I have checked that the SQL Server allows remote connections, and I have tested the SQL Login by using the sqlcmd utility to connect to the database server and database and run a basic SELECT query.</p>
  
  <p>If anyone can shed any light on what I'm doing wrong, I'd be very grateful.</p>