How to configure NAS with Navision SQL Server Option

ckndr47

Hello everybody,

I have configured NAS (Navision Application Server) with respect to my Navision Native Database. Everything is working fine; Code unit 1 Application management is working fine and i can see my test messages in Event Viewer.

Now i want to configure NAS with Navision SQL Server Option. So i am having problems in that;

Give me any hint, any reference, any url just to get things started.

Thanks and Regards,

kriki

This is an example you can use on SQL:
nassql.exe appservername=TheNasName, servername=TheServerName, database=TheDatabaseName, company="The Company", nettype=tcp, startupparameter=SomeStartupParameter, objectcache=30000,installasservice

ckndr47

Thanks Alain for your reply;
But still i am not clear;

What i have understood from your post is the fact that i have to specify that information in our SERVER.bat. Correct me if i am wrong.

Like for starting my NAVISION NATIVE DB Server i have a Server folder and in that folder i have different files and a SERVER.bat file; is it the file you are talking about.

Regards,

Luc_VanDyck

You have to type the line in a DOS box, in the directory where the program nassql.exe is located. The parameter "installasservice" will install this NAS as a service, so you can (re)start or stop this service using the services control panel.

ckndr47

OOOH SORRY ABT MY LAST MSG... MY LAST MSG was a total B*.. anyways...

do u mean that i have to Install a new NAS Transaction server for SQL.... like i did previously for NATIVE Navision DB from command prompt.

And if thats what you are talking about; then is there anything else i need to configure...

Thanks and Regards,

Luc_VanDyck

You are now using nassql.exe instead of nas.exe, so you sure need a new installation.

kriki

If you already have installed a NAS (nas.exe or nassql.exe) of the SAME Navision version you need, just copy the complete subdirectory of the NAS and use the new subdirectory for installing a new NAS (running the command I put in a previous reply).

DenSter

When you install NAS, it gives you one service for native as well as one service for SQL Server. Depending on the version there may be a bug in the nettype that you need to solve by using the command line, but you should have at least one SQL Server NAS available to you on the same machine as you installed the other one.

ckndr47

Thankyou everybody for your help. I am done with it. Just to sum up things; so that this post would be helpful for everybody.

Initial i created NasSQL server on the same machine on which i had Navision SQL Database and it worked fine; This is what i have written on command prompt.

nassql.exe appservername=NAS_SQL, servername=KHIPC040, database=SimplyWireless, company="SimplyWireless", nettype=tcp, startupparameter=NAS_SQL, objectcache=3000, installasservice

Now here servername = KHIPC040 is the same machine on which i have Navision SQL DB and NASSQL.

Then i installed Navision SQL DB at another machine named KHIPC034, and then i tried to configured NASSQL; so that i can access Navision SQL DB of KHIPC034 from my machine KHIPC040.

This is what i did.

nassql.exe appservername=NAS_SQL, servername=KHIPC034, database=SimplyWireless, company="SimplyWireless", nettype="named pipe" , startupparameter=NAS_SQL, objectcache=3000, installasservice

So you can see i have used nettype as "named pipe", and in the server name i have provided the machine where i am going to connect. If we are connecting a NASSQL to another machine then we have to make sure that we use nettype as "named pipe", becuase NAS works under windows authentication and TCP/IP wont work under Windows authentication. I dont want to drill down into complete steps like setting up the authentication for tht service and then setting up windows account in that NAV SQL DB n bla bla bla...

Anyways thanks again.
Regards,