I have included attachments of sceenshots of the errors received from my application and from Enterprise Studio. It trully is amazing what you can learn when you read furtheron....

Thanks to All for your replies,

I solved my problem. I had to create a new instance with a different name for my SQL 2005 databases. I now have...

Thanks. I looked at my start menu and MS SQL Server still has everything. MS SQL Server 2005 only has Analysis Services, Configuration Tools, Documentation and Tutorials, Performance...

My server version is still 2000.080.2039.00 when I did the upgrade I thought it would go to 2005.090.1399.00 like my other server. However, it did not. With Microsoft...

Thanks, I'll try it.

Rick

Thanks for your reply.

What I did was Upgrade my SQL 2000 server to SQL 2005 expecting that the database engine would upgrade form 80 to 90 compatibility mode....

Thank you. that helps with the databases, but as you can tell, I am relatively new to this and know enough to be dangerous but am not competent. ...

What I want to do is setup a 90 (instance) so that I can restore the 90 databases. I can migrate my 80 databases to it if I have...

Thanks Andras. I am OK with the 80 databases. It's the 90 databases I cannot restore to my 80 instance. What I want to do is migrate...