Changing Instance name

Does anyone know how to change the instance name on an installed server short of reinstall?

Scenario

We are about to deploy 20 2K5 servers. We can not deploy them remotely. We will send install disks into the field and use local network support tech to do the work. Currently, the servers are running 2K. We will be running a side-by-side upgrade to insure minimal down time.

Since this is a side-by-side upgrade, a second instance name is required. If our techs typo the required name our client apps will not be able to connect.

We can run a script remotely if we need to but can it be done?

Did you try Upgrade Advisor? Why Upgrade is not an option for you. Upgrading 20 servers 1 at a time is painful but not as painful as what you are trying to do.

Thanks

Raja

|||And the direct reply to your first question is that while we provide a way to deal with server renames, we don't allow instance renames. :(

Changing from Windows Authentication to Mixed Mode?

Is there a way to change from Windows Authentication mode to Mixed
Mode on SQL Server 2000 without having to reinstall it?
Thanks,
Ed B.
buch75@.comcast.net
Yes. EM, right-click your server, properties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ed B." <buch75@.comcast.net> wrote in message
news:51aac685.0410070933.18bb5234@.posting.google.c om...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net
|||Of course, go to Enterprise Manager, then go to the SQL Server Properties
then go to Security and change the option over there.
After aplying that you must restart the SQL Server.
--
Roberto Rodrigues
Consultor Tcnico
Dep. Tcnico
Sofistica - Solues Informticas, Lda.
WWW.SOFISTICAPORTUGAL.COM
"Ed B." <buch75@.comcast.net> escreveu na mensagem
news:51aac685.0410070933.18bb5234@.posting.google.c om...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net

Changing from Windows Authentication to Mixed Mode?

Is there a way to change from Windows Authentication mode to Mixed
Mode on SQL Server 2000 without having to reinstall it?
Thanks,
Ed B.
buch75@.comcast.netYes. EM, right-click your server, properties, security.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ed B." <buch75@.comcast.net> wrote in message
news:51aac685.0410070933.18bb5234@.posting.google.com...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net|||Of course, go to Enterprise Manager, then go to the SQL Server Properties
then go to Security and change the option over there.
After aplying that you must restart the SQL Server.
--
--
Roberto Rodrigues
Consultor Técnico
Dep. Técnico
Sofistica - Soluções Informáticas, Lda.
WWW.SOFISTICAPORTUGAL.COM
"Ed B." <buch75@.comcast.net> escreveu na mensagem
news:51aac685.0410070933.18bb5234@.posting.google.com...
> Is there a way to change from Windows Authentication mode to Mixed
> Mode on SQL Server 2000 without having to reinstall it?
> Thanks,
> Ed B.
> buch75@.comcast.net