CODEWITHSUNDEEP
sqlsql-serversql-server-2005sql-default-instance
Hythloth
Hythloth

Reputation: 774

SQL Server Default Instance: If you change host machine's name

Say I have a Server named "MyServerABC", on which I have Sql Server 2005 installed with a Default Instance. Thus I can always connect to my sql server just by specifying "MyServerABC".

Now, I change my server's name to "MyServerDEF". Will I now be able to connect to the sql server by just specifying "MyServerDEF"?

Are there any holes in my thinking? Is it really that simple, or are there additional steps involved, or potential problem areas?

Upvotes: 0

Views: 8781

Answers (2)

marc_s
marc_s

Reputation: 754200

If you use the machine name to connect, you will have to change your connection strings. If that's what you are looking for, then yes, it's that easy - no additional steps needed.

That's why you can also use (local) or just "." as shortcuts for the local machine.

Marc

Upvotes: 0

gbn
gbn

Reputation: 432180

Yes, that's correct from a remote connection view if you change MyServerABC to MyServerDEF in connection strings.

There are a few more things to consider (@@SERVERNAME will not change by default for example) so have a look here: How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

Often, you'd use MyServerPermanentAlias as a network DNS entry too so the actual server name is irrelevant.

Upvotes: 4

Related Questions