Forum Discussion
Connecting to SQL Server by IP address
Hello, the problem was that I tried to connect to SQL Server 2000.
It's working in newer versions.
Thank You for Help.
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-the-server/89
Hi, thank You for answear but I don't udnerstand - is this picture correct:?
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.
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?