RADEditor Permission denied issue.


I recently got chance to work on RadEditor control. It works fine in my local development environment. However, where I try to deploy the my application in to win2003 server. It give me permission error. Here are the details error happened to me.

1. Show page not found

2. Show 400 Bad request

3. Show permission denied

4. Debug the javascript and getting permission denied error.

Appreciate if anyone come across the same issue and point out the hints!

Update 2 June 2008

- I found that there my master page contains some CSS that cause the error:

<!–[if IE]>
<style type=”text/css” media=”screen”>
#menu ul li {float: left; width: 100%;}
body {
behavior: url(<http://www.mysite.com/css/csshover2.htc);
font-size: 100%;
}
</style>
<![endif]–>

This also explain why it only happen in IE browser. But the funny thing is this simple script can cause radEditor become malfunction and it only happen in certain conditions.

Posted in .Net. No Comments »

Error Installing the Session State Database


I am trying to setup SQL Session State database but encountered error as below:

An error occurred during the execution of the SQL file ‘InstallSqlState.sql’. The SQL error number is 229 and the SqlException message is: EXECUTE permission denied on object ‘sp_delete_job’, database ‘msdb’, schema ‘dbo’.If the job does not exist, an error from msdb.dbo.sp_delete_job is expected.
SQL Server: sql2005.valuethai.com
Database: [vtdb_ss]
SQL file loaded:
InstallSqlState.sql
Commands failed:…

Here is the command run by me:
aspnet_regsql.exe -S [sqlservername] -U [userid] -P [userpassword] -ssadd -sstype c -d [customdatabase]

After doing some debugging, I manage to solve it by assigning enough rights to msdb database. Once I map msdb to db_owner/public, it works fine.