Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have already installed sql server 2008 express and ssms on my vm... now I am trying to install ssrs on the same machine and keep getting "database engine error". Should I skip this (click here please)

I have tried to uninstall and reinstall several times... even with administrator's mode, I get that error.

share|improve this question
    
Are you trying to install SSRS 2008 or a different version like 2008 R2? Is 2008 Express installed as a default instance or with an instance name like "SQLEXPRESS"? –  darin strait Oct 8 '12 at 20:56
    
Hey Darin..yes, 2008 express is installed as a default instance as "SQLEXPRESS"... I am trying to create another instance "MSSQLSERVER" for SSRS from SQL Server 2008 R2 –  EagleFox Oct 8 '12 at 20:58
    
The "default instance" is generally the one with no name. "default instance" doesn't mean "only one on the box". To make it more worse, sometimes MS refers to the unnamed instance as "MSSQLSERVER". I'm guessing that the SSRS instance that you are naming "MSSQLSERVER" is looking for a default instance of SQL (to store the SSRS metadata) I would try installing SSRS as SQLEXPRESS and see what happens. To be fair, I've never run SSRS on SQLEXPRESS, but some pages over at MSS seem to indicate that it works, with some caveats (like no scheduled reports because there is no SQL Agent). –  darin strait Oct 8 '12 at 21:12
    
that makes a lot of sense Darin... I am trying that now... will let you know how it goes. –  EagleFox Oct 8 '12 at 21:19
    
Thanks Darin... I reinstalled in as SQLEXPRESS and didn't get any errors, however I had to manually configure SSRS after installation... thanks a bunch.... now how do I mark this question as 'answered'? –  EagleFox Oct 9 '12 at 12:52

1 Answer 1

up vote 0 down vote accepted

(I am summarizing the comments in this answer so that it can be accepted. Thx.)

The "default instance" is generally the one with no name. "default instance" doesn't mean "only one on the box". To make it more worse, sometimes MS refers to the unnamed instance as "MSSQLSERVER". I'm guessing that the SSRS instance that you are naming "MSSQLSERVER" is looking for a default instance of SQL (to store the SSRS metadata) I would try installing SSRS as SQLEXPRESS and see what happens.

To be fair, I've never run SSRS on SQLEXPRESS, but some pages over at MSS seem to indicate that it works, with some caveats (like no scheduled reports because there is no SQL Agent).

After installing SSRS, you may still need to manually configure SSRS.

share|improve this answer
    
Thanks Darin... this actually saved me a lot of headache –  EagleFox Oct 12 '12 at 15:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.