Hi Keith

are we talking SQL server user accounts or Windows user\group accounts?

The only way you'll lose permissions for the user in the database is to drop the database user! When...

i have a technet subscription which i have just renewed for another year without any issues. I did however have issues with MS and misprints in one of their press...

My...

Aah now...

Sachin Vaidya (9/29/2010)

---

Yes I realized that this setting is not worth as we need to set it for the user account that is assigned to SQL Server service.

Though I am...

no problem. Take a bit of time to get used to failover cluster manager before going any further and you'll be golden 😉

Marios Philippopoulos (9/30/2010)

---

Cluster consists of three nodes:

Node 1: active node for instance SQL01

Node 2: active node for instances SQL02 and ABCD

Node 3: passive node

Instance SQL01 can only fail over from...

it doesn't setup the log, events are now monitored through the event viewer in failover cluster manager. The command below dumps a copy of the log to "cluster.log" for interrogation\support...

have you checked the replication job history and status?

Pre create the empty service\application and then fill it with the appropriate resources (disk, DTC IP, DTC NAME, DTC service) and then install SQL Server 2008 selecting the pre created...

no reason why it should, in fact what makes you...

cluster.log has gone in Windows 2008, you can generate a log though using the following command

Cluster log /gen /copy "C:\yourpath"

which quorum type did you specify when deploying the Windows 2008 cluster?

--supply a date or getdate(), etc

declare @dtime datetime

select @dtime = '2010-07-04 10:25:21'

--pick out the parts you need

select cast(datepart(mi, @dtime) as varchar(2)) + ':' +

...

Duran

you add the disks as cluster resources and create a clustered DTC app for each one you want to deploy. You could even create them in the SQL groups they...