Whenever you restore the database on MS SQL Server, you need to go in immediately (before starting the Remedy services) and update the ARAdmin account in SQL Server and give it dbo privileges to the restored database (whether on 2000 or 2005). We perform the backup/restore process all of the time to bring servers into sync.
You should get an authentication error message in the log if you forget to do this because the Remedy server service will not be able to log into the SQL Server. //SIGNED// Craig Carter Software Engineer, RSP ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Friday, February 22, 2008 9:39 AM To: arslist@ARSLIST.ORG Subject: Re: "Splitting" an AR 6.x system.... The ARSystem database was moved by using MS/SQL Server Enterprise Manager/Backup and Restore function. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Friday, February 22, 2008 11:00 AM To: arslist@ARSLIST.ORG Subject: Re: "Splitting" an AR 6.x system.... ** Richard, I think some detail as to how you moved the database would be helpful. Also, please don't forget you ARS and DB information. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk: 813-348-2556 Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Friday, February 22, 2008 10:54 AM To: arslist@ARSLIST.ORG Subject: "Splitting" an AR 6.x system.... One of our Remedy folks has asked me if it's possible to do something that we thought would be easy, but seems not to be - maybe we're missing a step, or ??? Our AR HelpDesk 6.x system is all housed on one server - with the SQL database instance on that server as well. We'd like to "split" off the SQL database and put it on another server, or leave the SQL instance where it is and move the AR stuff. But, when they tried changing the arconfig file it just caused the whole thing to hang. Is it possible to separate things this way, and if so are there directions/guidelines on what/how they should be doing it? Thanks!. "I know not with what weapons World War III will be fought, but World War IV will be fought with sticks and stones." Albert Einstein Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"