Thanks! Jeff. That is good to know. Save me a lot of worries. 😉

How big is the DB?

SSE has a DB size limit of 4GB.

It worked perfectly.

At the beginning, I didn't have the SAMPLE reports installed. So I had to go to http://codeplex.com/SqlServerSamples get the msi and installed.

Following the steps in the link MR.Itch...

Thank you, Mr.Itch. I will try it and report back how it goes.

Try this in your command line...

NET START MSSQLSERVER /c /m

which will start SQL in single user mode

Note: For default instance its MSSQLSERVER, for named instance its MSSQL$instancename

Once you have created the logshipping for a pair of Databases: DB1(on Primary Server [PS]) and DB2(on Secondary Server [SS]), there will be 1 T-log backup job created on...

I would check the schemas for each table involved in the query to see which column in which table could be the problem.

I would check to make sure the domain user has the right permission on the local server.

Sorry, I misunderstood your issue. I thought you couldn't connect to the server through domain.

So, it is about your SQL services. You mean, now your SQL service is Up and...

Go to Surface Area confiiguration, and check what is the remote connection protocal, make sure it is TCP/IP.

Then go to Service configuration, network protocol configurations> ensure the TCP/IP are...

Did an online search and found Paul Randal's blog.. It suggests to check Space issue among others. Here is the link.

http://www.sqlskills.com/BLOGS/PAUL/post/Database-snapshots-when-things-go-wrong.aspx

Just a wild guess:

is it possible that the files you are trying to access are also part of some other good DBs?

Are you able to open the files...

First of all, to PREVENT this from happening gain, please PUT the DBs into FULL recovery mode and Schedule Regular Transcatinal LOG backup.

Secondly, as your DB is in simple recovery...

Go to your SQL BOX ,

ALL Programs==>>Microsoft SQL Server 2005==>Configuration tools==> SQL Server Configuration Manager,

make sure the SQL Reporting Service is Up and running.

If that is running, that...

Thanks for the clarification, Jeff.

That is a big relief.