Thanks!

So just to be clear I would need to delete what's there with setspn - D and put a static port to replace the dynamic one and then add the...

Attached is a printscreen from the Kerberos tool

do I need to remove the setting before adding again  as we have 2 instances ?

• This reply was modified 5 years, 3 months ago by  johnnyrmtl.
• This reply was modified 5 years, 3 months ago by  johnnyrmtl.

Just to clarify ... we have 2 instances on this server and only the second appears in the results above

Can I just run the command to add the default instance...

I'm at a lost as to making it work the we cannot afford any downtime on this installation 🙁

This is what I get when I query the SPN

C:\Windows\system32>setspn -L "ourdomain\s-cpo-sqlgui-d"

Registered...

• This reply was modified 5 years, 3 months ago by  johnnyrmtl.

Since Kerberos is not being used this is the message we are getting. The domain user has all the necessary grants as mentioned read/write

SELECT net_transport, auth_scheme FROM sys.dm_exec_connections WHERE session_id...

Thank you very much for your input will check with Kerberos and report back

We have to rethink this thanks a lot for your help !

will report back