On a Windows Server 2008 SP1 with SQL Server 2008 server about every 5
seconds I get the following 2 messages in the Application Event log: "Setting
database option COMPATIBILITY_LEVEL to 100 for database ReportServer." and
"Setting database option COMPATIBILITY_LEVEL to 100 for database
ReportServerTempDB."

I have double-checked that the compatibility levels are correct:

name                       compatibility_level
-------------------------- -------------------
ReportServer               100
ReportServerTempDB         100

(2 row(s) affected)


Any ideas on how I can fix this situation? Thanks.

Hi Kelly,

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/474f0c72-95b0-4fe3-8f3c-b7b7e500bd4f


Take a look at Anthony's response in this link (see last entry).  This is
what he stated:


"I got this error and ignored it till I couldn't stand not knowing.... so I
poked around and I stopped it by changing the start up logon for reporting
services service from Network Services to Local System.
I had joined the SQL box to a domain and I'd read something about the SQL
box not liking Network Services after that.
I had changed the other services but the reporting services was starting ok.
Like I said, changing it to Local System stopped the attempts to change it
immediately (it was already at level 100).


Anthony"

Hope this helps.

Regards,

Jelle




Show quoteHide quote

Creating a table on a particular filegroup?
FlatFile Encryption using FILESTREAM
To UDF or not to UDF
Updation of data in Active/Active cluster
Moving SQL 2000 Database to SQL 2005
Newbie question Im afraid
Syntax Error near select.
Transfer Data in Code
Can we implement resource limitation for specific SQL2005 database
SQl database list quetion