Hi, What Database UserId and Password u r using to login to the SQL Server? Is it Sa or standard BMSSA login? or U hv created a new DBO?
SMitra On Wed, 16 Mar 2005 11:17:52 -0800, Craig Fidler <[EMAIL PROTECTED]> wrote: > > > Using sql backup & restore functionality > > > ________________________________ > > > From: Ozanhan Anaç [mailto:[EMAIL PROTECTED] > Sent: 16 March, 2005 1:11 AM > > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: RE: [Axapta-Knowledge-Village] Sql Error > > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: RE: [Axapta-Knowledge-Village] Sql Error > > > > > > How did you get the backup file to 2nd server? I had an interesting > experience : When i move the backup file using compressing tools i get this > error, but when i move backup file directly i didnt get this error. Please > try and let me know the result > > > > Ozan > > > ________________________________ > > > From: Craig Fidler [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 16, 2005 8:34 PM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: RE: [Axapta-Knowledge-Village] Sql Error > > > > Thanks but still getting the same error > > > ________________________________ > > > From: Van Den Langenbergh Gunther > [mailto:[EMAIL PROTECTED] > Sent: 16 March, 2005 12:17 AM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: RE: [Axapta-Knowledge-Village] Sql Error > > > > try this > > > ________________________________ > > > From: Craig Fidler [mailto:[EMAIL PROTECTED] > Sent: woensdag 16 maart 2005 19:14 > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: RE: [Axapta-Knowledge-Village] Sql Error > > Still receiving this error > > > > > > > ________________________________ > > > From: Subha Mitra [mailto:[EMAIL PROTECTED] > Sent: 14 March, 2005 9:39 AM > To: Axapta-Knowledge-Village@yahoogroups.com > Subject: Re: [Axapta-Knowledge-Village] Sql Error > > > > 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 > > > Sharing the knowledge on Axapta. > > > > > Sharing the knowledge on Axapta. > > > > > > Sharing the knowledge on Axapta. > > > > > > > Sharing the knowledge on Axapta. > > > > > > 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 --------------------~--> In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/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/