Forum Discussion

Tomas85's avatar
Tomas85
Microsoft Employee
10 years ago
Solved

Unable to Connect to SQL Server

Hi Guys, does anybody has the similar issue? I was unable to connect SQL Server ... Details: "Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre...
Need Help
Show and Tell
Tutorial Requests
  • Tomas85's avatar
    Tomas85
    10 years ago

    Hi,

    We were able to fix the issue with MSIT Support Team. You should try IP address instead of putting server name there ...

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Tomas85,

As indicated in this blog, we are able to specify a command timeout value (in minutes) when connecting to SQL Server database with the March release of Power BI Desktop.

Could you please set the value of "Command timeout in minutes" to a higher value and check if you can connect to SQL Server successfully? Also write a custom SQL statement in “SQL statement” and check if the connection is established or not.

Thanks,
Lydia Zhang

  • v-morbra's avatar
    v-morbra
    Microsoft Employee
    10 years ago

    Hi Lydia,

     

    Im getting the same errors as Tomas.

    I also tried setting high value in the "Command timeout" box or writing a custum SQL statement.

     

    Still the connection is not established..

     

    Do you know other alternative?

     

    Thanks,

    Mor