Moved SQL Server 2000 to 2005 and login is not attache

I recently moved a SQL Server 2000 server to 2005 and I cannot drop
the user. One of the issues is that the user does not have a login. I
tried to do an Alter USer but it's not sticking.
How can I add a login to an already created user?Check out sp_change_users_login in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<axwack@.gmail.com> wrote in message
news:1177599478.863706.29390@.s33g2000prh.googlegroups.com...
I recently moved a SQL Server 2000 server to 2005 and I cannot drop
the user. One of the issues is that the user does not have a login. I
tried to do an Alter USer but it's not sticking.
How can I add a login to an already created user?|||ok do this.
use mydatabase
EXEC sp_change_users_login 'Report'
This outputs the users that are orpohaned.
Now run this to fix the user
Sp_change_users_login AUTO_FIX, myusername
This will get you going again.
John Vandervliet...
"axwack@.gmail.com" wrote:

> I recently moved a SQL Server 2000 server to 2005 and I cannot drop
> the user. One of the issues is that the user does not have a login. I
> tried to do an Alter USer but it's not sticking.
> How can I add a login to an already created user?
>

Moved SQL Server 2000 to 2005 and login is not attache

I recently moved a SQL Server 2000 server to 2005 and I cannot drop
the user. One of the issues is that the user does not have a login. I
tried to do an Alter USer but it's not sticking.
How can I add a login to an already created user?
Check out sp_change_users_login in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
<axwack@.gmail.com> wrote in message
news:1177599478.863706.29390@.s33g2000prh.googlegro ups.com...
I recently moved a SQL Server 2000 server to 2005 and I cannot drop
the user. One of the issues is that the user does not have a login. I
tried to do an Alter USer but it's not sticking.
How can I add a login to an already created user?
|||ok do this.
use mydatabase
EXEC sp_change_users_login 'Report'
This outputs the users that are orpohaned.
Now run this to fix the user
Sp_change_users_login AUTO_FIX, myusername
This will get you going again.
John Vandervliet...
"axwack@.gmail.com" wrote:

> I recently moved a SQL Server 2000 server to 2005 and I cannot drop
> the user. One of the issues is that the user does not have a login. I
> tried to do an Alter USer but it's not sticking.
> How can I add a login to an already created user?
>