Hey Listeners I'm trying to help a friend... no, really it is a friend, not me in need of the help here :)
She's restored the MS SQL DB while running a routine DR process check but now cannot seem to start the ARS Service. She can confirm that ARAdmin is dbo and user on the system and that she can connect to sql fine, but not via the remedy services. The arerror.log file shows the below errors, which all indicate that there are problems with the network connection to the DB that the ARS cannot see. Any ideas? Regards Mel *arerror.log extract:* Sun Feb 18 16:13:51 2007 390600 : Failure while trying to connect to the SQL database. Please ensure the SQL database is running or contact the Database Administrator for help (ARERR 550) Sun Feb 18 16:13:51 2007 Sun Feb 18 16:13:51 2007 390600 : Cannot initialize contact with SQL database (ARERR 551) Sun Feb 18 16:13:51 2007 Stop server Sun Feb 18 16:13:51 2007 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Sun Feb 18 16:28:11 2007 390600 : Failure during SQL operation to the database (ARERR 552) Sun Feb 18 16:28:11 2007 [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (SQL Server 17) Sun Feb 18 16:28:11 2007 390600 : SQL database is not available -- will retry connection (ARNOTE 590) Mon Feb 19 09:08:50 2007 390600 : Failure during SQL operation to the database (ARERR 552) Mon Feb 19 09:08:50 2007 [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation. (SQL Server 11) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
