Just after install I check that the TCP/IP protocol is enabled under the
server properties and then I try to Telnet into port 1433. On this one
particular box I get back the following:
C:\>telnet localhost 1433
Connecting to localhost...Could not open connection to the host, on port
1433: Connect failed.
For comparison I tested telnet on a couple other machines and I get back a
blank window ready for my commands, as I'd expect.
I've checked the firewall settings and other IP Filtering settings to see if
any of those were blocking traffic to 1433... nothing. I've triple checked
the SQL Server settings for any "problems" and nothing jumps out at me.Have you configured the server to listen to port 1433? Is it set to Dynamic?|||Try installing SQLServer 2000 SP3 or 3a if you have not already.|||
add to your conecction string: namedPipe=true
i hope this solve your problem
No comments:
Post a Comment