Well, it is definitely using NT Authority\SYSTEM to connect to the other database. At this point I would think you are going to need to change the account under which ARS is running, or since it is a dev box, restore your original configuration and start the upgrade again.
Thanks, Andrew Baxter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 2:39 PM To: arslist@ARSLIST.ORG Subject: Re: Server fails to Restart w/NT Authority user Andrew & Stephen, Thanks for the responses. Unfortunatley, even though this is a dev box I do not have much in the way of access rights to the box (controlled by the NT Group) and getting help from them is a major pain. To answer your previous questions, Andrew, no, no new apps and since I didn't do the upgrade, I'm not sure of what patches may have been applied. And, since I don't have much in the way of rights to the db, not much I can do there, either. What a pain . . . Here is the SQL log: Feb 14 2007 13:18:50.4460 */SQL Trace Log -- ON <SQL > <TID: 0000005704> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Wed Feb 14 2007 13:18:50.4460 */CONNECT ARSystem, USER ARAdmin <SQL > <TID: 0000005704> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Wed Feb 14 2007 13:18:50.4780 */*** ERROR *** Login failed for user 'NT AUTHORITY\SYSTEM'. (SQL Server 18456) <SQL > <TID: 0000005704> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Wed Feb 14 2007 13:18:50.4930 */SQL Trace Log -- OFF This just clears up ALL of the confusion, doesn't it? :-( Scott Original Message: ----------------- From: Baxter, Andrew [EMAIL PROTECTED] Date: Wed, 14 Feb 2007 13:56:11 -0500 To: arslist@ARSLIST.ORG Subject: Re: Server fails to Restart w/NT Authority user I believe I ran into a similar problem doing a test upgrade myself. I was eventually able to determine exactly what account it was attempting to use to connect to the SQL Server from the SQL logs within remedy. I then had to add that account as a dbo to the remedy database and things started working. I wasn't particularly comfortable with this as a long term solution and since it was my lab I went ahead and rebuilt everything, but the sql logs should be able to help you out. Thanks, Andrew Baxter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, February 14, 2007 1:53 PM To: arslist@ARSLIST.ORG Subject: Re: Server fails to Restart w/NT Authority user Scott, I experienced a similar situation about 2 years ago. I am not 100% sure if this is the issue, but... what is the login name used for the Remedy NT service and SQL Server NT service? I changed it here to a network account that has Admin access on the server and also has access to query LDAP and it cleared up this and other issues. This may not be the exact solution but just in case, it might save you some troubleshooting time. Stephen -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, February 14, 2007 1:47 PM To: arslist@ARSLIST.ORG Subject: Server fails to Restart w/NT Authority user All, I did not do the install or upgrade for this server, so there some specifics (probably critical specifics) that I do not currently have, but here goes: ARS 7 SQL Server 2000 Windows Server 2003 Standard Edition Server was upgraded from ARS 6.3 to ARS 7 (not sure of the applied patch). Server was upgraded about two weeks ago and has been humming along ever since. The physical server had to be rebooted yesterday (I'm not sure as to why, but my understanding is that it was not because of the AR System). Since the reboot, the AR System Server will not come back up. The following is the entry in the ARERROR LOG when the restart fails: Login failed for user 'NT AUTHORITY\SYSTEM'. (SQL Server 18456) Wed Feb 14 12:33:07 2007 390600 : Cannot initialize contact with SQL database (ARERR 551) Wed Feb 14 12:33:07 2007 Stop server Wed Feb 14 12:33:07 2007 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Under normal circumstances, I believe the error should state "Login failed for user ARAdmin" so I am not sure why the NT AUTHORITY\SYSTEM user is being referenced. As I said, I did not do the initial install of the db, or the upgrade of Remedy. The funny thing is that I can log into the AR System database in Query Analyzer and Enterprise Manager using the out of the box ARAdmin ID and password. And, ARAdmin is the dbo. Any help anyone can provide would be greatly appreciated. Scott Parrish IT Prophets, LLC (770) 653-5203 -------------------------------------------------------------------- mail2web.com - What can On Demand Business Solutions do for you? http://link.mail2web.com/Business/SharePoint ________________________________________________________________________ _______ 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" -------------------------------------------------------------------- mail2web LIVE - Free email based on Microsoft(r) Exchange technology - http://link.mail2web.com/LIVE ________________________________________________________________________ _______ 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"
