Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Power bi gateway error sql server name

In power bi desktop i m connecting with the full server name as 12.123.1.12. When I use this server name in the service in order to connect the gateway, it will return: "A network-related or instanc...
Need Help
lbendlin's avatar
lbendlin
Super User
6 years ago

Compare the connection string on the Power Query definition to the connection string reported by the gateway. They need to match exactly (this is even case sensitive now!).

 

Named pipes sounds weird.  Are you sure your SQL server has TCP enabled?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    lbendlin When I try to set up data sources in my gateway, I can only connect using server name (text). However, my Power BI desktop connects to SQL server only using the server address (numeric). How can I resolve this?