rename machine name

Hi,
After installing SQL 7, I rename the server machine name from A to B. I run
the setup and change server name. The server name shows B when using selec
t @.servername. But, in SQL log file, there is one line still show the old n
ame
Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'A'.
What's the reason for that? Thanks.
Yulingsp_dropserver oldname
sp_addserver newname, LOCAL
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Yuling" <anonymous@.discussions.microsoft.com> wrote in message
news:FA945477-ADF0-4A31-96DA-CAC304CC9547@.microsoft.com...

quote:

---

> Hi,
> After installing SQL 7, I rename the server machine name from A to B. I

---

run the setup and change server name. The server name shows B when using
select @.servername. But, in SQL log file, there is one line still show the
old name

quote:

---

> Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'A'.
> What's the reason for that? Thanks.
> Yuling

---

|||Look at question 5 in the following article:
195759 INF: Frequently Asked Questions - SQL Server 7.0 - SQL Setup
Basically you have to do the following:
Open the SQL Server Network Utility. Select Multiprotocol and
click on Remove. Click Add and select Multiprotocol from the list on the
left
hand window. This should now display the correct servername. Once
Multiprotocol is added, restart the SQL Server service and this should
correct
the problem.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql