MSDE: Renaming machine without reinstall of MSDE

[Manfred]

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

[David Westmore]

Unfortunately, MSDE is really just a castrated version of SQL Server 7, which is well known for this problem. But it's one thing sorting out a server, quite another solving this kind of problem on many client machines.

I'm afraid you probably must reinstall....I don't understand what you mean by "can only be installed from unattended mode", are you talking about a company policy? As fas I know, you can install MSDE just by running setup.bat on a CD which contains it (MSDN, Office Developer, I think you can also download it if you have a valid license).

I won't add "hope this helps", I suppose it didn't!

Regards

David Westmore



------------
Manfred at 3/27/01 6:59:08 AM

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

[Dale Shaw]

------------
Manfred at 3/27/01 6:59:08 AM

We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??

regards,

Manfred

[Dale Shaw]

Hi

Renaming the MSDE server is not different from renaming a real SQL Server - except that you have no tools to do it with!

Firstly is that you need to obtain VSQLW from my site:

http://www.sourcecode.co.nz/vsqlw

This will let you run an SQL statements needed.

You can follow the instructions elsewhere on SWYNK and in the messages in this forum.

If you need to do lots of machines then either write a quick VB app to perform the rename tasks or use LoadSQL from my site. LoadSQL will allow you to write a script that can be run from a batch file etc.

If you need to re-install MSDE this can be easily done. The 'automated' setup is VERY easy to do and comes down to basically running a batch file that runs the MSDE setup EXE and passes an ISS file.

Dale Shaw
Auckland, New Zealand