hi,

this is a part of the document I made for internal use in my company, need for both instances.

Open ADSI Edit

Find the good username under which SQL server runs.

Properties

Locate the ServicePrincipalName property

Press edit, validate the list.

Use this SPN as template:

MSSQLSvc/server.domain:1433

Set the good server name, example:

MSSQLSvc/server.domain:1433

Fill in and press add

See if it is added to the list.

Press OK

Find the allowedToDelegateTo

Press edit.

Add the same SPN

Press Add.

When done, press Ok, then Apply.

PS, verify if the old one didn't use SQL authentication, if it is used of course.