How to change SQL Server 2005 instance name

Hi,
I have installed SQL Server 2005 Express Edition on my system. The default instance name is set as SQLEXPRESS. I want to change this to something else. Is there anyway I can do that?
Thanks,
pravi

Hi Pravi,

here is a reference material for renaming a Server / Instance

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

HTH

Hemantgiri S. Goswami

|||

hi Pravi,

named instances can not be renamed...

regards

How to change from Windows to SQL Server Authentication?

Hi

I want to know how can I change Login from Windows Authentication to SQL Server Authentication. I'm using SQL Server Express Edition and SQL Server Management Studio Express to connect to the Sql Server. I selected Windows Authentication during the installation of the SQL Server Express and now i want to cahnge to SQL Server Authentication using sa account.

Your help will be highly appreciated.

1. In Object Explorer choose Properties for your SQL Server instance. Then choose "Security" tab and check "SQL Server and Windows Authentofocation"

2. Enable sa login, because it's disabled by default

|||Thank you Konstantin.

How to change default database 'root directory' ?

Hi folks,

Can you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. ?

Currently its configured to:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
and I want to change the drive letter here.

Thanks in advance.
Cyk

-- Try this:

declare @.SmoRoot nvarchar(512)
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT

print 'Old root dir: '+ @.SmoRoot

set @.SmoRoot = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL'

exec master.dbo.xp_instance_regwrite
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,REG_SZ
,@.SmoRoot

exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT

print 'New root dir: '+ @.SmoRoot

-- Bo

sql

How to change default database 'root directory' ?

Hi folks,

Can you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. ?

Currently its configured to:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
and I want to change the drive letter here.

Thanks in advance.
Cyk

-- Try this:

declare @.SmoRoot nvarchar(512)
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT

print 'Old root dir: '+ @.SmoRoot

set @.SmoRoot = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL'

exec master.dbo.xp_instance_regwrite
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,REG_SZ
,@.SmoRoot

exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT

print 'New root dir: '+ @.SmoRoot

-- Bo