SPN Registration for SQL Server Reporting Services

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



July 12th, 2013 12:24am

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

Free Windows Admin Tool Kit Click here and download it now
July 12th, 2013 3:16am

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

July 15th, 2013 5:20am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics