NAS Command Prompt cannot detect my SQL Server

gemini_shooter
Member Posts: 149
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:
Command Prompt Message
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.
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.
0
Comments
-
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.0 -
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.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions