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)
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"_
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"_
