Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-03-20 : 09:14:39
|
| William writes "I'm working on SQL Server 2k in Windows 2003 with sp3.Just after installation I checked that the TCP/IP protocol is enabled under the server properties and then I tried 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. Also I can't register this server. It gives message as "SQL server doesn't exist or access denied..." I can't regiser sql server on same computer if I can't give name as (Local).Any ideas? Thanks " |
|
|
Jim77
Constraint Violating Yak Guru
440 Posts |
Posted - 2006-03-21 : 09:13:11
|
| I had this problem when I was trying to register a named instance thinking it was the default and i did not give the servername/instancename parameter try that !!!as for the port 1433 this is just the default and it is possible that this port has been changed ! look in the Server network utility to see if the default has been changed. |
 |
|
|
|
|
|
SQL can't regiser withgout (Local) name on same computer