[Urgent] SQL server not bind to IP address

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

[Urgent] SQL server not bind to IP address

Author

Topic

sphericalx
Starting Member

10 Posts

Posted - 2008-12-02 : 20:55:35

i'm currently running my sql server 2000 in windows server 2003 and i'm unable to bind my sql server 2000 to my IP.

my sql server 2000 is currently at SQL server 2000 service pack 4.
i had enable named pipe and TCP/IP in Server Network Utility. port for TCP/IP is set to 1433.
enabled RPC in Enterprise manager.
my computer is not under firewall

i tried to do a netstat and this is what i get.

TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING 1508

did a crosscheck from task manasger

Image Name PID
sqlservr.exe 1508

had been stuck with this for many hours and still unable to find a solution on how to get it to work.

hope someone with the knowledge of this can help. thanks a million

sphericalx
Starting Member

10 Posts

Posted - 2008-12-03 : 02:15:00

for my understanding of the issue till now is that the reason its being set to 0.0.0.0:1433 is because its means that it is listening on all IP addresses associated with the machine.

however how can i make it such that it'll only listening on the IP address of mine?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources