August 30, 2008 at 3:32 pm
hi,
We are configuring Active/Active/Passive clustering for sql server 2005 EE x64 on W2k3 x64.
We installed the first failover instance and applied sp2 without any errors.
But we are getting the following errors while installing 2nd failover instance.
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Password validation failed. The password does not meet Windows policy requirements because it is too short.. To continue, correct the problem, and then run SQL Server Setup again.
When I clicked the retry button Iam getting the following error:
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client]Communication link failure. To continue, correct the problem, and then run SQL Server Setup again.
again when clicked retry button it is giving the error:
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
. To continue, correct the problem, and then run SQL Server Setup again.
We used the same domain Account for instance 1.It went through without any errors. Even I tried with sa password,still Iam getting the same errors. But why we are getting this errors for the second instance? could you plz any body have the solution for this.
Thanks
September 2, 2008 at 6:59 am
In SQL Server 2005 SQL passwords are set by default to have to meet domain password requirements. The odds are your sa password does not meet this requirements so you need to change it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 2, 2008 at 8:25 am
Jack Corbett (9/2/2008)
In SQL Server 2005 SQL passwords are set by default to have to meet domain password requirements. The odds are your sa password does not meet this requirements so you need to change it.
Jack,
it's actually the local password policy, not the domain policy. And in the case described it seems like the local password policy is different between the nodes.
[font="Verdana"]Markus Bohse[/font]
September 2, 2008 at 10:39 pm
hi Markus,
the local domain policy on each node same. But still Iam getting the error.
One more question 'do we need to stop the browser service or not while installing the 2nd failover instance'?
September 3, 2008 at 12:55 am
madhu.arda (9/2/2008)
the local domain policy on each node same.One more question 'do we need to stop the browser service or not while installing the 2nd failover instance'?
What do you mean the local or the domain policy? Check under Administrative Tools> Local Security Policy. The the local policy I'm talking about.
And no, you shouldn't stop the browser service while installing a new failover instance.
[font="Verdana"]Markus Bohse[/font]
September 3, 2008 at 10:33 am
thanks Markus,
As best practises says 'stop all the services before installing an instance'. So what is the reason to start only sql browser service?
could you please explain me this..
thanks
Madhu
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply