Thanks Lynn for your response.

As you asked for the recovery model all DB' are in SIMPLE recovery.

I will look into the fragmentation issue as pointed by you.

I just want to...

Thanks for your kind suggestion.

I point here is to look for a solution if I am missing anything.

As I know how to rename the sql instance. Just sending...

Hey Jasona,

You pointed well. I tried with local service but it gave same error.

I think this m/c is renamed. Could you please help me figure out what need to be...

Hi,

The services running under local Administrator.

I am setting up some local environment that's the only reason Its not on domain. I dont want to take to domain. I hope i...

Hi,

Here is the content of the SQLAgent.out file.

2012-05-31 14:38:23 - ! [000] Unable to connect to server '13179-HP7100'; SQLServerAgent cannot start

2012-05-31 14:38:23 - ! [298] SQLServer Error: 18452, Login failed....

Hi,

There is no Kerboros there in eventviewer log

Okay will try this.

Thanks for your support and quick response.

The domain\user1 is the admin there.

This is solved some how I dont know I added my acount in local admin group on the server where the report server is installed....

Thanks for you quick response.

Please find the attached screen shot.

I tried all option but after googling I found to use store credential in report server DB. Still its not working.

The account is a domain user account.

The user have select rights which are required to populate data for the reports.

As you said even though if I create a AD group...

Okay.

Thanks a lot..

I have the backup. My question is i want to understand that error. I guess it is a page corruption error.

What you say Gail..

If posible just help to understand...

I appriciate your effort and quick responses.

Here I am posting the full output of DBCC CheckDB. Just the User Table name are edited.

DBCC results for 'XXXXX'.

Service Broker Msg 9675, State...

Yes its not the full output. But rest of the tables in that DB, the dbcc out is alright there is no such error message. There was only one table...

Thanks for a quick reply

Here is more detail of DBCC.

Table error: Object ID 1499868410, index ID 1, partition ID 72057594219397120, alloc unit ID 72057594238009344 (type In-row data). Page...