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 |
|
tommythecat
Starting Member
4 Posts |
 Posted - 2008-02-19 : 14:29:56
|
| Hi,I have SQL Server 2000 installed on my Windows XP (SP2) machine. I have the port set to 1433 (under Server Network Utility-->General-->TCP/IP). Here's the problem: when i runnetstat -anbnothing is running on port 1433. What i DO have is this: TCP 0.0.0.0:1036 0.0.0.0:0 LISTENING [sqlservr.exe]Before I rebooted my computer it was running on port 1032. Anyone have any idea why this is happening? Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:33:17
|
| Did you restart sql? You can check sql server log to find out which port sql is listening on. |
 |
|
|
tommythecat
Starting Member
4 Posts |
Posted - 2008-02-20 : 10:00:00
|
| where is this log located? <edit> found it, although it doesn't say anything about port numbers. any ideas? |
|
|
|
tommythecat
Starting Member
4 Posts |
Posted - 2008-02-20 : 10:57:04
|
| in the log it says "SQL server listening on Shared Memory, Named Pipes." and "SQL Server is ready for client connections". It doesn't say anything about TCP/IP although I have it enabled in the Server Network Utility. could this be the problem, and if so does anyone have a solution? |
|
|
|
tommythecat
Starting Member
4 Posts |
Posted - 2008-02-20 : 14:28:20
|
| fixed! Service Pack 3a, which is over 4 years old...let that be a lesson, always upgrade your software. |
|
|
|
ccyre
Starting Member
15 Posts |
Posted - 2008-02-20 : 14:33:50
|
| could 3a be better than sp4? I'm using sp4 and have your issue. Plus we have one with sp4 and it works. So either way I should be working too. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 16:09:47
|
| >> could 3a be better than sp4?No. Just ensure tcp/ip is enabled. |
|
|
|
|
|
|
SQL Server 2000 Port question