Can I change SQL Server name?

First. Usually, SQL Server name is equal to computer name. Can I change SQL
Server name? So example: My computer name is ADIW, But SQL Server name is
ALI.
Can I do like it?
Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?Hi,
Login into sql server using Query Analyzer and execute below commands,
sp_dropserver <old server name>
go
sp_addserver <newserver name>,local
After this stop and start sql server service
2. From SQL 2000 onwards you can install 16 instances of sql server in the
same machine. Each of the installation is independant of itself.
First installation will be default and the rest will be of named
installation. For Named instances the server name will be prefixed with a
Name.
This will allow all the sql server services to run in parellel.
Thanks
Hari
SQL Server MVP
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:eoXn92QVFHA.3444@.TK2MSFTNGP10.phx.gbl...
> First. Usually, SQL Server name is equal to computer name. Can I change
SQL
> Server name? So example: My computer name is ADIW, But SQL Server name is
> ALI.
> Can I do like it?
> Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?
>|||1: http://www.karaszi.com/SQLServer/in...server_name.asp
2. Yes. Install several instances (run setup several times).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:eoXn92QVFHA.3444@.TK2MSFTNGP10.phx.gbl...
> First. Usually, SQL Server name is equal to computer name. Can I change SQ
L
> Server name? So example: My computer name is ADIW, But SQL Server name is
> ALI.
> Can I do like it?
> Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?
>sql