Gary....earlier in the mail you said 'SQL Server 2k8'....thus my confusion....2K is supported on 7.1...but not 2k8...:)....now about the last error
Remedy keeps track of what version the DB is so that it knows if the app version is correct....when I issue the following command on my 7.1 server I get select dbVersion from control 23 On my 7.5 dev server I get 24 What do you get? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Thursday, May 20, 2010 11:01 AM To: [email protected] Subject: Re: sql server Okay, finally got a compatibility matrix, thanks for it you know who you are. So, the following line for 7.1: 32 or 64 bit x86 PC Compatible Windows 2000, 2003 (32 or x64) [Server, Advanced Server, Datacenter, Enterprise, Standard] Microsoft SQL Server 2000, 2005 (32 or 64-bit) [Enterprise, Standard] Oracle 9i, 10g [Standard, Std One, Enterprise + RAC] IBM DB2 8.2.2, 9.1 [Enterprise, Workgroup, Workgroup Unlimited] This clearly states that SQL Server 2000 32-bit Enterprise Edition will work with BMC AR System 7.1. However, I'm getting a bunch of errors: ARSql.log: <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0float3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0float3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0char3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0char3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */DROP TABLE AR0decimal3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0decimal3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5790 */SQL Trace Log -- OFF And then the real confusing one from the arerror.log: Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) I'm running SQL Server 2k EE on Windows Server 2k3 EE SP2. According to the Compatibility Matrix, this should be a supported configuration. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, May 19, 2010 4:00 PM To: [email protected] Subject: Re: sql server ** Well....Gary, as I'm sure you are aware that's not a supported configuration...I don't have any experience with it kuz I try to stay within supported configurations....but BMC I'm sure wouldn't recommend it J From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, May 19, 2010 2:42 PM To: [email protected] Subject: sql server ** Has anyone experienced any issues using SQL Server 2k8 standard edition instead of enterprise edition? This is with 7.1 version of AR System. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
