CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Cesar Ivan Ardila Vega
Cesar Ivan Ardila Vega

Reputation: 81

CHANGE SERVER NAME IN SQL SERVER 2008

Can someone help me to change the server name in sql server 2008 please.

In this picture you see the server called SERVIDOR1

enter image description here

And if you query select @@servername you see the name I want. How can I change the first one ?

enter image description here

Why are they differents? I need to change the first name you see in first pic

Thanks so much

Upvotes: 0

Views: 916

Answers (1)

sepupic
sepupic

Reputation: 8687

You have 2 different SQL Server instances, one is default instance, you see it as SERVIDOR1 (that is your host name), the second is named instance: SERVIDOR1\SQLEXPRESS.

You cannot change the name of default instance as well as you cannot have 2 default instances on 1 pc, so if you want to get rid of the first instance you can uninstall it.

You can see both instances in the Configuration Manager or in Windows Services.

Upvotes: 1

Related Questions