Finally I was able to fix this issue...:-D
The steps are as follows-
-Take the backup of master database
-Start SQL Server in single user mode using –m switch
-Login to SQL server Dedicated Administrator connection
-Update value of ‘category’ field to 23040 from existing value 23056 in ‘sys.sysdbreg’ table for <dbname> database
-Start SQL server in normal mode