Thank you free mascot,

I found that in mirroring I need to work with the Native CLient to make the application change immediately to the otehr database in case of failover....

Thanks a lot for that clarification, is more than clear now for what I should do...

Just one thing, if I have an application running with my Database, and this is...

the Internet Explorer cannot open that URL, I followed this link.....http://msdn.microsoft.com/en-us/library/ms156468(SQL.90).aspx ...but nothing change

Guys,

Which are the principal differences between mirroring and cluster?....I look them both similar, , I am working with mirroring, what if I do clauster, what things really involved?..any help??

I have...

The mirroring I implemented was for DR proposes, in Dallas my primary server, and on the Data Center the mirroring at 4 hours from here.

I am asking for clustering, because...

Thanks for all your help!

One more thing??? MSDE SP3 means that I am already under SQL 2000 EE?, or able to do just a backup/restore?

Thank you Lynn,

I was asking because one of my partners told me that I need to run queries, scripts...in order to upgrade my MSDE SP3 to SQl 2000, I didn't...

Thank you, so that means that I don't need to run any script? anything?, just because is under SP3?

It says version 8.00.760 Desktop Edition SP3.

but what happen with the version, is that, that simple? I mean, I need to upgrade from MSDE to SQL 2000, just to backup/restore ?

Hello Elisabeth,

Thank you....Yes, I need to upgrade my db from MSDE to SQL 2000, is there any way to perform this?

I have MSDE under version 8.00.760 SP3.

Thank you.

Thank you Guys, it worked, my apologies, yes I noticed this is 2005 Forum, but just after I posted this, sorry I am going to move this over it.

Thanks.

Thank you so much guys!!

It was some changes on the application, I had to deal with the Application consultants in order to let me know where I need to change...

Hi Guys,

I tried in ODBC with my domain\user, and 'sa' user and both can connect succesfully.

Also I can connect to other applications/databases running in the same server...