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
