web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Microsoft Dynamics NAV...
Microsoft Dynamics NAV (Archived)
Answered

Microsoft Dynamics NAV 2009 Build 29626

(0) ShareShare
ReportReport
Posted on by almoosawisafio 200
Microsoft Dynamics NAV 2009 Build 29626 Error Report 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.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    It is mainly related to insufficient permissions on SQL server. If the database has been created despite the error as workaround for this problem you can:

    1) Copy the xp_ndo.dll file to target installation directory (file is located in SQLDatabase\PFiles\Microsoft Dynamics NAV\60\Database directory of product DVD).

    2) Run this SQL commands 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

    3) Run the setup again.

  • almoosawisafio Profile Picture
    almoosawisafio 200 on at

    Hi Thanks Daniele Rebussi

    I run the SQL commands on master data base Query and get success

    but still get the same error

  • Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    Just a couple of additional checks:

    - Is installation username included into the local administrator group?

    - Is the port 1433 opened on firewall? (You can also consider to temporarly disable the firewall)

    - Is the User Account Control turned off?

    - Did you run the setup with "Run as administrator" option?

  • Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    Moreover:

    - Go to services.msc and check that SQL service is running.

    - Check if you don't have any previous installation (mdf and ldf files in \Program Files\Microsoft Dynamics NAV\60\Database\ directory): in this case delete the files or rename the database.

  • almoosawisafio Profile Picture
    almoosawisafio 200 on at

    Am so appreciated your help

    So  You mentioned That one of the  Error reason is :

    Is installation username included into the local administrator group

    I use the Administrator Account to log in to the NAV SQL machine and for the SQL services Log in with different account (service account ) and I configure it  in the Local Security Policy do I need further conig for the account ?

    thanks

  • Verified answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    Should be enough to set the user with server role - SysAdmin: if, during the installation, inside "Client" tab you left Windows, as credential type you need to modify the user which is running the setup, otherwise change permission of the account specified.

  • almoosawisafio Profile Picture
    almoosawisafio 200 on at

    Daniel am so appreciate you efforts helping me in this issue

    Finally I solve the previous error .

    Now I get another account error the account the run NAV2009 server cannot access to the Demo Database that I create I use for the server login a service account  and for the SQL instance the default account (network service account ) should I use the same account in booth machines ?

    thanks  

  • almoosawisafio Profile Picture
    almoosawisafio 200 on at

    Thans A lot Daniele

    Its work now

    But I cannot login from another machine in my network just from DYNAMCS NAV Server ? why is that

  • Suggested answer
    Daniele Rebussi Profile Picture
    Daniele Rebussi 2,480 on at

    From the other machine can you connect via telnet to the NAV server?

    I suggest to verify if the proper delegations exists: take a look at the following link: msdn.microsoft.com/.../dd301254.aspx

  • almoosawisafio Profile Picture
    almoosawisafio 200 on at

    I don't know how to do that by Telnet , But I check the connection through ping command and it work I can ping to the server

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans