I had our DBA check the ownership of the DB and he said it is owned by ARAdmin. I don't have access to it so I can't verify it's right heh.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Friday, August 31, 2007 12:24 PM To: arslist@ARSLIST.ORG Subject: Re: Server crashed now Invalid Object Name errors Ensure that the DB is owned by ARAdmin...sounds like it might not be owned properly -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Friday, August 31, 2007 1:16 PM To: arslist@ARSLIST.ORG Subject: Re: Server crashed now Invalid Object Name errors It has the same network name. I just had to change the db password because I never had the db password for the original dev box heh. Something else I've tried. I opened the join form that corresponds to T378 in the admin tool. Moved a field and saved it. Opened the support console in the user tool and no more error. This only works for join forms I guess though, I try and do it on a regular data form and get the error. Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARERR 69). -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Friday, August 31, 2007 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: Server crashed now Invalid Object Name errors If the SQL server was brought up on another server, does that new server have the same network name as the old server? Or is it named differently? If it has a different name, you should use the stored procedure to rename the SQL database...if you haven't already. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Friday, August 31, 2007 1:47 PM To: arslist@ARSLIST.ORG Subject: Server crashed now Invalid Object Name errors ** Our database server took a nose dive yesterday. The data was stored on a SAN so they brought our database up on another server. I set our conf file to point to the new server and thought everything was good to go. Until I logged in :( ARERR [552] Failure during SQL operation to the database : Invalid object name 'T378'. (SQL Server 208) I get this error with every form I open up in the user tool. This error in particular is when I open the support console, the T378 is a join form. Any ideas where I need to start looking to find the problem? ARS 6.3 MS-SQL 2K ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ ____ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
