Not able to connect to SQL Server 2008
| User, date | Message |
|---|---|
|
Written by amarch
1 year 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
1 year ago 3952 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
1 year 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. |