>><When i attempt to connect to the database engine is it local >>"database engine " or remote sql server?

I am trying to access the sql engine on the same server...

>> make sure that you open port for MSDTC

I checked and the DTC is enabled.

Marc

>>did you install sp1 for sql server 2005 ? what it's version\edition?

Here is the "about" info from management studio.

Microsoft SQL Server Management Studio      9.00.2047.00

Microsoft Analysis Services Client Tools      2005.090.2047.00

Microsoft Data Access Components...