I have a 6.5 database where the tables are assigned to another user other
then sa. I have tried using the upgrade wizard but I keep getting errors
saying that user is not in the master database and the upgrade my fail (I
know this user has access to everything and is in the master database and
everywhere else I could possibly put it) so I go ahead with the upgrade and
it doesn't bring in any of the tables. I've tried installing both 6.5 and
2000 on 1 machine and doing it that way and also on another machine over a
network and bot have not worked. I was going to upgrade to 7.0 then go to
2000 thinking this would be easier but I cannot find the 7 cd so I'm kind of
stuck. I also tried changing ownership from this user to sa but that won't
work since it wont let me change that. Anyone have any helpfull hints or know
a way I can upgrade?

Hello Kyriacos!
Do you get the error "The following logins are missing from master"? In
order to isolate this issue, can you please help collect some information?

1. Take a backup of your 6.5 DBs before proceeding.
2. Open up a Query Analyzer in the 6.5 server and execute this:

use <dbname>
sp_change_users_login report

3. Paste the output of the above command; this should indicate orphaned
users in

Thanks!

Arvind.

--
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
This posting is provided "AS IS" with no warranties, and confers no rights.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-

"Kyriacos" <Kyriacos (AT) discussions (DOT) microsoft.com> wrote