ADSM-L

[ADSM-L] SV: TDP for SQL in a cluster and setting passwords...

2013-09-09 01:30:43
Subject: [ADSM-L] SV: TDP for SQL in a cluster and setting passwords...
From: Christian Svensson <Christian.Svensson AT CRISTIE DOT SE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 9 Sep 2013 05:26:43 +0000
Hi Wanda,
Test following commands

Dsmcutil updatepw /node:NODENAME /password:NEWPW /validate:no

Or you can run following TDP Command

Tdpsqlc changetsmpassword NEWPW NEWPW NEWPW

Cheers
Christian

-----Ursprungligt meddelande-----
Från: Prather, Wanda [mailto:Wanda.Prather AT ICFI DOT COM] 
Skickat: den 9 september 2013 05:59
Till: ADSM-L AT VM.MARIST DOT EDU
Ämne: TDP for SQL in a cluster and setting passwords...

TDP for SQL 6.4, Win2K8, SQL in a 2-node active-passive cluster

TSM scheduler was installed on both nodes of the cluster, made a cluster 
resource, registry key set as per instructions in the TDP for SQL 6.4 user 
guide.

Then the nodes were de-registered from TSM.
Now we have to put them back (long story, don't ask).
Nobody knows what the TSM password was, of course.

So I reset the password on the TSM server end.
Now trying to reset it on the nodes, with no success.
I tried using the client setup wizard to change the password on the client end; 
I tried running dsmc sched on the client end and responding to the prompt, from 
both the active and passive side.
But the password doesn't get changed, and authentication with the server still 
fails with "scheduler needs to prompt for password" when we bring the resource 
online in cluster manager.

Not sure if I'm suffering from an authority issue, or a clustering issue.
To reset the scheduler password, do I have to first make the scheduler service 
NOT a cluster resource again?

Thanks for any insight...
W

Wanda Prather  |  Senior Technical Specialist  | Wanda.Prather AT icfi DOT com  
|  www.icfi.com ICF International  | 401 E. Pratt St, Suite 2214, Baltimore, MD 
21202 | 410.539.1135 (o)

<Prev in Thread] Current Thread [Next in Thread>