Wednesday, March 28, 2012

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

No comments:

Post a Comment