Thanx for all the help 🙂 It is much appreciated.

I did choose the default instance option for sql 2005...

What I actually wanted was for both instances to co-exist happily since...

Hi,

It is definitely the 2005 version of the database...installed it from the 2005 installation cd.

Kind regards

Ghoezayma

Hi,

I've also got 2 instance (2000 and 2005) installed on my machine.

And the active instance is 2000 🙁

Is there any way I can change the active instance to point to...

Hi,

I have also tried all the possible solutions mentioned (including running the instawdb.sql file) but all failed with the same error.

Any help will be greatly appreciated.

Kind regards

Ghoezayma

Hi All,

I've tried all the above mentioned ways to attach adventureworksdb for 2005 (including executing instawdb.sql) but without success 🙁

I've been struggling with this problem for a week now.

Any help...