Thanks Jason for your reply. Here is the option that is selected: SQL Server and Windows Authentication mode
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Sent: Sunday, April 12, 2009 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrading to SQL 2005 ** Open SQL management studio. Right-click on the instance name in the navigation pane on the left. Select Properties. In the Security section, is Windows Authentication mode or SQL Server and Windows Authentication mode selected? ________________________________ From: "Rodriguez, Rafael J x23718" <rafael.rodrig...@broadridge.com> To: arslist@ARSLIST.ORG Sent: Sunday, April 12, 2009 3:01:30 AM Subject: Re: Upgrading to SQL 2005 ** Jason thanks for the info. How would I check this? ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Sent: Friday, April 10, 2009 6:39 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrading to SQL 2005 ** Check to make sure the DBA's didn't change SQL to Windows only authentication. If they did, you need to change the dbo to the windows account that you use to start the remedy application service. ________________________________ From: "Rodriguez, Rafael J x23718" <rafael.rodrig...@broadridge.com> To: arslist@ARSLIST.ORG Sent: Saturday, April 11, 2009 1:25:21 AM Subject: Re: Upgrading to SQL 2005 ** FYI, the DBAs ran the upgrade this past week and now we get the following error when starting Remedy Fri Apr 10 18:11:41 2009 390695 : Unable to extract minor version from Java VM version string: 10.0-b23 (ARERR 9130) Fri Apr 10 18:11:41 2009 390600 : Failure during SQL operation to the database (ARERR 552) Fri Apr 10 18:11:41 2009 Login failed for user 'ARAdmin'. (SQL Server 18456) Fri Apr 10 18:11:41 2009 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) Fri Apr 10 18:11:41 2009 Login failed for user 'ARAdmin'. (SQL Server 18456) Fri Apr 10 18:11:41 2009 390600 : Cannot initialize contact with SQL database (ARERR 551) Fri Apr 10 18:11:41 2009 Stop server Fri Apr 10 18:11:41 2009 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Any idea why? Thanks ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, April 06, 2009 9:06 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrading to SQL 2005 ** Rafael, We are actually undergoing that upgrade at the moment without issue. Remedy doesn't seem to notice a change at all... ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rodriguez, Rafael J x23718 Sent: Saturday, April 04, 2009 9:27 AM To: arslist@ARSLIST.ORG Subject: Upgrading to SQL 2005 ** Hello, just wanted to see if any has encountered any issues upgrading the backend SQL server from SQL 2000 to SQL 2005? My environment is: ARS 7.0.1 Patch 6 in a server group environment. WIN 2003 Server Remote SQL 2000 Clustered Servers Also, does remedy need to be re-installed after the upgrade? Thanks in advance! Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<<image001.jpg>>