Failed to execute SQL string when Installing Dynamics NAV 2009 #2

When reinstalling Dynamics NAV 2009 or if you have attached a Demo Database manually you will probably run into this problem:

—————————————————————————–
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
—————————————————————————–
Read more

Installing stored procedures for Dynamics NAV 2009 manually

It’s recommended that you use the installer on the product DVD to install the stored procedures. But if you are running more than one name instance of SQL server on the same machine that approach will not work. Then you need to-do it manually:
1. Copy the xp_ndo.dll file to the location you want store it. The file can be found under “D:SQLDatabasePFilesMicrosoft Dynamics NAV60Database” on the product DVD.
2. Run the following SQL command to add the stored procedures.

USE master
EXEC sp_addextendedproc xp_ndo_enumusersids, ‘C:[Location of file]xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusersids]
TO PUBLIC
GO

USE master
EXEC sp_addextendedproc xp_ndo_enumusergroups, ‘C: [Location of file]xp_ndo.dll’
GO

GRANT EXECUTE
ON [xp_ndo_enumusergroups]
TO PUBLIC
GO

How to install more than one Dynamics NAV 2009 Demo Database

By default when you are installing the demo database by the installation program you can only install one Demo Database. But if you would like to have more than one Demo Database to try different things in, how to accomplish that? I assume that you know that you can create a new company in the classic client, but you will then not get the demo data. The solution is simple to use SQL Server Management Studio to attach more than one version of the Demo Database.
Read more

Failed to execute SQL string when Installing Dynamics NAV 2009

One not complete uncommon error when installing Dynamics NAV 2009 is the one bellow:

—————————————————————————–
Microsoft Dynamics NAV 2009 Build 27808
Error Report
SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
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 name %s already exists.’,20,1,’Demo Database NAV (6-0)’) WITH LOG
Fatal error during installation.
—————————————————————————–
Read more

How to install Dynamics NAV 2009 Demo Database to named instance of SQL

By default when you are installing the demo database it will get installed on the instance named MSSQLSERVER. That is the default instance name for SQL Server 2005. But if you have a SQL Server with another instance name where you would like to install the Demo Database, how do you do then? The answer to that question is to use the msi for the Demo Database installation and not the installation program in the root of the DVD. A small not is that you can’t run the installation program found in the root of the DVD (setup.exe) on the computer after you have installed the demo database using this work around since this will uninstalled the demo database. This happens because the central installation program keeps an inventory of the NAV products that have been installed to the computer and will uninstall those which are not in the inventory.
Read more

Using SQL Server 2008 Express in Dynamics NAV 2009

NAV 2009 will install SQL Server Express 2005 by default if no SQL server is installed. So if you would like to use SQL Server Express 2008 instead, this is the way to go:

The Demo installation of NAV 2009 is looking for a SQL Server instance called MSSQLSERVER. If the installer can’t find this instance SQL Server Express 2005 will be installed and the Demo Database will be attached to SQL Server 2005 even though you might have had SQL Server Express 2008 installed.
So to install on SQL Server Express 2008 you need to set the instance name to MSSQLSERVER. This way NAV 2009 will install the Demo Database on SQL Server 2008.

Note: SQL Server 2008 requires the following:
.NET Framework 3.5 SP1
Windows Installer 4.5
Windows PowerShell 1.0 (Included in Windows Vista SP1 and Windows Server 2008)