Cannot find server name in finsql option.

sri.tech23
sri.tech23 Member Posts: 41
edited 2009-12-05 in NAV/Navision Classic Client
One of our client has an installation of Windows server 2008 and Dynamics nav 2009. In the finsql option when clients lookup server they are unable to locate the SQL Server installation. However if the server name is typed then the connection goes through.

Also when the firewall is put off on the server, the clients are able to connect but not when the firewall is on. ps. Have even added the dynamics sql server option in the exception list of the firewall on the server.

Anyone faced a similar prob...please help....

Comments

  • AlexWiley
    AlexWiley Member Posts: 230
    Did you find a resolution to this? We are having the same issue.
  • sri.tech23
    sri.tech23 Member Posts: 41
    Still havn't got a clue.. The client types the Server name every time he has to login....still waiting...
  • AlexWiley
    AlexWiley Member Posts: 230
    Have you tried putting the server and database name in the properties of the shortcut? It wouldn't resolve the issue when switching between servers, but day to day it might make things better.
  • stryk
    stryk Member Posts: 645
    Hi!

    Well, as far as I know the "Server Lookup" feature has been removed since NAV 5.0 SP1 ...
    If you have multiple instances of SQL Server running you have to assure the "SQL Browser" service is runnng, too.

    In the SQL Servers "Network Protocol" settings the TCP protocol is set up to use "Dynamic Ports". Maybe you could set this to a fix port number and explicitly grant access to this port - in and out - in the "Windows Firewall".

    See also http://msdn.microsoft.com/en-us/library/ms165724(SQL.90).aspx and http://support.microsoft.com/kb/287932/en-us

    Hope this helps.
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool

Categories