NAS error ECONNREFUSED

couberpucouberpu Member Posts: 317
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

  • kinekine 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.
  • couberpucouberpu 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!
Sign In or Register to comment.