EXECUTE permission denied on object 'cs_system_GenerateWeblogYearMonthDayList'

Reply

vincent90152900 Posted: Tue, May 6 2008 7:41 AM

rated by 0 users

EXECUTE permission denied on object 'cs_system_GenerateWeblogYearMonthDayList'

I get a error message when I try to install CS2007.1_3.1.20917.1142 web install

How to solve this problem?

Many thanks for your replying.

Reply

dpenton replied on Tue, May 6 2008 5:23 PM

rated by 0 users

Vincent,

You should be able to do this from SQL Server Management Studio:

GRANT EXECUTE ON dbo.cs_system_GenerateWeblogYearMonthDayList TO PUBLIC

and then you can just execute that stored procedure as is.

Thanks,
David L. Penton

Reply

vincent90152900 replied on Tue, May 6 2008 8:56 PM

rated by 0 users

Many thanks for your replying.

I try to execute the sql command,” GRANT EXECUTE ON dbo.cs_system_GenerateWeblogYearMonthDayList TO PUBLIC”, from SQL Server Management Studio.

Then, I get this error message, “Msg 208, Level 16, State 11, Line 1

Invalid object name 'dbo.cs_system_GenerateWeblogYearMonthDayList'.”

I think it is because I am try to install community server web install and the table is not yet be created.

Do you know how to solve that?

Thank you very much for your helping.