Community in read only mode June 18 & 19
This community will be set in READ ONLY mode for a while on Tuesday June 18 into Wednesday June 19 while we import content and users from our Micro Focus Forums community site. MORE INFORMATION

SQL Error When Creating New SQL Express in Enterprise Analyzer

SQL Error When Creating New SQL Express in Enterprise Analyzer

Problem:

When creating a new workspace in Enterprise Analyzer using the SQL Express database, user receives a SQL error.

"CREATE DATABASE permission denied in database 'master'.sql ..."

Resolution:

When using the SQL Express database provided with Enterprise Analyzer, the user needs to ensure that there are the proper dba and dbo permissions on the database.  These are automatically applied during installation, assuming that the user account is the one that performed the installation.

If this is not the case, uninstalling and reinstalling the SQL Express database using the user account should resolve the issue.

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2017-01-26 14:41
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.