Installing Demo

sabzam · 2009-08-05

Hi Everybody,

I am trying to install the demo for Navision 2009 using the official installation setup. I have got 2 sql server 2000 instances on my laptop and 1 sql server 2005. Is it possible to define on which instance the demo is to be installed as the following errors messages are cropping up:

Error -2147217865: failed to execute SQL string, error detail: Invalid object name 'master.sys.objects'., SQL key: DropXpNdoGroups SQL string: IF EXISTS (SELECT * FROM [master].[sys].[objects] WHERE name = 'xp_ndo_enumusergroups') EXEC sp_dropextendedproc xp_ndo_enumusergroups
Cronus Sample Database for Microsoft Dynamics NAV 2009
Fatal error during installation.

Error -2147217865: failed to execute SQL string, error detail: Invalid object name 'master.sys.databases'., SQL key: StopIfDatabaseExist SQL string: IF EXISTS (SELECT * FROM [master].[sys].[databases] WHERE name = 'Demo Database NAV (6-0)') RAISERROR (N'A database with na

ara3n · 2009-08-05

I don't think the demo option installed on instanced sql server.

I suggest to go to custom and select what you need to install.

Then attach the db manually and run sql scripts.

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

Peter_Wibeck_[MSFT] · 2009-08-26

Just to point out it NAV 2009 doesn't not support SQL 2000. In NAV 2009 RTM it's only possible to install the database manually and run some SQL scripts if you are not using that default instance name of your SQL server that you are installing on. For NAV 2009 SP1 it will be supported from the installer to specify instance name for SQL server.

How to install the stored procedures manually
http://blog.wibeck.org/2009/05/installi ... -manually/

How to install the databse manually
http://blog.wibeck.org/2009/05/how-to-i ... -database/

Peter_Wibeck_[MSFT] · 2009-08-27

It exist one more way to install the database manually. Instead how simple copy the one installed you can attach the one on the DVD directly. Take a look on my blog about.

http://blog.wibeck.org/2009/08/how-to-i ... rnative-2/

Installing Demo

Comments

Categories