logins missing problem with 6.5 to 7.0 upgrade

Hi,
I'm getting the following error when upgrading from 6.5 to 7.0.
" The following logins are missing from master, so your upgrade may fail. It
is highly recommended that you verify that all your 6.x sysusers have valid
syslogins in master. "
I assume that the prob is because the sql 6.5 server being upgraded has
several logins which are assigned to an alias (within the NRGDB database),
instead of a username.
Any help on the best way to go about resolving this would be appreciated.
Thanks,It has been a LONG time since i did a 6.5 upgrade but if I remember
correctly you can not just upgrade the logins. I think you must recreate
them or reset their passwords. Maybe this will help:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp
--
Andrew J. Kelly
SQL Server MVP
"LP" <londonpora@.yahoo.co.uk> wrote in message
news:%23jKq%232hSDHA.2152@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I'm getting the following error when upgrading from 6.5 to 7.0.
> " The following logins are missing from master, so your upgrade may fail.
It
> is highly recommended that you verify that all your 6.x sysusers have
valid
> syslogins in master. "
> I assume that the prob is because the sql 6.5 server being upgraded has
> several logins which are assigned to an alias (within the NRGDB database),
> instead of a username.
> Any help on the best way to go about resolving this would be appreciated.
> Thanks,
>
>|||It caused by upgrade process doesn't include the SQL login
account. The user account stored in sysusers of user DB
will be transfer into upgraded DB but the user account
stored into syslogin of master DB didn't transfer into new
upgrade.
Try sp_change_users_login.
I am not sure the name of SP. something like that.
Good Luck.
>--Original Message--
>Hi,
>I'm getting the following error when upgrading from 6.5
to 7.0.
>" The following logins are missing from master, so your
upgrade may fail. It
>is highly recommended that you verify that all your 6.x
sysusers have valid
>syslogins in master. "
>I assume that the prob is because the sql 6.5 server
being upgraded has
>several logins which are assigned to an alias (within the
NRGDB database),
>instead of a username.
>Any help on the best way to go about resolving this would
be appreciated.
>Thanks,
>
>.
>