-3

I Installed MS SQL 2008 R2 Express And Plesk 11 MS SQL Hostname is ".\MSSQLSERVER2008" Right Now !

I Want Change it to "localhost"

Can U Help Me ?

Mehrpouyan Co.
  • 1
  • 2

1 Answers1

4

That's not the host name, it's the instance name.

".\" is shorthand for localhost, so you've actually got what you want already. The instance name is what comes after the ".\", in this case MSSQLSERVER2008. So what you're asking is to change the instance name, leaving you with localhost\localhost which makes no sense.

So to explain further, what you've got there is a connection string with the following format

<servername>\<instance name>

e.g.:

localhost\mssqlserver2008

For more information on instance names, take a look at this question and answer. If you still want to change the instance name, as far as I know there is no reliable method of doing so without re-installing and picking the right name during the installation process, as discussed in this question and answer on our sister site for database admins.

Community
  • 1
Rob Moir
  • 31,664
  • 6
  • 58
  • 86
  • Thanks,But I have Another Windows Server 2003 + MS SQL 2008 That Server Name For Conection String iS : localhost i want users use localhost for MS SQL Server in connection stroing – Mehrpouyan Co. Nov 03 '12 at 15:26
  • 1
    Then change the connection string. As you've been told, ".\" and "localhost\" and "servername\" are the same thing. As is "ip address\" and "FQDN\". – joeqwerty Nov 03 '12 at 15:37
  • 1
    You're confusing the addressing of the application layer with the underlying identity of the server. For instance, you can call me Joe, or Joseph or Mr. Webster but you're still talking to me by using any of those and I'll respond to any of those methods of addressing me. – joeqwerty Nov 03 '12 at 15:41
  • As @joeqwerty says, if you want to change ".\" to "localhost\" then go right ahead. – Rob Moir Nov 03 '12 at 16:12
  • i want change "localhost\mssqlserver2008" or ".\mssqlserver2008" to "localhost" – Mehrpouyan Co. Nov 03 '12 at 16:19
  • What you're asking is to rename the SQL instance "MSSQLSERVER2008" to the default instance "MSSQLSERVER". – gigaplex Feb 04 '15 at 00:54