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.