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"
