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.....
Seem like you have insufficient permissions on the DB. Double check the permissions for the user you are authenticating with during installation...
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
Rt.click 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......