Thanks, I was concerned about the 2GB memory restriction with Windows standard edition.

Ultimately, I want SQL 2005 to be able to address all the RAM in the machine.

Yes I did.

The solution is to go to connection properties and re-enter the password for each registered server.

thanks,

Thanks for the reply.

Yes, move the application to a different physical new server.

We usualy keep the old server around for a week in case of any major issues.

thanks again.

Do you run user database integrity checks through SQL maintenance plans or through scripts?

I guess scripting is a work around to not installing the critical patch 3054 (KB934458)

Microsoft is confusing. I install SP2 and I see 3042 as the build. I can't run integrity checks, so I apply a hotfix that brings it up to...

Thanks, do you have the link so I can check it out?

Thanks again.

Is there anyone else using Citrix Presentation Server 4.x?

Thanks for responding so quickly! Is SP2a level 9.00.3154? That is what I have for all my databases so far except for this Citrix new install. We...

Thanks all, I downloaded it.

We are using a maintenance plan. I think the issues is the SP2 release. I think I need the hotfix to correct the maintenance plan bug.

Just can;t seem...

Great, thank you.

I just installed per vendor request Windows only authentication for SQL 2005. I no longer have access to 'sa' user.

Is there a way to change the authentication without re-installing?

After a SQL 2005 install, Is there a way to change the authentication from Windows only to Mixed?

I noticed my sa is not useable anymore.

Thanks for keeping the post active. I would be interested in hearing from others on how they approach the changes to VMWare.

Great, thank you.