?
Solved

Change computer name

Posted on 2001-07-20
4
Medium Priority
?
3,062 Views
Last Modified: 2008-02-26
I'm running NT 4.0 and SQL Server 7.0.  I need to change the name of the computer.  When I do & reboot SQL Server will not start.  I tried sp_addserver, sp_dropserver, & sp_setnetname before changing the computer name but I must be missing something as it does not work.  It seems like what ever I do must be done before I change the name as once I do I can not start SQL Server.  Sort of a Catch 22.
0
Comment
Question by:Argonaut
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 2

Expert Comment

by:UncleMatt
ID: 6303911
As far as I know you can't change the computer name of a SQL server without re-installing it.

It's all in the books online somewhere.

Matt.
0
 
LVL 18

Expert Comment

by:nigelrivett
ID: 6303990
change the name
reboot - sql server will fail to start
rerun the sql server setup - installshield will say that it is upgrading the system. It will actually change all the registry entries.
Reboot the server again and everything shou be OK.
You may have to add the server name which you already know how to do.
0
 
LVL 8

Accepted Solution

by:
chigrik earned 200 total points
ID: 6304265
Read about "How do I change the name of SQL Server?"
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14155

It's there from:

"
With SQL 7.0 you will need to re-run setup to reset the server name. Setup will detect the name conflict, resolve it, and then finish.
"

Hope this helps
0
 
LVL 1

Author Comment

by:Argonaut
ID: 6305319
Thanks,

I had some problems with the CD.  It would not accept the Enterprise CD, had to use Standard CD.  I though it was Enterprise to begin with.  I know Enterprise need Win 2000 Advanced but I'm running NT 4.  Do you know what is up here?

Any way after running setup the server would start but @@SERVERNAME still returned the old name.  So I ran:

sp_dropserver <oldname>
go
sp_addserver <newname>, local

After a re-start the name was completely changed.
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differeā€¦
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question