Error while installing demo database

nav_126

Dear All,

I found following error after installation of a demo version of NAV 2009 on a machine. SQL 2005 is installed on the machine.

can anyone tell that whats the reason for the same?

ERROR:
SQL Server option
Microsoft Dynamics NAV 2009 Components for Microsoft SQL Server
Fatal error during installation.

Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.

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

Could not connect to the SQL database. (-2147467259 master ). This can be caused by insufficient permissions. Indirect permissions through Windows group memberships may not work as expected when User Account Control (UAC) is turned on.


Regards
Navision Developer

kine

Wich OS? Windows XP, Vista or Win 7? I assume Vista or 7 and thus as described in the error, you need to run the setup as administrator...

nav_126

Thnks,

I got your point and it worked for me.

Now, can you explain that how to check that if SQL Server and NAV server are running on domain service / netwrok service? both are on different machines.

Do i need to setup delegation for my each and every windows user who wants to access Navision through RTC?

(It looks so silly but please answer me if anyone can explain )

Regards
Navision Developer

alexpeck

If the service tier and SQL Server are hosted on different machines you need to set up delegation. Please consult the walkthrough in the help entitled "Walkthrough: Installing the Three Tiers on Three Computers".

If you are on 2009 SP1 you can also use the Best Practices Analyser to help troubleshoot your configuration.

Alex

nav_126

Thnx for the reply.

Now, I have 20 users who will use Navision with RTC. Should i create 20 different SPN's ? as syntax suggests

setspn –A ServerName_InstanceName/FullyQualifiedDomainNameOfServer:Port Domain \User

I have read the walkthrough but it didnt help much. Can anyone help on this?



Regards
Navision Developer

kine

It is about the service tier (and the user account under it is running), not about the clients or their accounts...

cgumbo

kine wrote:

Wich OS? Windows XP, Vista or Win 7? I assume Vista or 7 and thus as described in the error, you need to run the setup as administrator...

First of all am using Windows XP as the OS, still the error has continue,I have sql 2000 and 2005 installed with sql 2000 as the default instance, what could be the problem?

Peter_Wibeck_[MSFT]

The SQL demo database installer will always by default install to deafault instance name. And since you are running SQL server 2000 with the default instance name and SQL server 2000 is not support by NAV 2009, you will get problems. When running the setup.exe ensure to specifify the instance name parameter on the specify parameter page to installer to the SQL server 2005 instance. Also ensure that the user you are running the installer are admin on the SQL server 2005 instance.

/Peter