Change instance name to computer name

Question

Change instance name to computer name

peleg

SSCrazy

Points: 2611
More actions
February 14, 2010 at 4:20 am

#219114

i am trying to install a system which ask for :
"The instance name must be the same as computer name."
the current server of the Sql Server is "SQL Server (AML)"
how can i change it, so the sql server will run under the computer name and not under the instance name (AML)
Thnaks
Peleg

Viewing 4 posts - 1 through 3 (of 3 total)

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

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

Would you not just install a Default instance for SQL server... The SQL Server instance is then referenced using the server name?

Gethyn Elliswww.gethynellis.com

Luzi62 Ten Centuries Points: 1218 More actions · Answer 2

Hi,

easiest way would be to define a client alias.

http://msdn.microsoft.com/en-us/library/ms190445.aspx

regards

Steve Jones - SSC Editor SSC Guru Points: 736479 More actions · Answer 3

I'd suggest two things.

1) set your instance to use 1434, move a default instance to another port

2) set a DNS entry with an FQDN to point clients to the server. If you have a DNS server, even for the internet, you can add an internal entry for a new host.