TDP for SQL problem.
Hi, folks. I'm writing this message because I'm having a trouble with: TDP for SQL - version 2.2.1 Operating System - Windows NT 4 - SP6 I want to use sql authentication. I put a new User ID and password, and change the service TDP for SQL at startup (log on as this account and password). I stopped and restarted the service after this modifications, and when I run a backup test I received the following error code into TDP: "Backup failed. ACO5422E received the following from the MS SQL Server [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040bc5)". I have another machine with the same configuration, although it runs this backup without errors...and I looked and compared its configurationsand I saw a unique difference in API's: the machine that runs ok shows in TSM server information: TSM API Version: Version 4, Release 2, Level 2...and in the server with problems shows: TSM API Version: Version 4, Release 2, Level 3... It looks to me as if can be a API problem, so I would install another patch to correct this question. Am I right ??? or can be a ODBC problem ?? I searched in Windows Technet to see if could be relationship between this error code and MS SQL Server / ODBCand I didn't find any answers to that. hugs for everybodyand thanks. George. - Yahoo! Acesso Gratis - navegue de graga com conexco de qualidade!
Re: TDP for SQL problem ACO5091E or ACO5422E
Del, I've tried with the /tsmpassword option, but it won't set my password. Besides that we don't have a scheduler running. I've already placed a call with support (PMR03922 if you're interested). Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner Del Hoobler <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 06-01-2004 14:22 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: TDP for SQL problem ACO5091E or ACO5422E Richard, Like you originally stated... strange. One more thing to look at... Go to www.ibm.com. In the upper right Search box enter: "ACN5087E PASSWORDACCESS" Make sure you put the double quotes around the search term. It will show two knowledge base entries that describe the problem you are seeing. If the articles don't help... If you haven't already done so, please place a call with IBM support. Thanks, Del > I've tried all that, but it doesn't work.
Re: TDP for SQL problem ACO5091E or ACO5422E
Richard, Like you originally stated... strange. One more thing to look at... Go to www.ibm.com. In the upper right Search box enter: "ACN5087E PASSWORDACCESS" Make sure you put the double quotes around the search term. It will show two knowledge base entries that describe the problem you are seeing. If the articles don't help... If you haven't already done so, please place a call with IBM support. Thanks, Del > I've tried all that, but it doesn't work.
Re: TDP for SQL problem ACO5091E or ACO5422E
Del, I've tried all that, but it doesn't work. Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner Del Hoobler <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 05-01-2004 16:18 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: TDP for SQL problem ACO5091E or ACO5422E Richard, ACO5091E also is displayed when the password stored is not correct. Try this: 1. Add "CLUSTERNODE YES" to the DSM.OPT file. 2. Reset the password on the TSM Server for the node you are using for DP for SQL. 3. Issue a command that connects to the TSM Server specifying the /TSMPASSWORD= option. For example: TDPSQLC QUERY TSM /TSMPassword=password 4. Retry the command that was failing. Thanks, Del > I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM > Server 5.2.1.3 on Windows 2003 Server). > > When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which > basically tells me that I'm using PASSWORDACCESS GENERATE but there is no > password (how come that the normal BA-client is working then?). > When I put CLUSERNode no in the DSM.OPT I get error ACO5422E, telling me > that an ODBC error occurred with MS-SQL (now PASSWORDACCESS GENERATE > works). > > The above system is part of an active-passive Microsoft cluster.
Re: TDP for SQL problem ACO5091E or ACO5422E
Richard, ACO5091E also is displayed when the password stored is not correct. Try this: 1. Add "CLUSTERNODE YES" to the DSM.OPT file. 2. Reset the password on the TSM Server for the node you are using for DP for SQL. 3. Issue a command that connects to the TSM Server specifying the /TSMPASSWORD= option. For example: TDPSQLC QUERY TSM /TSMPassword=password 4. Retry the command that was failing. Thanks, Del > I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM > Server 5.2.1.3 on Windows 2003 Server). > > When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which > basically tells me that I'm using PASSWORDACCESS GENERATE but there is no > password (how come that the normal BA-client is working then?). > When I put CLUSERNode no in the DSM.OPT I get error ACO5422E, telling me > that an ODBC error occurred with MS-SQL (now PASSWORDACCESS GENERATE > works). > > The above system is part of an active-passive Microsoft cluster.
Re: TDP for SQL problem ACO5091E or ACO5422E
We use the /sqlserver parameter. The complete command we use is: tdpsqlc backup PRD full /tsmoptfile=dsm.opt /config=tdpsql.cfg Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner Bill Boyer <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 05-01-2004 15:41 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject:Re: TDP for SQL problem ACO5091E or ACO5422E I believe that for clusters you need to specify the /SQLSERVER= parameter of the virtual SQL server name in the cluster. The default is to logon to the "local" instance, which on a cluster there isn't one. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Richard van Denzel Sent: Monday, January 05, 2004 9:24 AM To: [EMAIL PROTECTED] Subject: TDP for SQL problem ACO5091E or ACO5422E Hi All, I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM Server 5.2.1.3 on Windows 2003 Server). When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which basically tells me that I'm using PASSWORDACCESS GENERATE but there is no password (how come that the normal BA-client is working then?). When I put CLUSERNode no in the DSM.OPT I get error ACO5422E, telling me that an ODBC error occurred with MS-SQL (now PASSWORDACCESS GENERATE works). The above system is part of an active-passive Microsoft cluster. On another (non-cluster) system I've got the same software running and this will backup with the TDP for SQL without problems. Has anyone got a clue to what is going on? Or perhaps someone has experienced the same problem and knows a solution for it? Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner
Re: TDP for SQL problem ACO5091E or ACO5422E
I believe that for clusters you need to specify the /SQLSERVER= parameter of the virtual SQL server name in the cluster. The default is to logon to the "local" instance, which on a cluster there isn't one. Bill Boyer DSS, Inc. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Richard van Denzel Sent: Monday, January 05, 2004 9:24 AM To: [EMAIL PROTECTED] Subject: TDP for SQL problem ACO5091E or ACO5422E Hi All, I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM Server 5.2.1.3 on Windows 2003 Server). When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which basically tells me that I'm using PASSWORDACCESS GENERATE but there is no password (how come that the normal BA-client is working then?). When I put CLUSERNode no in the DSM.OPT I get error ACO5422E, telling me that an ODBC error occurred with MS-SQL (now PASSWORDACCESS GENERATE works). The above system is part of an active-passive Microsoft cluster. On another (non-cluster) system I've got the same software running and this will backup with the TDP for SQL without problems. Has anyone got a clue to what is going on? Or perhaps someone has experienced the same problem and knows a solution for it? Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner
TDP for SQL problem ACO5091E or ACO5422E
Hi All, I have a strange problem with TDP for MS-SQL 5.2.1.0 (running on TSM Server 5.2.1.3 on Windows 2003 Server). When I put CLUSTERNode yes in the DSM.OPT I get error ACO5091E, which basically tells me that I'm using PASSWORDACCESS GENERATE but there is no password (how come that the normal BA-client is working then?). When I put CLUSERNode no in the DSM.OPT I get error ACO5422E, telling me that an ODBC error occurred with MS-SQL (now PASSWORDACCESS GENERATE works). The above system is part of an active-passive Microsoft cluster. On another (non-cluster) system I've got the same software running and this will backup with the TDP for SQL without problems. Has anyone got a clue to what is going on? Or perhaps someone has experienced the same problem and knows a solution for it? Met vriendelijke groet, with kind regards, Richard van Denzel Consultant IBM CATE, TSM Certified Consultant Solution Professional Services B.V. Transistorstraat 167, 1322 CN Almere Postbus 50044, 1305 AA Almere. T: +31 (0)36 880 02 22 F: +31 (0)36 880 02 44 M: +31 (0)652 663 978 W: www.sltngroup.com E: [EMAIL PROTECTED] Solution Professional Services B.V. is onderdeel van SLTN GROUP IBM Premier Business Partner