Make sure you are using a domain account to install the Cluster that has Local Admin on both nodes.

Mohit.

Please don't cross post, reply here.

Mohit.

Have a look at ... http://www.codeplex.com/ExportSQLScript

Thanks.

Mohit.

The link I posted eailer explains this, http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/.

Basic idea is you want to launch Performace Montior on the server and look at counters for Memory, Physical Disk, and SQL Server:...

Have a look at:

http://support.microsoft.com/?kbid=940254

Try using the IP address.

Thanks.

Hi Rog,

Index ID = 1 means this is a cluster index; so it eliminates that question. Your fragmentation level is also good. So the next reason...

Good stuff; I know it is a bit annoying but that is best I could do in...

Please execute ...

SELECT *

FROM sys.database_mirroring_endpoints

On both your nodes and paste results.

The errors you are getting with Windows Authentication indicates that the account credintials are not being passed accoross...

The account you gave access is it not Windows account?

If you can't use domain account then you need to use certificates to setup authentication between nodes.

Look at: http://technet.microsoft.com/en-us/library/ms191477.aspx

Thanks.

It is not needed for clustering but if you use DTC for heavy-weight transaction handling then you'll need it.

Thanks.

declare @id int

if @id = null

select '@id=null was avluated as true'

if @id <> null

select '@id<&gtnull was avluated as true'

if @id is not null

select '@id is not null was avluated as...

I have ... 3 scripts in (http://sqllearnings.blogspot.com/2009/03/mirroring-scripts.html) you can use to setup mirroring.

These script are designed to setup mirroring on three nodes; if you are planning to only use two...

Duplicate post, please reply here.

Execute this to confirm the Endpoint are enabled/started state:

SELECT name, role_desc, state_desc

FROM SYS.database_mirroring_endpoints

If state is not started then execute ..

ALTER ENDPOINT [EndPointName]

STATE=STARTED

Thanks.

One reason is extended communication failure between the two nodes; the node could not talk to its partner/witness so could not decide if it should take over the principle roll....