Error while installing Nav2009R2

tanmaykothari

Hello Frnds

While Installing NAV 2009 R2 following errors occurs

1)
Server
Indian Module for Microsoft Dynamics NAV 2009 Server
Fatal error during installation.

Service 'Microsoft Dynamics NAV Server' (MicrosoftDynamicsNavServer) failed to start. Verify that you have sufficient privileges to start system services.
2)
SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
Fatal error during installation.

Invalid object name 'master.sys.objects'.

3)
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.

Invalid object name 'master.sys.databases'.
Created on "GODREJ-2CAEABB1"

Plz Help Me To Resolve abve errors

Thank u in advance

mohana_cse06

Check this link
http://www.mibuso.com/forum/viewtopic.php?f=32&t=47578

If it doesn't help let me know..

raveendran.s

Check whether u r having all the admin rights for installing r not... try by running the setup file in the mode of "Run as Administrator". I mean right click on the Autorun --> Run as Administrator.

tanmaykothari

Dear mohana
First Thank you for ur reply
I m tried ur option but still it gives me same errors
actually i installed it on Windows 7
but now i want to install same on windows Xp sp3

plz if u have another solution then send me

mohana_cse06

Can you tell me what options you have tried?

tanmaykothari

Dear mohana

First I uninstall setup From control Panal
Then I remove MicrosoftDynamic Folder From C:/ProgramFile
and Reinstall Setup

mohana_cse06

Did you set Stored procedures in SQl?

Check whether Net.Tcp Port Sharing Service service is running or not..

tanmaykothari

i DID NOT know how to SET Stored procedure in sql
please tell me how to set that

and regarding .net port shairing service it is running

tanmaykothari

First Thank u for ur reply

i tried ur option but still it gives me same error

mohana_cse06

Follow this blog to install stored procedures manually
http://blog.wibeck.org/2009/05/installing-store-procedures-for-dynamics-nav-2009-manually/

tanmaykothari

Dear Mohan

I wirte Qurey For Stored Procedure like this. is it correct?
i run that procedure it exequte properly.
but still i face same problem

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, ‘D:[D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database]xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘D: [D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database]xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

Errors

Server
Indian Module for Microsoft Dynamics NAV 2009 Server
Fatal error during installation.

Service 'Microsoft Dynamics NAV Server' (MicrosoftDynamicsNavServer) failed to start. Verify that you have sufficient privileges to start system services.
SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
Fatal error during installation.

Invalid object name 'master.sys.objects'.
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.

Invalid object name 'master.sys.databases'.

mohana_cse06

tanmaykothari wrote:

EXEC sp_addextendedproc xp_ndo_enumusersids, ‘D:[D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database]xp_ndo.dll’

EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘D: [D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database]xp_ndo.dll’

‘D: [D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database]xp_ndo.dll’
this path should be exact path of your system where xp_ndo.dll file exists..

your path is wrong as of now..

tanmaykothari

Dear Mohan
when i execute below query it givaes me error like

Errors

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '‘'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'xp_ndo_enumusersids', because it does not exist or you do not have permission.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '‘'.
Msg 15151, Level 16, State 1, Line 2
Cannot find the object 'xp_ndo_enumusergroups', because it does not exist or you do not have permission.

Query

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, ‘D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database\xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database\xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

plz can correct above query

mohana_cse06

try with " " (double quotes) or []
‘D:\Navision 2009 R2\SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database\xp_ndo.dll’

tanmaykothari

Dear Mohan,
Stored Procedure executed successfully, Still facing same problem..

mohana_cse06

Are you installing with administration role?

is Microsoft dynamics Server service created?

if not try by creating manually
http://msdn.microsoft.com/en-us/library/dd301437.aspx

tanmaykothari

Dear Mohan

To create new service i create new folder service2
now when i m going to execute command in commabd prompt
it gives me error

Error
1)The System can not find the file specified

Command which i want to execute

C:\> sc \\<godrej-2caeabb1.gitl.com> create MicrosoftDynamicsNAVServer$NAV2 binpath= "C:\Program Files\Microsoft Dynamics NAV\60\Service2\Microsoft.Dynamics.Nav.Server.exe $NAV2" DisplayName= "Microsoft Dynamics NAV Server Instance 2" start= auto type= own depend= NetTcpPortSharing[/b]

postsaurav

Dear tanmaykothari,

If you still have the same error as you posted first i might help on some of these -

1)Server
Indian Module for Microsoft Dynamics NAV 2009 Server
Fatal error during installation.
Service 'Microsoft Dynamics NAV Server' (MicrosoftDynamicsNavServer) failed to start. Verify that you have sufficient privileges to start system services.



This is not an error, this is due to improper time zone in the config file.
Refer article http://saurav-nav.blogspot.com/2011/05/error-after-installation-of-microsoft.html



2)SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
Fatal error during installation.

Invalid object name 'master.sys.objects'.

3)Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.

Invalid object name 'master.sys.databases'.
Created on "GODREJ-2CAEABB1"




I am not sure about the issue but you can follow these steps.
1) You Should run Setup with Run as Adminsitrator, if you still face issues related to SQL Server, and its your local machine, i would suggest you install it again and remember that after installing sql server (2005/2008) please apply atlease service pack2.

2) After reading replies i think if it is related to xp_ndo. dll then you should follow procedure as given -
For 32 bits OS - http://saurav-nav.blogspot.com/2011/05/extended-stored-procedure-xpndodll.html
For 64 bit OS - http://saurav-nav.blogspot.com/2011/05/extended-stored-procedure-xpndodll.html


Regards,
Saurav dhyani

Peter_Wibeck_[MSFT]

It's something wrong with your SQL server installation for sure. If this is not a production environment as I assume it's not I would simple un install SQL server from the machine and let NAV installer install it for you.

1. Un install NAV
2. Un install SQL server
3. Install NAV

I does exist another option here that should work on NAV 2009 SP1 and R2 not sure about NAV 2009, if you have stuff on SQL that you don't want to delete. Simple install a new SQL server instance and point to that instance during installation.

Mohammed

If anybody is still facing this issue....

1)
Server
Indian Module for Microsoft Dynamics NAV 2009 Server
Fatal error during installation.


Me too got the same error with Singaporean Module for Microsoft Dynamics NAV 2009 Server

then I opened the CustomsSettings.config file and edited the line like this

<add key="WebServicesDefaultTimeZone" value="Singapore Standard Time"></add>

After saving the file I've tried restarting the Service. It was successfull