SQL Server 7.0 Upgrade Wizard 
Author Message
 SQL Server 7.0 Upgrade Wizard

Hi Gary,


it the 6.5 server or the 7.0 server? Perhaps run:
{

EXEC xp_msver

Quote:
}

although, xp_msver unfortunately (IMHO) doesn't return the box's Net BIOS
name <g>.

Also (in no particular order, and some of the following is of dubious
quality <g>), make sure:
1
The SQL Server services' startup accounts have full control of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer (and its subkeys)
2.
The SQL Server services' startup accounts have full control of the
folder(s) where the database devices reside (and full control upon those
devices AKA files).
3.
One the archive attribute (a folder Property) is checked for the Mssql\binn
and Mssql7\binn folders
4.
If first seeing a message that "databases are not recovered yet" then
please inspect the active 6.5 errorlog ( 'Mssql\log\errorlog.') to verify
that you see a logged 'recovery complete' message before attempting to
upgrade.
5.
Use sp_helplogins to ensure the sp_defaultdb for the sa account is set to
master (and opposed to a user database)
6.
Make sure there are no advanced entries (or Aliases) within the Client
Network Utility (the CNU that is upon the box where the upgrade wizard is
being run). You can temporarily cut and paste such entries into Notepad
(but these CNU entries may instead not be worth putting back after the
upgrade<g>).  Also make sure the default Net-Library is Named Pipes

Thanks,

Bill Hollinshead
Microsoft, SQL Server

This posting is provided "AS IS" with no warranties, and confers no
rights. Subscribe to MSDN & use http://www.***.com/



Sun, 15 May 2005 03:09:17 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Server 7.0 Upgrade Wizard and segments

2. SQL Server Upgrade Wizard - SQL Server 7.0

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

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

5. SQL Server Upgrade Wizard 6.5 to 7.0

6. SQL 7.0 Upgrade Wizard - resulting in suspected databases on SQL 6.5

7. 7.0 Upgrade Wizard doesn't like hyphens in server name

8. Upgrade-Wizard SQL 7.0

9. Sql 7.0 Upgrade Wizard

10. Upgrade Wizard SQL 7.0

11. Upgrade Wizard SQL 7.0


 
Powered by phpBB® Forum Software