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