SQL Server Performance

Failover cluster installation error

Discussion in 'SQL Server 2005 Clustering' started by gpreddy, Aug 30, 2008.

  1. gpreddy New Member

    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 windows password for instance 1 $ 2. But why we are getting this error ? could you plz any body have the solution for this.
    Thanks
    Reddy
  2. satya Moderator

    What kind of authencation used in SQL Server?
    Where about you are getting this error, is it during a login authentication or in general>
  3. gpreddy New Member

    Hi Satya,
    I tried with both windows authentication and Mixed mode. Iam getting this error As soon as the setup display the message Installing msdb
    with "C:program FilesMicrosoft SQL ServerMSSQL.2MSSQLInstallinstmsdb.sql". And this error is coming when the browser service is in start mode(all other services are stoped) in all the 3 nodes.
    If I stop the Browser, Iam getting different error like
    The setup has encountered an error while Upgrading Components. The error: -2147019873
    Error message: The group or resource is not in the correct state to perform the requested operation.
    and
    Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3024 for SQL Server Database Services 2005 (64-bit) ENU (KB000000)' could not be installed. Error code 1603.


    Why we are getting getting different errors based on start/stop mode of browser service? what are the best practices while installing 2nd failover instance,I mean we need stop or start the browser service?
    Thanks
    reddy



Share This Page