I think that I have seen this before and it was down to permissions, you need to be a sysadmin and potentiolly a local admin on the server the instance...

Hi I havn't messed around with transactional replication on 08 and was unaware that FK constraints were used by query optimiser, I will look into that. But the easiest...

Hi I would not recommend the course of action that you are taking, messing around with cluster network names etc is fraught with dangers. If you need to be...

Hi I have never upgraded an instance on a cluster, and although it can be done from all my experience and the experience of others it would not be recommended....

If I were you I would use the 2008 client tools to configure replication, and use the most recent client tools where possible, they should be compatible back to 2005

If the network name doesn't exist in ad create it so you can start the instance. You should be able to start it then.

Seeing that this is in a lab I am surprised by your issue. It could be a case that the database has certain components that don't work well with merge...

I estimate that the 80,000 refers to the number of transactions delivered, how many per minute. Are both databases being utilised by users at the same time? If...

There is no simple way to resolve merge replication issues.

What version of SQL are you using?

How much data are you pushing to your replica.

Is it a...

From my understanding of mirroring it would not be recommended to have different versions of SQL mirrored. I am sure I read thsi somewhere but cant find the article....

I have encountered this before. How I resolved it was the following

You cant remove a node of SQL if it is not running. On the node you...

Hey There, try using the command line to remove the nodes form the SQL isntallation, this will probably be the easiest.

setup.exe /ACTION=RemoveNode /INSTANCENAME="<Insert Instance Name>"

As for SSIS, this...

Not sure about the licencing of Standard edition if it is just a witness. Based on knowledge of other licencing states, as long as there are no users connected...

I wish it was that simple. It was an 08 Domain in a 2000 forest. There were very odd things happening on the install, I posted looking for...

Totaly true on the permissions, but since I was stung installing sql08 on a 2000 domain, I have decided to make this alteration to my setup. It just guarantees...