7.0 Upgrade Wizard doesn't like hyphens in server name 
Author Message
 7.0 Upgrade Wizard doesn't like hyphens in server name

Just discovered that the 7.0 Upgrade Wizard chokes when the export server
name contains a hyphen (eg, NPSI-SERVER2). I presume the "export" server
means the 7.0 target, although the error message isn't clear. The message
is:


I tried running (per the error message):

    sp_setnetname 'NPSI-SERVER2'  'NPSI-SERVER2'

on the hunch that maybe there was no "netname" defined, but that didn't
help, as I expected.

I thought that the MS SQL developers had fixed the problems with handling of
hyphens a long time ago. Apparently, someone didn't get the message.

SQL7 setup  didn't complain about the server name, nor does Enterprise
Manager, etc, etc.  So why does the Upgrade Wizard?

And how do I upgrade until this is fixed?

(and no, I'm not going to change the server name to underscores, because
then the servername and DNS names would be different...DNS doesn't allow
underscores, per the RFC).

David Thom
NPSi Houston



Sat, 29 Sep 2001 03:00:00 GMT
 7.0 Upgrade Wizard doesn't like hyphens in server name

Quote:

>Just discovered that the 7.0 Upgrade Wizard chokes when the export server
>name contains a hyphen (eg, NPSI-SERVER2).

A call to MS resolved the problem:

The "export" server in the error message refers to the 6.5 server, not the
7.0 server (7.0 supports hyphens OK).

The problem is that the 6.5 servername contained the hyphen. To resolve the
problem, I used the 6.5 Enterprise Manager to drop the 6.5 server
(sp_dropserver), then added the server back with an underscore in the name
(rather than a hyphen), then defined a "server net name" with the hyphen.

Then, the upgrade wizard ran OK.

David Thom



Mon, 01 Oct 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. 7.0 Upgrade Wizard dies on servername containing hyphen

2. 6.5 to 7.0 Upgrade: 7.0 doesn't contail all objects from 6.5

3. SQL 7 Upgrade Wizard doesn't start SQL65

4. can't query server with hyphen in name

5. SQL Server Upgrade Wizard - SQL Server 7.0

6. Doesn't like '-'s in server name

7. PB7.02 upgrade DOESN'T FIND PB 7.0

8. 4851 4852 while using upgrade wizard - sql server 7.0

9. problem upgrading more than 1 server with sql server 2000 upgrade wizard

10. SQL Server 7.0 Upgrade Wizard

11. SQL Server Upgrade Wizard 6.5 to 7.0


 
Powered by phpBB® Forum Software