NAS error ECONNREFUSED

couberpu
couberpu Member Posts: 317
edited 2006-08-21 in NAV/Navision Classic Client
Help!
I am running Navision 3.70b with SQL 2000(SP4) on a windows 2000 server(SP4) server. The application runs fine and client has no problem communicate to the server.
I just installed the Navision Application Server, came with the 3.70b disk, to the server and used the following code to install the service.

cd c:\Program Files\Microsoft Business Solutions-Navision\Application Server\
NET STOP APPSERVER-SQL
nas appservername=APPSERVER-SQL,servername=APPSERVER,database=LTG,company=Lighting,nettype=TCP,startupparameter=DAILY,installasservice
NET START APPSERVER-SQL

The script came back with a successful installed message, yet I got an error in event viewer : The TCP/IP Connection's 'host' in not answering(TCP/IP error ECONNREFUSED).

I have the IP address and host name entered in the hosts file and I did not altered any line in services file.

Anyone ran into this problem and fixed it? Please HELP!!!!
](*,)

Answers

  • kine
    kine Member Posts: 12,562
    try to do first 
    nassql appservername=APPSERVER-SQL,uninstallasservice

    and use the NASSQL.EXE instead NAS if you want to connect to SQL database... :-)

    And do not forget to give enough permission to the account under which the service will be running...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • couberpu
    couberpu Member Posts: 317
    I made two mistakes trying to connect SQL.

    1. I should use nassql.exe instead of nas.exe
    2. I did not properly setup windows logon under Navision.

    I changed the code to use nassql appservername.... and give proper permissions to the window user login to Navision under windows logon and It connected to Navision SQL database!

Categories