Skip to main content

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.


Hi all,
During Installation of NAV 2009 & Later, sometime we come across an error which says -

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 error can be occured due to multile Reasons, so there are mutiple resoultion for the same.


Resolutions -

1) Did u Run installer as Administrator (If Operating system is Windows 7)?
    If not then try intalling using Run as Administrator.

2) Go to services.msc from RUN and check that SQL Server service is running or not. If not start the service and try intalling again.

3) Your Windows does not have sufficient priviledges on the SQL Server. Set up your account with the sysadm server role. Note, that you cannot rely on indirect permissions through Windows group memberships when Vista User Access Control (UAC) is turned on. Try seraching UAC in Control Panel.

4) A previous installation has left the database files (mdf+ldf) sitting in the \Program Files\Microsoft Dynamics NAV\60\Database\ folder and the SQL Server has been reinstalled. This will result in the installer trying to attach an orphaned database. If this is the case, then you should just delete the files or Rename the Database, run the installation once where you select to remove the database components, and run the installation once again where you select to install the demo database.

These are the comman resolutions in this case i was able to find it. I hope someone might be helpfull and it resolve someones issues.

Thanks & Regards,
Saurav Dhyani

Comments

  1. I linked to your good post in my blog

    http://blog.wibeck.org/2012/06/problem-installing-demo-database/

    ReplyDelete
  2. Did notice you are setting up NAV7. Probably not the standard NAVDEMO setup but a other instance. I tried the same with the same error.
    Was able to setup the database from the databasesetup MSI

    ReplyDelete
    Replies
    1. Yes the screen shot is for NAV 7 but it also comes with other version of Navision Role Tailored Client..

      Delete
  3. Hi Sourav that you for your post however it does not solve the issue.

    ReplyDelete
    Replies
    1. Hi for which version the steps dosen't resolved the issue.

      Regards,
      Saurav Dhyani

      Delete
  4. Hi Saurav

    I was installing Nav2103. i got the same error. i checked whatever u had mentioned points above. But doesn't resolved the issue. Kindly inform if you know to solve this issues

    Regards

    Kavi

    ReplyDelete
    Replies
    1. Hi Kavi,

      Are you using Demo installation or the customize installation.

      You can drop me mail on postsaurav@gmail.com

      Regards,
      Saurav Dhyani

      Delete

Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------