Connecting to SQL Server by IP address

[papke]

Hello, when I'm using management studio I can access db by ip address:

But when I'm trying to do the same in Power BI:

I'm getting error:

 Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - Określona nazwa sieciowa już jest niedostępna.)"

Is it possible to connect to other SQL Server by IP address?

Curently it works only on my local db, but I need to connect to another db and I can't do this.

[tringuyenminh92]

Hi @papke,

Could you please try with instance name by select @@servername in database and use it in connection form?

I think this is issue from your sql server setting. please check topic: http://escapekeys.com/microsoft-sql-server-error-64-a-connection-was-successfully-established-with-t...

[papke]

Hi, thank You for answear but I don't udnerstand - is this picture correct:?

[tringuyenminh92]

Hi @papke,

No, I meant you try with sql server instance name instead of ip address, cause there are something wrong with setting of ip address.

[papke]

Hi, connection by sql server instance name works, but only when it is on my computer - it doesn't work when I want to connect to other SQL SERVER - I had the same problem with management studio , but after settings in sql server and change name to ip I can connect to every server in my LAN.

Now I want to connect to every server in my LAN in power BI but I can't do this because it doesn't work with named instance or IP address. I can only connect to SQL server on my computer.

How I can connect to SQL Server which is not on my computer?

[papke]

I will try to explain this clearly, I have a common SQL Server and to access it from another computer I've configured TCP/IP in SQL Server Configuration Manager on it and now I can access this database from any computer but I must type address IP of this database as server name, and I need the same in Power BI because now I can only use it locally.

Please help because tool is fantastic but I must connect It to database not in my local computer.

[v-ljerr-msft]

Hi @papke,

I just verified that I can connect successfully to one of my remote SQL Server by IP address with my Power BI Desktop. I'm using the latest version of Power BI Desktop(2.42.4611.701 64-bit (January 2017)). And I'm using (IP,Port) for the Server field in Power BI Desktop.

Could you go to download the latest version of Power BI Desktop, then run it as Administrator, and type (IP,Port) for the Server field to see if it works?

If it still does't work, I would suggest you also go a SQL Server Forum for better assistance, because the issue seems more related to SQL Server configuration issue.

Regards

[papke · Accepted solution]

Hello, the problem was that I tried to connect to SQL Server 2000.

It's working in newer versions.

Thank You for Help.

[v-ljerr-msft]

Hi @papke,

Great to hear the problem got resolved! Could you accept your last reply as solution to help others who may have similar issue easily find the answer and close this thread?

Regards