How to install and configure Microsoft Dynamics NAV 2009 R2

Chowdary · **Posted:** Wed Oct 12, 2011 12:26 pm

Hi,

I have finsql.exe and SQL Server 2008 R2. (Don't know how to check weather NAS installed or not, can someone help me out here)
I mainly want to run RTC. For that when I'm opening RTC I'm getting this error:

Program could not connect to the server. Do you want to try again?

some one can provide me steps to install and configure

thanks
Chowdary

mohana_cse06 · **Posted:** Wed Oct 12, 2011 1:09 pm

If you want to run RTC, nothing to do with NAS..will discuss that later..

First, what did you install ans how?
Is it a single system or server-client connectivity?

Did you install nav service? is that running?

Did you modify custom settings file with correct server name and database name?

mohana_cse06 · **Posted:** Wed Oct 12, 2011 1:13 pm

Chowdary wrote:

some one can provide me steps to install and configure

http://msdn.microsoft.com/en-us/library/dd301254.aspx
http://msdn.microsoft.com/en-us/library/dd355184.aspx

Chowdary · **Posted:** Wed Oct 12, 2011 1:31 pm

Hi Mohana

Actually my question is for my personal laptop to work with RTC.

But for now, am having problem at work.
It was installed by my colleague and she told how she did, as follows:

Quote:

First, what did you install ans how?

First installed client and then service and then service tier

Quote:

Is it a single system or server-client connectivity?

its server-client connectivity

Quote:

Did you install nav service? is that running?

yes, installed but not running, this is the main issue now

Quote:

Did you modify custom settings file with correct server name and database name?

yes, modified with correct server and database

The issue with Microsoft Dynamics NAV Server is, its not starting

giving this error:
The Microsoft Dynamics NAV Server service on local computer started and then stopped. Some services stop automatically if they are not in use by other services pr programs

thanks
Chowdary

mohana_cse06 · **Posted:** Wed Oct 12, 2011 5:26 pm

Chowdary wrote:

giving this error:
The Microsoft Dynamics NAV Server service on local computer started and then stopped. Some services stop automatically if they are not in use by other services pr programs

Search the forum with above error..you will get lot of discussion like
http://www.mibuso.com/forum/viewtopic.php?t=38900

kine · **Posted:** Wed Oct 12, 2011 10:18 pm

If you want to know why it is stopping, look into Event Log. This is basic step you need to do each time you have problems with something... There will be info what is wrong...

Chowdary · **Posted:** Thu Oct 13, 2011 12:56 pm

kine wrote:

If you want to know why it is stopping, look into Event Log. This is basic step you need to do each time you have problems with something... There will be info what is wrong...

Hi Kine

Plz see Event Viewer for the error below:

Quote:

Log Name: Security
Source: Microsoft-Windows-Security-Auditing
Date: 10/13/2011 1:57:20 PM
Event ID: 4672
Task Category: Special Logon
Level: Information
Keywords: Audit Success
User: N/A
Computer: NAVSERV2
Description: Special privileges assigned to new logon.
Subject:
Security ID: NAVSERV2\Administrator
Account Name: Administrator
Account Domain: NAVSERV2
Logon ID: 0xa0017f2
Privileges: SeSecurityPrivilege
SeTakeOwnershipPrivilege
SeLoadDriverPrivilege
SeBackupPrivilege
SeRestorePrivilege
SeDebugPrivilege
SeSystemEnvironmentPrivilege
SeImpersonatePrivilege

- System
- Provider
[ Name] Microsoft-Windows-Security-Auditing
[ Guid] {54849625-5478-4994-a5ba-3e3b0328c30d}

EventID 4672
Version 0
Level 0
Task 12548
Opcode 0
Keywords 0x8020000000000000
- TimeCreated
[ SystemTime] 2011-10-13T09:57:20.098Z
EventRecordID 3074
Correlation
- Execution
[ ProcessID] 624
[ ThreadID] 2032
Channel Security
Computer NAVSERV2
Security
- EventData
SubjectUserSid S-1-5-21-1868156668-3483688429-259026737-500
SubjectUserName Administrator
SubjectDomainName NAVSERV2
SubjectLogonId 0xa0017f2
PrivilegeList SeSecurityPrivilege SeTakeOwnershipPrivilege
SeLoadDriverPrivilege SeBackupPrivilege SeRestorePrivilege SeDebugPrivilege SeSystemEnvironmentPrivilege SeImpersonatePrivilege

plz tell me whtz wrong?

Thanks
Chowdary

mohana_cse06 · **Posted:** Thu Oct 13, 2011 1:01 pm

Did you set windows authentication in navision?

RTC works only with Windows authentication..

Chowdary · **Posted:** Thu Oct 13, 2011 1:11 pm

mohana_cse06 wrote:

Did you set windows authentication in navision?

RTC works only with Windows authentication..

I was trying to start Micarosoft Dynamics NAV Server, but didn't check navision

now when I'm trying to start(finsql.exe) with windows authentication am getting this error:

The extended stored procedure xp_ndo_enumusergroups in the library file xp_ndo.dll is not available on the database server navserv2\sqlexpress

is this the reason am getting service started and then stopped error?

Thanks
Chowdary

julkifli33 · **Posted:** Thu Oct 13, 2011 1:13 pm

check your service, whether already started or not

Chowdary · **Posted:** Thu Oct 13, 2011 1:22 pm

julkifli33 wrote:

check your service, whether already started or not

No, my NAV server is not starting, giving the same error:

The Microsoft Dynamics NAV Server service on local computer started and then stopped. Some services stop automatically if they are not in use by other services pr programs

Thanks
Chowdary

mohana_cse06 · **Posted:** Thu Oct 13, 2011 1:29 pm

please please search the forum first
http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

julkifli33 · **Posted:** Thu Oct 13, 2011 1:38 pm

Chowdary wrote:

julkifli33 wrote:

check your service, whether already started or not

No, my NAV server is not starting, giving the same error:

The Microsoft Dynamics NAV Server service on local computer started and then stopped. Some services stop automatically if they are not in use by other services pr programs

Thanks
Chowdary

change the log on of your service

Chowdary · **Posted:** Thu Oct 13, 2011 2:02 pm

mohana_cse06 wrote:

please please search the forum first
http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

Hi Mohana

I ran this and it was successful

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids,'C:\Program Files (x86)\Microsoft Dynamics NAV\60\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups,'C:\Program Files(x86)\Microsoft Dynamics NAV\60\xp_ndo.dll'
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

but I couldn't see them in the list of Stored Procedures

and as well when I'm trying to open navision windows authentication am getting attached error

what I did for stored procedure was right?

Thanks
Chowdary

mohana_cse06 · **Posted:** Thu Oct 13, 2011 2:08 pm

Better you copy the dll file to
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\

and try

mibuso.com

How to install and configure Microsoft Dynamics NAV 2009 R2

Who is online