NAS Command Prompt cannot detect my SQL Server

gemini_shooter

Hello All,

I am trying to install NAS from the command prompt.

This is single box install and is a Windows 7 machine. I have already installed SQL Server 2008 and the NAV 5.0SP1 client and both are working great.

I installed the NAS software from the 5.0SP1 CD and used the how-to article to get started. (http://www.mibuso.com/howtoinfo.asp?FileID=15).

The problem I am having is that either service is not working:

1. If I try to install the NAS service through the command prompt I keep getting the message which looks like it is unable to find my SQL server and SQL database.

Below is the command file I created:

nassql.exe appservername=NASSBATRA01, NETTYPE=TCP, servername="SBATRA01"
database=Demo500SP1, company="CRONUS USA, Inc.", nettype=tcp
startupparameter=JOBQUEUE, objectcache=40000, installaservice

net start NASSBATRA01

Command Prompt Message

C:\Program Files (x86)\Microsoft Dynamics Nav\Application Server>nasstart

C:\Program Files (x86)\Microsoft Dynamics Nav\Application Server>nassql.exe apps
ervername=NASSBatra01, NETTYPE=TCP, servername="SBATRA01"
Date: 08/27/10
- 11:35:23 AM:
  11:35:23 AM: Application Server for Microsoft Dynamics NAV version 5.0 SP1 (Bu
ild 26084)
  11:35:23 AM: Copyright (c) 1987-2008 Microsoft Corporation
  11:35:23 AM:
[b]- 11:35:23 AM: You must specify which SQL Server and database you want to connec
t to when you start up the Application Server for Microsoft Dynamics NAV.[/b]
  11:35:23 AM:
  11:35:23 AM: The manual Installation and System Management contains a list of
the correct program properties.

C:\Program Files (x86)\Microsoft Dynamics Nav\Application Server>database=Demo50
0SP1, company="CRONUS USA, Inc.", nettype=tcp
'database' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files (x86)\Microsoft Dynamics Nav\Application Server>startupparamete
r=JOBQUEUE, objectcache=40000, installaservice
'startupparameter' is not recognized as an internal or external command,
operable program or batch file.

C:\Program Files (x86)\Microsoft Dynamics Nav\Application Server>net start NASSB
atra01
The service name is invalid.

More help is available by typing NET HELPMSG 2185.

I am don't understand why it cannot connect to the SQL server. I am setup as sysadmin on the SQL server.

2. If I try to start the default service installed by NAS then I get the "Incorrect Funtion" error, Windows cannot start this service on a local computer. The service uses a Network Service Account and that account has full access to SQL Database and also in NAV as Superuser.

Can anyone point me the right direction please.

gemini_shooter

OK... I got 1. to work to some extent

I put the entire nassql.exe cmd file into ONE LINE

and netstart command in the next line.

and it was able to find the SQL server.

kriki

Try this line:

nassql.exe appservername=NASSBATRA01, NETTYPE=TCP, servername="SBATRA01", database=Demo500SP1, company="CRONUS USA, Inc.", nettype=tcp, startupparameter=JOBQUEUE, objectcache=40000, installaservice

You need to put a "," between the different parameters and the must be put on 1 line.