Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Change instance name to computer name

Author  Topic 

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2010-02-14 : 06:19:34
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

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-14 : 06:33:34
I have googled this:
http://sqldbpool.wordpress.com/2008/09/03/how-to-change-sql-server-instance-name/


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2010-02-14 : 06:54:40
well it dosent help
beacuse when i check the server prpoerties nothing has changed
beacuse of connections that still exist, and i cant drop them
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-02-15 : 01:19:29
if it's a default instance, you don't need to do anything. if it's a named instance, the application needs to change
Go to Top of Page
   

- Advertisement -