Renaming a SQL server

I am installing the database component to MOM. I do not
believe my question will require any MOM knowledge, but
just pointing this out up front.
The MOM install dies with a message which says
(paraphrase) "this machine has had it's name changed.
please fix and rerun setup".
The machine has never had it's name changed. It *WAS*
upgraded from sql7, though, if thats important. This box
is sql2k and hums along every day without incident.
Still, I followed all the renaming documents I could get
my hands on. Everything appears AOK, and is still
working fine, however I get that message from MOM install
nonetheless.
Any tips and/or advice? I crossposted in the MOM
newsgroups, but I'm hoping this is something which is
just SQL specific..
Thanks in advance :)I suggest you ask this in a MOM group. (I assume you have fixed master..sysservers in SQL Server.)
Only the MOM people can answer to why MOM things that there was a rename and when you found out
where MOM get this info from, you can probably fix it.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon" <forlornpotato@.hotmail.com> wrote in message news:00af01c395ae$8564f4e0$a601280a@.phx.gbl...
> I am installing the database component to MOM. I do not
> believe my question will require any MOM knowledge, but
> just pointing this out up front.
> The MOM install dies with a message which says
> (paraphrase) "this machine has had it's name changed.
> please fix and rerun setup".
> The machine has never had it's name changed. It *WAS*
> upgraded from sql7, though, if thats important. This box
> is sql2k and hums along every day without incident.
> Still, I followed all the renaming documents I could get
> my hands on. Everything appears AOK, and is still
> working fine, however I get that message from MOM install
> nonetheless.
> Any tips and/or advice? I crossposted in the MOM
> newsgroups, but I'm hoping this is something which is
> just SQL specific..
> Thanks in advance :)

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

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 select @.servername. But, in SQL log file, there is one line still show the old nam
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=djq&as_ugroup=microsoft.public.sqlserver
"Yuling" <anonymous@.discussions.microsoft.com> wrote in message
news:FA945477-ADF0-4A31-96DA-CAC304CC9547@.microsoft.com...
> 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
> 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.

Removing the \SQLEXPRESS instance name on Dell laptops

I am installing SQL 2005 Express on several laptops (IBM Thinkpads and Dell latitudes) and I've noticed that doing the exact came configuration options with the exact same file, the IBM thinkpads just take the Machine name for SQL Server, while the Dells take Machinename\SQLEXPRESS. I am wondering how I can get it to just take the machine name on the Dells.

Thanks a lot

You might want to take a look at what's already installed on those laptops before you install SQL Express. I know that on our Dell servers there's an application called IT Assist, which uses a local SQL Server database. Dell may have already installed SQL Express on those laptops for this application, and it's using the default instance. Then, when you install SQL Express, the default instance is already used, so it installs the named installed you've identified.|||I believe I have removed all traces of anything SQL Server related that I could find as far as the add or remove programs, but I will take a look at the IT assist as well. Thanks a lot.

Removing the \SQLEXPRESS instance name on Dell laptops

I am installing SQL 2005 Express on several laptops (IBM Thinkpads and Dell latitudes) and I've noticed that doing the exact came configuration options with the exact same file, the IBM thinkpads just take the Machine name for SQL Server, while the Dells take Machinename\SQLEXPRESS. I am wondering how I can get it to just take the machine name on the Dells.

Thanks a lot

You might want to take a look at what's already installed on those laptops before you install SQL Express. I know that on our Dell servers there's an application called IT Assist, which uses a local SQL Server database. Dell may have already installed SQL Express on those laptops for this application, and it's using the default instance. Then, when you install SQL Express, the default instance is already used, so it installs the named installed you've identified.|||I believe I have removed all traces of anything SQL Server related that I could find as far as the add or remove programs, but I will take a look at the IT assist as well. Thanks a lot.