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
Labels:
Location: Sector 62, NOIDA, Uttar Pradesh, India

Comments

  1. Peter WibeckJune 4, 2012 at 5:14 PM

    I linked to your good post in my blog

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

    ReplyDelete
  2. AnonymousJune 5, 2012 at 8:30 PM

    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. Saurav DhyaniJune 7, 2012 at 9:35 AM

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

      Delete
  3. AnonymousNovember 27, 2012 at 3:42 PM

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

    ReplyDelete
    Replies
    1. Saurav DhyaniNovember 27, 2012 at 5:29 PM

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

      Regards,
      Saurav Dhyani

      Delete
  4. AnonymousMarch 21, 2013 at 3:32 PM

    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. Saurav DhyaniMarch 21, 2013 at 7:07 PM

      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    ---------------------------
10 comments
Read Complete Article »

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...
4 comments
Read Complete Article »

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.
Post a Comment
Read Complete Article »