Forum Discussion

MSchultz93's avatar
MSchultz93
Icon for Helper I rankHelper I
2 years ago

Connect to a SQL Server with Power BI Services

Hello, I have problem connecting to a SQL Server that is On Prem using Power BI Services.    My Power BI Desktop works properly, I can connect to the SQL-Server there. I have a Standard Data Gatewa...
Need Help
MSchultz93's avatar
MSchultz93
Icon for Helper I rankHelper I
2 years ago

Thank you, however, it does not work I get an error when I do that. See below

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)"

 

sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
2 years ago

It sounds to me like you (your IT department) have to enable internal communication between your SQL Server and your Gateway server.
Can you check this in your company?

Regards