Post reply

MSSQL 2K Std Edition - Multiple network interfaces

  • December 29, 2006 at 2:17 am

    #175311

    Recently, we setup another SQL Server 2000 instance in our development environment. The server have two network interfaces, on for back-end/application access, with an IP address like 10.10.x.x, and a second one for backup and monitoring propouses, IP address like 10.20.x.x. The fact is network connections using TCP/IP are available just in the first one, beyond localhost connections.

    "netstat -an | findstr LIST | findstr 1433" displays the following results:

      TCP    127.0.0.1:1433      0.0.0.0:0       LISTENING

      TCP    10.10.x.x:1433      0.0.0.0:0       LISTENING

    I would really appreciate it if someone could explain to me how you make MSSQL available in all network interfaces, if it´s really possible in Standard Edition.

    Thanks in advance,

    Fabio Neukirchen

  • December 29, 2006 at 7:54 am

    #680498

    can you access the server via both IP's to access files or other simple things?

  • December 29, 2006 at 9:22 am

    #680531

    Hi,

    Yes, all other services, like icmp, echo, smb (network share), ftp, etc are available. But, in my point of view, doesn´t matter if all this services (including MSSQL) are reachable through the network. The second interface, 10.20.x.x should listen on port 1433, shouldn´t?

    Thanks,

    Fabio Neukirchen

     

  • December 29, 2006 at 9:53 am

    #680541

    IS SQL Server not listening on this port, meaning you can't connect? Or does it now show in netstat?

    If you haven't restarted SQL Server, it might not have picked up the new address.

  • December 29, 2006 at 10:23 am

    #680546

    SQL Server service was restarted several times, after some changes, off course. It´s doesn´t listen yet, on the second interface, neither appears in netstat. See, everything works fine for the first NIC.

    Fabio Neukirchen

  • December 29, 2006 at 11:18 am

    #680559

    Has the server been rebooted?

    I've used multiple NICs and IPs several times and it's worked fine. I don't think I've changed the server network utility, but can't remember.

  • December 29, 2006 at 2:34 pm

    #680603

    The server was rebooted several times too.

    BTW, problem solved. I´ve just reinstalled and everything works fine now (even I´ve choosed the simplest way do do it, becouse we´re in development environment). Thanks for all your support.

    Fabio Neukirchen

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply