|
Home > Archive > MS SQL Server Connectivity > December 2006 > Why SQL Server 2000 default port is not 1433?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why SQL Server 2000 default port is not 1433?
|
|
| Michael 2006-12-13, 7:12 pm |
| I installed MS SQL Server 2000 and sp4.
The operation system is Windows 2003 server.
On server machine,
I open server network utility, and checked.
found that the default TCP port at server end is not 1433. Why?
But then I open Client Network Utility, the default port is 1433.
On my machine. (not the same one as server)
I cannot connect to that database server using SQL Query Analyzer.
What can I do now?
Thanks.
| |
| Rick Byham, MS 2006-12-13, 7:12 pm |
| The most likely reason SQL Server is not listening on port 1433 is because something else is taking the port, such as another instance of SQL Server. If you know the port is available, use the SQL Server 2000 Server Network Utiltity to specify the port.
If, like me, you have SQL Server 2005 on port 1433, and SQL Server 2000 on port 2061, then as long as the SQL Server Browser Service is started (on the SQL Server computer) then the client should still be able to connect by name.
If you can't move your SQL Server 2000 to port 1433, change the client to connent to the correct port number using the Client Network Utility.
Or use the Client Network Utility to create an alias to the correct port number.
Or connect from the client directly specifying the port such as tcp:<computer_name>, <port_number> such as tcp:accounting, 2061
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael" <michaellm@gmail.com> wrote in message news:1166029578.047335.4360@16g2000cwy.googlegroups.com...
>I installed MS SQL Server 2000 and sp4.
> The operation system is Windows 2003 server.
> On server machine,
> I open server network utility, and checked.
> found that the default TCP port at server end is not 1433. Why?
> But then I open Client Network Utility, the default port is 1433.
>
> On my machine. (not the same one as server)
> I cannot connect to that database server using SQL Query Analyzer.
> What can I do now?
> Thanks.
>
|
|
|
|
|