RE: SQL Server 7.0 Upgrade Wizard
From: Bill Hollinshead [MS] (billhol@online.microsoft.com)
Date: 11/26/02
- Next message: Rob: "Copy SQL Server Logins and Passwords"
- Previous message: Magnus: "sp_executesql"
- In reply to: Gary Jones: "SQL Server 7.0 Upgrade Wizard"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: billhol@online.microsoft.com ("Bill Hollinshead [MS]") Date: Tue, 26 Nov 2002 19:09:17 GMT
Hi Gary,
Which server were you connected to when you ran SELECT @@serverneame - was
it the 6.5 server or the 7.0 server? Perhaps run:
{
SELECT @@SERVERNAME
EXEC xp_msver
}
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://msdn.microsoft.com/newsgroups.
- Next message: Rob: "Copy SQL Server Logins and Passwords"
- Previous message: Magnus: "sp_executesql"
- In reply to: Gary Jones: "SQL Server 7.0 Upgrade Wizard"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
