Monday, June 4, 2012

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

7 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