distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sql Error (17) Server does not exist or access denied

User, date Message
Written by LyndonOHRC
2 years ago
Category: Creating a connection
2 posts since Thu, 15 Mar 12
I get this error with every session configuration I attempt.

HeidiSQL is installed on my Windows 7 work station (I'm logged in as a network administrator during these attempts).

MS SQL Server 2008 R2 is Installed on our Windows Server 2008 R2 machine.

I have an ODBC connection to this SQL server that I'm using Create, Drop, Select, Insert, and Update queries on with no problem.

I the Heidi session configuration, I've tried named pipe and IP and every authentication method using the server administrator password to no avail.

Any suggestions much appreciated.
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
"Server does not exist" sounds a lot like you entered a wrong hostname.
Written by LyndonOHRC
2 years ago
2 posts since Thu, 15 Mar 12
I got it! I had port 1433 blocked.
 

Please login to leave a reply, or register at first.