Renaming an Instance

Question

Renaming an Instance

yaip

SSCrazy

Points: 2656
More actions
July 28, 2005 at 7:40 am

#86969

I have a SQL Server 2005 install. While installing, it was named as ServerName/Dev. Is it possible to have it renamed just to ServerName (without the instance name)?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

instances can only be dropped; they cannot be renamed.

uninstalling all versions of sql server, and then installing sql2005 will allow you to install sql20005 as the defaul instance.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!