SQL SERVER 2000 and internet connection problem

Discussion in 'Databases' started by rbastos, Aug 24, 2006.

0
  1. #1
    Hello,

    I'm having problems with SQL SERVER 2000 and internet.

    I've a network with WINSERVER2000 and SQL SERVER 2000, and 5 Computer with WINXPPRO.

    They are connected to a switch witch is connected to a router with internet by cable.

    The problem is that every time the internet fails, I can't connect to the SQLSERVER , when internet cames again it will work normally.

    I've a similar situation with another network with but instead SQLSERVER is MSDE.

    What can I do to avoid this situation??

    Thanks in advance

    Ricardo Bastos
     
    rbastos, Aug 24, 2006 IP
  2. ThomasNederman

    ThomasNederman Peon

    Messages:
    112
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I would assume that the problem comes from DNS (you can not get name resolution to your server). If you try to use the internal IP address of your SQL server instead of DNS name, it may work better. I know in the older versions of SQL you had to go into control Panel and change to use TCP/IP client for SQL (and not named pipes)
     
    ThomasNederman, Aug 24, 2006 IP
  3. MatthewN

    MatthewN Well-Known Member

    Messages:
    859
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    195
    #3
    You could also add the name of the SQL server with it's IP in to the hosts file on each machine trying to access it.
     
    MatthewN, Aug 24, 2006 IP
  4. rbastos

    rbastos Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Hi

    Thanks for helping, and i will try that...

    It must be some problem with the router to, i have to see...

    Thanks

    Ricardo Bastos
     
    rbastos, Aug 24, 2006 IP
  5. rbastos

    rbastos Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Hi again

    But if that is happening without the internet connection whaht is the reason for??
    It should be working with the server name and won´t be necessary to put the IP i think, so there is some problem here with the the network, or with the router i don't know.

    what did you think?Any idea?

    thanks in advance

    Ricardo Bastos
     
    rbastos, Aug 25, 2006 IP
  6. yoemanspiffy

    yoemanspiffy Peon

    Messages:
    10
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Where are you pulling your IP addresses from? The Router/modem or the Server? If you are pulling them from the router/modem and the modem goes down it is a no brainer. If you are getting your IPs from the Windows server, you should be able to connect even if the router is down. Check that first.

    When you loose internet, do you get the LAN connection lost warning in the systray?

    If you do not have the router/modem plugged in can you access each other's computers via ping???

    YM
     
    yoemanspiffy, Aug 25, 2006 IP