Friday, July 9, 2010

Error: CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Error:
CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)






Reason:
You will get this error, when you are trying to create a new SharePoint web application using the ATTACHED DATABASE through the central admin. Because, your central admin user (that is current user to create a website) may not having a permission to create tables dynamically in the SQL Server. 

Solution:
Solution is very simple. Just attach the database in SQL Server using the current user of the central admin as the owner of the DB. (But it takes long time for me to find out the exact reason).

For example, If your current central admin logged-in username is "domain\senthil" (Assumes, senthil is going to create a new web application) , then you should attach the database using the "domain\senthil" username.

You can change the owner of the database during the "Attach databases" as per the below screenshot.




Thats It...

No comments:

Post a Comment