What to use linked server to go from client C to Server A to Server B using
Windows Authentication. Also Server A and Server B are going to running on
Domain Accounts that don't have Domain Admin permissions. So I have one
question. Do I only need to register Server A and Server B once using
Setspn.exe or do I have to do it every time the SQL Server Services is
started?

Once. And make sure you SQL Server instances are using a
static port even if they are named instances. The spn tells
AD what service, what server, what port, what account. So
you want the ports static for the spn. If you change any of
those, then you would delete the old spn and create a new
one.

-Sue

On Sat, 28 Apr 2007 08:54:25 -0700, Greg Larsen
<gregalarsen (AT) removeit (DOT) msn.com> wrote: