You almost certainly have a security issue. To link servers in SQL Server 2005, you must use a SQL Server ID, not a Windows Authenticated ID. It makes...

What about the following re securing clusters?

From SQL Server 2005 Books Online (search under clusters [SQL Server]\encryption):

Encryption on a Cluster

If you want to use encryption with a failover cluster, you...

Alvin,

You are correct about SS2000, but most shops have moved on to SS2005 and many are either using or planning migration to SS2008. The use of a Dedicated Administrative...

As a followup, the MS reference for Port 1434 assignment is in Books Online

The context of this question was unclear. This is a DBA forum and per Microsoft, the default dedicated Administrative port for SQL Server is 1434, which is always available...

You interpret it just the way it reads... NO (emphatically!) it will not work. You need to find a new architect. SQL Server 2000 is shaky in a...