CREATE DATABASE permission denied in database ‘master’ - while Installing Webgility Desktop and creating a new database on migration
Reason:
Webgility Desktop Software has the capability of installing SQL Server and creating a database instance during the time of installation. There are scenarios where Webgility Desktop Software may run into an issue with the SQL Server installation and create a new database due to permission Issues OR system environment restrictions.
Resolution:
You will need to download and install the required SQL Server version (either the same or upgraded version compared to the old server machine) and create a new database instance on the new machine.
Steps to rectify this:
1). Follow the steps mentioned in the following help article (LINK) to install SQL Server and create a new database instance.
2). Launch Webgility Desktop Software. When it launches it will try to connect with an existing server but eventually end with a database configuration form.
3). Select the "Connect Webgility database to an existing SQL Server" then under "Locate SQL Server" dropdown choose "Browse for More" option then wait for 2-3 mins as it detects all the SQL Server database instances available within the local network.
4). Now select the new database instance that you just created while installing the SQL Server. Use the SQL Auth option. Username = “sa” and Password = “Webgility2011” and click on Connect
5). Now it will redirect you to a window asking to restore a database and here you can browse the latest database backup (use the DB Backup you took from the old server machine) and proceed further to restore it.
6). Once done then close Webgility Desktop completely. Then on the new machine go to folder location “C:\Webgility\UnifyEnterprise” and look for a file with the name “UnifyDBUpgrade” (run it only once) and wait for a success popup. Once done, you can try to log in again to Webgility Desktop on the new machine.
If you have any difficulties, please contact Webgility Support for assistance.