The credentials you provided during SQL Server 2008 installation are invalid

When providing service accounts and passwords you might encounter one of the following error messages, which prevents you from continuing the installation:

- The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service.

- The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service.

Solution: you may select NT AUTHORITY\SYSTEM and proceed. Later you can change the SQL service account with a dedicated domain service account meant for starting the service.

you can also provide the account with specific roles, like local admin, domain user/ admin based on org. and application specific requirement.

Recommendation:

Automatic restart of Service Accounts

Always make sure that if you are using domain account for running the SQL service, that account needs to be part of following 3 main resultant policies (you might have to do this from AD Group Policy to automatically reflect to the joined servers):

i) Log on as a batch job

ii) Log on as a service

iii) Act as part of the operating system

This will make sure that the account with which the SQL services run are automatically started after each system reboot.

Pre-requisites for SQL 2008 R2 Failover Cluster setup: MSDTC Setup

Microsoft Distribution Transaction Cordinator  setup process:

now proceed with SQL system configuration checker on node 1.

make sure the system configuration checker gets a clean result.

now proceed with New SQL Server failover cluster installation.

recommended website (windows server tutorials and education: winsrvtuts) which explains everything

Windows server 2008 R2 Failover Clustering - explained streaming video

SQL Enterprise Edition Failover Cluster installation on Windows Server 2008 R2 Failover Cluster reference on streaming media which I liked the most

SQL 2008 pre-requisites: Determine and Set the Primary NIC on a Windows 2008 Server

NIC Binding is the order at which windows loads the NIC's at boot up and takes the first one as a primary NIC.

How to Determine and Set the Primary NIC on a Windows 2008 Server

1. Open Network Connections. You may also type shortcut ncpa.cpl from command prompt to open network connection.
2. Press ALT key (dont hold, another list of menus will show up) Click advanced then click Advanced Settings
3. Click the adapters and bindings tab, then under connections, click the connection you want to modify
4. under the binding for connection, you can move the protocol up or down for the connection you have selected at the top

Validation errors while installing SQL 2008 R2 on Node 2 Cluster

The errors what I encountered while validating on SQL node 2.

Before I proceed with Node 2 installation, windows 2008 failover cluster perfectly does the failover transitions. SQL Node 1 installation successfully installed.

available online resources while proceeding to SQL node 2 (analysis service graph)

MSDTC path.

"

Validating cluster resource SQL Server (GP_PROD).

This resource is configured to run in a separate monitor. By default, resources are configured to run in a shared monitor. This setting can be changed manually to keep it from affecting or being affected by other resources. It can also be set automatically by the failover cluster. If a resource fails it will be restarted in a separate monitor to try to reduce the impact on other resources if it fails again. This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab. There is a check-box 'run this resource in a separate Resource Monitor'.

"

However the over all result showed, "Testing has completed successfully. The configuration appears to be suitable for clustering. However, you should review the report because it may contain warnings which you should address to attain the highest availability".

This warning message goes off after installing the SQL 2008 R2 on node second.

Adding SQL Node 2 Cluster services (MSCS) verification error

Error Code 0x80071398

Error..! never mind.

I evicted the node from the cluster and re-added it. Validate the cluster. It worked. Reboot when in question.

reinstall the SQL failover cluster on node 2.

I'm thrilled as failover cluster is awesome and religiously working fine. This is now my first step forward to the new infrastructure for SQL 2008 R2 consolidation project. Redundancy at its par.

Problem installing SQL Server 2008 R2 Failover Cluster on Node 2

Exception from HRESULT: 0x80070006

HRESULT: 0x80070006 (E_HANDLE)) ---> System.Runtime.InteropServices.COMException (0x80070006): The handle is invalid. (Exception from HRESULT: 0x80070006 (E_HANDLE)). noted in SQL Server 2008 versions.

The problem rarely occurs in a row. So restart the server. Restart the SQL node two installation.

you can also try removing the traces of SQL installation from the second node and then try setup again. This time it should go.

for SQL instance removal failure try SQL installed instance removal

curiosity lands on Mars - sends stunning pictures

The biggest scientific endeavor of the decade accomplished with NASA's Mars rover curiosity descending on the Red Planet today.. I watched it live on NASA's website @ http://www.nasa.gov/multimedia/nasatv/index.html

Rover sends first raw picture from the surface of the Mars

high resolution pictures expected in next 48 hrs.

The breathtaking moments of NASA scientist, ya it's unfeigned  team work:

Jet Propulsion Laboratory, California Institute of Technology, Pasadena, California

 

 latest MARS mission library

Earth Observing Laboratory can see real-time pictures of space station.. what's happening there at the moment.