Nav 2009 Installation and Windows XP SP3

subrata.bauri · March 5, 2009, 8:23am

I’m trying to (RE) install Nav 2009 into my PC where MS SQL Server 2008 is already installed. Can anyone give me the details of the Installation Process…?

At first I want to install Nav database server or Nav SQL server with the Classic Client and then try with it to ensure is it working or not in PC

MY PC Name is ADEY, IP Address is 192.168.0.158. PC is running on Windows XP SP3 Operating System.

I have attached some screen shots where I have to put some parameters but I can’t understand what parameters I have to define….

Kindly help…

First Screen shot

ReGa · March 5, 2009, 9:13am

hi, the nav server is the middle tier server of the 3-tier architecture.

the database server is the classic database server of the 2-tier architecture.

Which problem do you have if you try to install?

About your installation question:

If the sql server already exist, install

-RT client

-nav server

-classic client

start the classic client
File database - new to create new database
Restore the default backup which is included on the product cd

If you have further questions let me know!

Rgds,

Rene

subrata.bauri · March 5, 2009, 10:36am

Hi Rega,

In my PC I can get the Demo Database NAV (6-0) through the SQL Server Option ( Server name : TestServer, Windows Authentication ).

But the other client can not find the Server name TestServer.

And I want to log in into my DB with Database server Authentication, how can I do ??

ReGa · March 5, 2009, 10:48am

DB authentication is not supported by the RT client. you have to use Windows login.

The server you have to specify in the RT client is not the SQL Server name.

You have to use the nav serve/instance name:

→ example localhost/DynamicsNAV

Take a look into your services (control panel) whats the name of your instance.

Usually in a demo environment (and on the local machine) it is localhost/DynamicsNAV

Anyway take a look into your services if the Microsoft Dynamics NAV server is started

Cheers,

Rene

subrata.bauri · March 5, 2009, 11:05am

I want to repeat my question againg…

Hi Rega,

In my PC I can get the Demo Database NAV (6-0) through the SQL Server Option ( Server name : TestServer, Windows Authentication ).

But the other client can not find the Server name TestServer.

And I want to log in into my DB with Database server Authentication, how can I do ??

How Can I coneect the same db via Database server Authentication ??

subrata.bauri · March 5, 2009, 11:51am

In Nav 5.0 Installation, I have to select the database and license file.But In Nav 2009 where I have to select/specify these two ?? I don’t want RTC now. I just want to connect my DB via Database Server Option.

kindly help…

ReGa · March 5, 2009, 12:20pm

hi, first of all sorry for misunderstanding. But i am not quite sure if understand you correctly now…

You want to use NAV 2009, classic client? One workstation is working an can connect? The other workstation isn’t? Correct?

If another client cannot find the server try to ping the server ip address - is this possible?

Did you choose the right network type ? (tcp/tcps/…)

…

.

Is this whats your troubles in connection?

About your question to choose the authentication method: (Be sure you have entered database user in NAV )

Select database / open (is still the same) position for open a database / connect to a server and choose authentication method

Tools / license information (is still the same) to choose license

If you use SQL Server be sure that the user(s) are existing on the SQL Server too.

Please give me more details if this answer wasn’t helpful

Rene

subrata.bauri · March 5, 2009, 12:39pm

Hi ReGa,

Plaese forget all about the SQL Server or RTC first…

I just want to install Navision Databse Server in my PC with the Nav 2009 setup file.

How can I do this ?? where I have to Specify/Select the Databse & License file .??

ReGa · March 5, 2009, 12:44pm

browse the product cd (do not start the autostart)

open the “Server” directory. Start the setup.exe ./ choose custom… is still the same …

rene

subrata.bauri · March 5, 2009, 1:00pm

yes ReGa,

I have got it from the path you explained…Ok thanks, But In i can not specify this in the screen below ? right ?

5282.Nav6.0.bmp (659 KB)

ReGa · March 5, 2009, 1:10pm

Sure, some parts:

1.choose the database server in the screen below.

then click next
the a dialog appears where the datbase server is underlined. This is a hyperlink. click on it and the configuration dialog appears.

Rene

subrata.bauri · March 5, 2009, 1:24pm

i can’t find it rene

subrata.bauri · March 5, 2009, 1:27pm

Which Option I have to choose for that

subrata.bauri · March 5, 2009, 1:29pm

BTW

Thanks for your help

ReGa · March 5, 2009, 1:35pm

your welcome! it should look like my screen capture

subrata.bauri · March 6, 2009, 7:37am

Hi All,

Now I’m trying to install nav 2009 Demo version in my pc ( Windows xp sp3 ) where Configuration Tools of Microsoft SQL Server 2005 is pre-installed. After Installation complete it gives me an error message. …

Microsoft Dynamics NAV 2009 Build 27808

Error Report

SQL Server option

Cronus Sample Database for Microsoft Dynamics NAV 2009

Fatal error during installation.

Error -2147467259: failed to execute SQL string, error detail: A database with name Demo Database NAV (6-0) already exists., SQL key: StopIfDatabaseExist SQL string: IF EXISTS (SELECT * FROM [master].[sys].[databases] WHERE name = ‘Demo Database NAV (6-0)’) RAISERROR (N’A database with name %s already exists.’,20,1,‘Demo Database NAV (6-0)’) WITH LOG

Created on “PC”

3/6/2009 1:12 PM

After Complete Installation nav 2009 how can I connect my Demo Database Nav (6-0) via MS Dynamic Nav 2009 Classic with Microsoft SQL server ??

When I try to connect vai RTC it gives me an error message Ther user ID and password is invalid. Try again .

Plz help to solve these issues.

subrata.bauri · March 6, 2009, 9:27am

After complete demo installation of Nav 2009, now I’m trying to open the demo db using SQL Classic client.

It gives me an error message when I’m trying to the db via Database Server Authentication. The error message is……

The user ID and password is invalid.try again.

It opens the demo db when trying to via Windows Authentication.

Can you tell me how can I open the db via Database Server Authentication??

rbmafrica · March 29, 2010, 12:34pm

The difference between server and database server is that server refers to Microsoft Outlook where as Database Server is the usual “propriatory” database server of NAV.

Robert

DenSter · March 29, 2010, 1:23pm

No that is most definately not true