Hi, I would like to know how to make sure SPN is registered for SQL Server, SQL Server Reporting Service
and SQL Server Analysis server. In our case, all are in dfferent servers.
That is for SQL Reporting Services in a network that uses the Kerberos protocol.
Please let me know. Regards, Manjunath Jogin
for SSRS you register the SPN using HTTP (because its a web service)
setspn -S HTTP/servername.domain.com:port domain\accountname
for SQL Server you register the SPN using MSSQLSvc
setspn -S MSSQLSvc/servername.domain.com:port domain\accountname
for Analysis Services your register the SPM using MSOLAPSvc.3
setspsn -S MSOLAPSvc.3/servername.domain.com:instance domain\accountname
Hi MSDN Student,
Thanks for your valuable information.
We have four servers ssrs, ssas, SharePoint, SQL server. I have access to all servers.
Our is intranet.. from where I can take below things
1. HTTP/servername.domain.com
2. :port domain
3. \accountname
4. :instance domain
Thanks and Regards,
Manjunath