# When restoring on a Windows Server 2008

**URL:** <https://forum.ayanova.com/t/when-restoring-on-a-windows-server-2008/1790>\
**Category:** Backup & Restore\
**Created:** [September 28, 2009, 2:21pm UTC](https://forum.ayanova.com/t/when-restoring-on-a-windows-server-2008/1790 "2009-09-28T14:21:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![AyaNovaSupport](https://forum.ayanova.com/user_avatar/forum.ayanova.com/ayanovasupport/32/229_2.png) [@AyaNovaSupport](https://forum.ayanova.com/u/AyaNovaSupport)\
**Post date:** [September 28, 2009, 2:21pm UTC](https://forum.ayanova.com/t/when-restoring-on-a-windows-server-2008/1790/1 "2009-09-28T14:21:00Z")

</div>

In the event a restore of an AyaNova database on a Windows Server 2008 operating system is performed, do note that an AyaNova user encountered the following SQL error, and wanted to pass on the solution.

Error when restoring:

CREATE DATABASE permission denied in database ‘master’

Solution:

Windows Server 2008 requires you right click and run as admin when opening SQL in order to give the user the right permissions to restore databases into SQL.