View Error Cannot Create Table
Category:Tech Support Staff Only
Error Cannot Create Table
*****This information intended for Hudson Tech Support staff Only******I
f the error message: Cannot Create Table in database "testname" appears when trying to perform a basic function, such as generating trial detail for invoicing in Admin, this is usually due to a security setting inside SQL Server.
To enable the privelege:
Open Enterprise Manager.
Open the Security Subfolder
Select Logins
From the list of logins on the right, Right click the appropriate login and then select Properties.
Select the Database Access Tab.
Scroll down to the appropriate database that this Login has access to.
In the lower half of the Login Properties window, make sure that the following are checked:
public
db_owner
db_datareader
db-datawriter
Save the changes and exit Enterprise Manager
Restart the appropriate HWeb application (HWeb Admin in this example) and repeat the desired function (ex: Invoicing).