<div>
You will need to run sp_dropserver, and sp_addserver with IP Address.<br />
<br />
I have not tried with IP Address but I don't see why it would not work.<br />
<br />
See MS kb:<br />
<br />
<a href="http://support.microsoft.com/kb/303774" rel="ugc nofollow">http://support.microsoft.com/kb/303774</a>
</div>


You will need to run sp_dropserver, and sp_addserver with IP Address.

I have not tried with IP Address but I don't see why it would not work.

See MS kb:

http://support.microsoft.com/kb/303774 [http://support.microsoft.com/kb/303774]

<div>
Hi,<br />
<br />
The SQL Server name reflects the name of the server in the OS.<br />
<br />
In fact, changing the OS server-name creates issues for SQL.<br />
<br />
In SSMS I believe that you can specify different connect to name and display name in the registered servers. This is possibly a low-impact way of achieving your goal.<br />
<br />
HTH<br />
&nbsp; David
</div>


Hi,

The SQL Server name reflects the name of the server in the OS.

In fact, changing the OS server-name creates issues for SQL.

In SSMS I believe that you can specify different connect to name and display name in the registered servers. This is possibly a low-impact way of achieving your goal.

HTH
  David

<div>
<div class="content wysiwyg-content">
I have a remote server, whose ip is 172.16.3.17.<br />
I have Sql Server installed in it, the servername is shown as ADMISSIONCELL<br />
Can &nbsp;i change its name to 172.16.3.17
</div>
</div>


I have a remote server, whose ip is 172.16.3.17.
I have Sql Server installed in it, the servername is shown as ADMISSIONCELL
Can  i change its name to 172.16.3.17

How to change the servername in sql server.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.