SaaS CMS has officially launched! Learn more now.

Error while creating a new site using EPiServer Deployment Centre



While creating a new site using EPiServer Deployment Centre i am getting this error......Error - The EXECUTE permission was denied on the object 'sp_executesql', database 'mssqlsystemresource', schema 'sys'......


Can any one pls figure it out.....

Oct 03, 2011 13:08

Seem like you have insufficient permissions on the DB. Double check the permissions for the user you are authenticating with during installation...

Oct 11, 2011 17:22

Hi Johan,

I got the solution for this issue......

step by step is like this :

Login to SqlServer 2008 with username sa

Goto Master DB -- >programmability folder -- > Extended Stored Procedures folder -- > select sp_executesql on it select Properties

Dialog box opens.In that select second tab [permission]

Click on Search btn. Select  users or roles dialogue box opens.

Click on Browse btn.

search where the public name is present and select the checkbox present before the public.

Click on OK -- > Ok.


If after doing the above process if it shows the error.....keep only the grant permission for Execute.

This solution worked for me......


Oct 13, 2011 13:44
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.