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?
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.