When restoring on a Windows Server 2008

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.