Re: SQL 6.5 - 2000 Problems

From: Arvind Shyamsundar_MSFT (arvindsh_at_online.microsoft.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 18:54:42 +0530

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@discussions.microsoft.com> wrote in message 
news:6A54F68A-98A6-4BAF-9B97-0ECF52311914@microsoft.com...
>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?

Relevant Pages

  • RE: URGENT: Please help upgrade SQL 7 STD to SQL 2000 STD
    ... I noted that in the master database there are some tables called: ... We tried to upgrade our SQL 7 server to SQL 2000. ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrading the Schema Master - [WildPacket]
    ... And I WILL FIRST upgrade the DC in local.com which has SM and DNM roles. ... One Domain Name Master ... One RID Master ... One PDC Emulator ...
    (microsoft.public.windows.server.active_directory)
  • Re: Upgrade-Desaster
    ... und den dann zum Master zu machen? ... Btw, den ex6er kann ich ohne Probleme plätten, den 4.11er und dessen NDS ... Das Upgrade ist absolut fehlerfrei durchgelaufen? ... Oder muss das auf die SELBE Hardware? ...
    (de.comp.sys.novell)
  • cron.daily: "Target log not found in binlog index"
    ... Irgendwann ist dann die Platte voll. ... Vor dem Upgrade auf 4.1 lief das problemlos. ... Googeln erbrachte nichts über die Bedeutung der Fehlermeldung, noch was zu tun ist, um das Problem zu beseitigen; nur Listen von Fehlermeldungen ohne Erklärung und unbeantwortete Fragen. ... Kann ich mit RESET MASTER oder PURGE MASTER LOGS hier etwas erreichen, obwohl es sich ja nicht um einen Mysql-Master handelt? ...
    (de.comp.datenbanken.mysql)
  • RE: master DB users
    ... (No user other than DBA should be allowed to access the master database). ... explicitly to database users in master, except those that SQL Server ... Those that are not in the sys schema ...
    (microsoft.public.sqlserver.security)