Forum Discussion
Connecting to SQL Server by IP address
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.
Hello, the problem was that I tried to connect to SQL Server 2000.
It's working in newer versions.
Thank You for Help.
8 Replies
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.
