John, I am not a SQL DBA so I hope I am able to explain this right.. But I have had what you are seeing in the past and done these changes myself.
During an initial install, dbo is a role that the ARAdmin user is given so that it has an administrative level access to ARSystem database. So when you do a backup and restore of the database, for some reason (I have never been able to figure out why that happens), the role changes to ARAdmin instead of staying at dbo for all ARSystem owned objects.. You can however change it back to dbo by changing the dbowner.. The stored procedures for changing the ownership of a DB is sp_changedbowner and that of objects within the DB is sp_changeobjectowner. Login to the SQL database as sa and 'use' your AR System database EXEC USE arsystem; EXEC sp_changedbowner 'ARAdmin'; Write a script to change object ownership of all objects in the ARSystem database to ARAdmin.. For eg EXEC sp_changeobjectowner 'T1', 'ARAdmin'; will make ARAdmin as the dbo of the object T1. You will need to bring the ARS offline while doing this. Change the db ownership before you change object ownership.. Hope this helps...... Joe ________________________________ From: "Reiser, John J" <john.j.rei...@lmco.com> To: arslist@ARSLIST.ORG Sent: Thursday, August 27, 2009 3:04:47 PM Subject: Re: Moving a remote SQL Server DB to new hardware ** 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 SeniorSoftware 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:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Thursday, August 27, 2009 11:45 AM To: arslist@ARSLIST.ORG 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
