Hello Listers,
I did find an old ARSList message about moving a remote SQL server DB. It really is that simple. I'm still not sure if the db account name should be dbo or ARAdmin. The old system has dbo with ARAdmin as the login name but the new account was created as ARAdmin with ARAdmin as the login. I was able to create a form so it "appears" to be functioning. Any info would be appreciated. --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Reiser, John J Sent: Thursday, August 27, 2009 11:45 AM To: [email protected] Subject: Moving a remote SQL Server DB to new hardware Hello Listers, I have an old 6.03 server that needs to have it's remote DB moved to new hardware. The DBA copied the existing database and restored it to the new SQL Server. I changed the Remote-DB line in the ar.cfg file and started up the services. All appears well, I created a test form and it shows up in the new ARSystem DB. First off I can't believe it was that easy but I do have a concern. The ARAdmin account was created as a dbowner but the account name and login name are both ARAdmin. Does it matter? Should the account name be dbo? TIA, --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
