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

Not able to connect to SQL Server 2008

User, date Message
Written by amarch
2 years ago
Category: Creating a connection
2 posts since Fri, 17 Feb 12
Although I've tried several different combinations, I have not been able to establish a connection to a SQL server on my laptop. I've had similar problems with other softwares mostly related to the fact that my server runs as a named instance (namely: MACHINENAME\SQLSERVER). May this be the case? I am trying to connect through the TCP/IP channel and yes, SQL server is configured for accepting any form of TCP/IP connection (I have successfully connected from ADONET, JDBC, etc.) Any suggestions? Many thanks!
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
I have a local installed MS SQL 2008 and Heidi connects fine to it via named pipe (not TCP!), using hostname "ANSGAR-PC\SQLEXPRESS" and Windows authentication.
Written by amarch
2 years ago
2 posts since Fri, 17 Feb 12
Thanks anse. Tried it and it worked. I hadn't tried it before as I had inactivated named pipes (on the grounds of reducing, as much as possible, services running in my computer). But if this turns out to be the only manner of communication I guess I've no other way out.
 

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