It's an AD attribute of the account you are using as a service account for SQL
Server.
You can use
setspn -l domain/account
to see the current SPN.
To create a new one, use
setspn -a MSSQLSvc\serverFQDN:2032 domain/account
setspn -a MSSQLSvc\servername:2032 domain/account
and to delete the old, use
setspn -d MSSQLSvc\serverFQDN domain/account
setspn -d MSSQLSvc\servername domain/account
Reference and more info: http://msdn.microsoft.com/en-us/library/ms191153.aspx
J
From: [email protected] [mailto:[email protected]] On
Behalf Of Frederic Le Royer
Sent: Monday, July 8, 2013 1:34 PM
To: [email protected]
Subject: [mssms] RE: Secondary site link
Hi Jason,
Where do I update the SPN?
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Jason Sandys
Sent: July-08-13 1:40 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: Secondary site link
Did you update your SPN?
1433 is not required btw. It is fully supported to be changed as long as it's
static.
J
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Bradnan, Jerry
Sent: Monday, July 8, 2013 12:28 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] RE: Secondary site link
Unless something has changed that I am not aware of, I believe the 1433 is a
hard requirement for SCCM and changing it is not supported.
Check out the Non-Configurable Ports section of the following article:
http://technet.microsoft.com/en-us/library/bb632618.aspx
Jerry
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Frederic Le Royer
Sent: Monday, July 08, 2013 1:19 PM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] Secondary site link
Hi,
Actual config
1 - Primary 2012 SP1 CU1
2 - Secondary 2012
15 - DP's
We currently have a secondary site that has a "link has failed" status, looking
at the rcmctrl.log on the secondary site I have the following error
ERROR: Exception message: [Login failed for user 'NT AUTHORITY\ANONYMOUS
LOGON'.~~OLE DB provider "SQLNCLI11" for linked server "xxx.xxx.com" returned
message "Invalid connection string attribute".]
Last week we changed the default 1433 port to 2032 and had the firewall
modification applied, everything was working and then this morning we had this
error. I have been trying to find a solution but I'm out of ideas!
Thanks
