Create the bmssa user on new server without giving it access to the
database.
Next, execute the following sp from Query Analyzer on the database.
This maps the old bmssa-user to the new one.
sp_change_users_login 'update_one', 'bmssa', 'bmssa'
For more see:
Microsoft Knowledge Base-article � 274188: "Troubleshooting Orphaned
Users" Topic in Books Online is Incomplete -
http://support.microsoft.com/default.aspx?kbid=274188
Regards,
Mikael
--- In [email protected], hilda cabrejos
<[EMAIL PROTECTED]> wrote:
>
>
> Hello everybody, happy New Year
>
> We have the following problem; we did a transfer of DB SQL SERVER
2000 from one server to another, when it is doing the transfer it
says it has failed because de user bmssa in the destiny server
doesn't exist.
>
> We have done the following we do a restore of the DB in another
server that has another server name and when the restore finishes,
we try to enter AXAPTA and get an error because bmssa does not
exist. After the restore in the table SYSUSER we find the user
bmssa that has not been created in the new restored DB and in the
security, login. When we try to create bmssa he doesn't let us.
>
>
>
> What are we doing wrong?
>
> Thank you for any help
>
>
>
> Hilda Cabrejos
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage less.
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
