Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 586
  • Last Modified:

SQL server listening on 127.0.0.1:1433 only, and not on all the IP addresses on the server

I have this server which has two public IP addresses. Its a windows 2000 server with SQL 2000 on it We changed the NIC on it yesterday since it was having problems. Now, the clients cannot connect to  the server. I tried doing a telnet to the IP addresss on the server itself , but it wont connect. When i checked the error log, I saw this - SQL server listening on 127.0.0.1:1433. The error log of yesterday had the other two IP addresses as well. How do i get the server to listen on those two as well. PLease help.

0
jvp1999
Asked:
jvp1999
  • 3
2 Solutions
 
arbertCommented:
This should be automatic as long as the NICs are configured properly in Windows.  Are the cards using DHCP or Fixed IPs?

0
 
danblakeCommented:
Please do not tell me this is a cluster...
http://support.microsoft.com/default.aspx?kbid=244980

Have you configured the server network utility with the new ip addresses ? and then restarted the server (if not a cluster... ?)

Have you changed it to a NIC address on the same subnet as your clients and are the settings correct / gateway etc...?

What happens if you run : (in a command shell) - ipconfig -all
do all your network interfaces register your new ip addressses ?
0
 
arbertCommented:
I would hope a cluster wouldn't have two EXTERNAL addresses :)
0
 
jvp1999Author Commented:
Thanks to all who responded. No, this is not a cluster. Its a stand alone server. I restarted the SQL server services and the binkds are fine now. I notice this error now , Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b. Not sure what this is . Can someone explain ?
0
 
arbertCommented:
This is normal if you don't have Distributed Transaction Coordinator running...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now