Why SQL server cannot found until an hour later?

spycraft
spycraft Member Posts: 66
edited 2005-05-26 in Navision Attain
Hi all,

I have the following scenario to share and I appreciate any feedback or advice:

My client is on Navision 3.6 SQL server option (SQL2000). The complaint is that the SQL server cannot be found by Navision client after server reboot. He has to keep trying for about an hour before he is able to find the SQL server.

What could have caused the SQL server not to be found until a later time?

Regards,
Spy

Comments

  • jesam
    jesam Member Posts: 100
    Has the server got a fixed IP adress ?
    Can the server be pinged ?
    Are the clients terminated before the server is rebooted ?
    Can you map the administrative share c$ (for instance, but any other shared folder will do) on that machine ?
    The problem you describe can be situated anywhere in the OSI network layering model, so without any more information it is impossible to find an answer.
  • spycraft
    spycraft Member Posts: 66
    Hi jesam,

    My feedback below:

    Has the server got a fixed IP adress ?
    [Spy] yes

    Can the server be pinged ?
    [Spy] Have to check with client and feedback.

    Are the clients terminated before the server is rebooted ?
    [Spy] Have to check with client and feedback.

    Can you map the administrative share c$ (for instance, but any other shared folder will do) on that machine ?
    [Spy] Have to check with client and feedback.
  • spycraft
    spycraft Member Posts: 66
    Hi jesam

    Has the server got a fixed IP adress ?
    [Feedback from Client] yes , it does

    Can the server be pinged ?
    [Feedback from Client] yes, it does

    Are the clients terminated before the server is rebooted ?
    [Feedback from Client] Yes it does

    Can you map the administrative share c$ (for instance, but any other shared folder will do) on that machine ?
    [Feedback from Client] There are no administrative share or other shared folders in that server.

    Regards,
    Spy
  • jesam
    jesam Member Posts: 100
    The question about the shares was to see if the server can be accessed through regular windows security. It might be a good idea to create such a share, even it it was only on the temp folder, so you can check if that works.

    It might also be a good idea to check if the SQL Server can be found by for instance the Enterprise Manager during that hour.

Categories