Good news.

After the server was restarted, I was able to start sql server normally.

I checked the model files and they were not set to READ only.

I left it as it...

good catch.

I am trying to attach the model db from E drive before and it failed.

I did found that the modellog.ldf system handle is pointing to D drive.

How do i...

1. I ran procexp and did not see anything impacting the system.

2. I ran sql server in -f option. Still failing.

3. On another window i tried to attach the model...

i tried starting sql server manually with -f option: still the same problem.

This is the error:

2009-09-23 10:25:17.08 server Logging SQL Server messages in file 'E:\MSSQL\log\ERRORLOG'.

2009-09-23 10:25:17.09 server...

Sorry i did not provide more details.

Yes, that's the first thing i did.

The .ldf file was missing.

I copied the .ldf from another location.

still does not work.

I checked the sql log...

Works beautifully.

Thanks much.

Murali

Did that. Not seeing anything on the trace output.

Guess it is waiting for data retrieval.

Thanks

Murali

The error message i get is

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'test1'. (rsErrorOpeningConnection)

For more information about this error navigate to the report...