Changing name of machine running MSDE - ISSUE??

As part of a data center migration, I am going to be changing the name of
several servers that are running MSDE. Does MSDE have the same issues with
changing the name of the system it runs on as SQL Server does?
thanks,
Jason
hi Jason,
Jason wrote:
> As part of a data center migration, I am going to be changing the
> name of several servers that are running MSDE. Does MSDE have the
> same issues with changing the name of the system it runs on as SQL
> Server does?
>
yes
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Changing Name of Host Server Box and MSDE

Please help!
I have changed the name of my Win2KAS Server box and cannot find out how to
get the MSDE MSSQLServer Service to start back up.
MSDE was installed as part of Crystal Enterprise, so I do not have ANY
source CD's to use. I cannot find a "setup.exe" file to re-run either.
Any help would be appreciated.
Thanks in advance...
Hi
What does the NT Event log say? It is a login failure, a Crystal failure etc?
Regards
Mike
"jmr" wrote:

> Please help!
> I have changed the name of my Win2KAS Server box and cannot find out how to
> get the MSDE MSSQLServer Service to start back up.
> MSDE was installed as part of Crystal Enterprise, so I do not have ANY
> source CD's to use. I cannot find a "setup.exe" file to re-run either.
> Any help would be appreciated.
> Thanks in advance...

Changing MSDE from Win NT authentication to Mixed

Hi,
is there a way to change MSDE from Win NT authentication only to Mixed mode
authentication without reinstalling and without Enterprice Manager?
Hi,
Modify the below registry key value to 2 and restart the MSSQL Server
service.
HKLM\SoftWare\Microsoft\MSSQLSXERVER\MSSQLSERVER\
LoginMode=1 (NT Autentication)
LoginMode=2 (Mixed Mode)
Thanks
Hari
SQL Server MVP
"Olav" <Olav@.discussions.microsoft.com> wrote in message
news:E2D80B73-B1BC-4FA0-94AC-D5156168DCAC@.microsoft.com...
> Hi,
> is there a way to change MSDE from Win NT authentication only to Mixed
> mode
> authentication without reinstalling and without Enterprice Manager?

Changing Machine Names MSDE

I have a local install of MSDE on my workstation. I have also defined a
linked server with another SQL Server on our network. I accepted all the
defaults when I installed MSDE and the server got named my machine name.
Everything is working great.

Our IT department now needs to change my machine name. What effect will
this have on my current SQL installation?

Help and suggestions appreciated.

Thanks,
Frank

*** Sent via Developersdex http://www.developersdex.com ***Frank Bishop (fbishop@.viper.com) writes:
> I have a local install of MSDE on my workstation. I have also defined a
> linked server with another SQL Server on our network. I accepted all the
> defaults when I installed MSDE and the server got named my machine name.
> Everything is working great.
> Our IT department now needs to change my machine name. What effect will
> this have on my current SQL installation?

If memory serves, the server name changes automatically. However,
@.@.servername usually gets messed up.

To this end to:

exec sp_dropserver 'oldname'
exec sp_addserver 'newname', 'local'

Then stop and restart SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx