Hi,
This is not a problem with Axapta but in Sql DataBase(orphaned users).
Steps To Resolve Orphaned Users Problem
1. Run the following command for the orphaned user from the preceding
step: Use AXDB
go
sp_change_users_login Auto_fix, 'bmssa'
This relinks the server login "bmssa" with the the AXDB database user "bmssa".
2. Executing the sp_change_users_login procedure with the optional
Auto_Fix option may create logins with a NULL password for users
without an existing corresponding login.Change the password by using
SP_PASSWORD Stored procedure.
SMitra
On Mon, 14 Mar 2005 14:41:14 -0800, Craig Fidler <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
>
> Help would be appreciated. I have a client that is running Axapta 3 with SP2
> loaded. They are running SQL patched with 3.0a.
>
>
>
> What they have done is created a new database. Taken their existing database
> backed it up and then force restored it into the new database they have
> created.
>
>
>
> Now when you backup the database and try to restore it on another server, it
> restores however as soon as you fire of the Axapta client, Axapta returns an
> error with regards the SQLSYSTEMVARIABLE table.
>
>
>
>
>
> Anyone ever have a similar problem and how would I go about fixing the
> problem?
>
>
>
>
>
> Thanks in advance
>
>
>
>
>
> Craig
>
>
>
> The views expressed in this email are, unless otherwise stated, those of the
> author and not those of the BS3 Technologies Group or its management. The
> information in this e-mail is confidential and is intended solely for the
> addressee. Access to this e-mail by anyone else is unauthorised. If you are
> not the intended recipient, any disclosure, copying, distribution or any
> action taken or omitted in reliance on this, is prohibited and may be
> unlawful. Whilst all reasonable steps are taken to ensure the accuracy and
> integrity of information and data transmitted electronically and to preserve
> the confidentiality thereof, no liability or responsibility whatsoever is
> accepted if information or data is, for whatever reason corrupted or does
> not reach its intended destination.
>
> Sharing the knowledge on Axapta.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
> ________________________________
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/Axapta-Knowledge-Village/
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
Subha Mitra
------------------------ Yahoo! Groups Sponsor --------------------~-->
Has someone you know been affected by illness or disease?
Network for Good is THE place to support health awareness efforts!
http://us.click.yahoo.com/Rcy2bD/UOnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
