views:

82

answers:

0

I need to list the service connection points on various windows servers. Ex. When I set up Kerberos for Sql Serve Analysis Services, the documentation says to use: Setspn.exe -S MSOLAPSvc.3/Fully_Qualified_domainName OLAP_Service_Startup_Account

Apparently, however, Sql 2008 R2 may have incremented the MSOLAPSvc.3 to MSOLAPSvc.4, which of course will prevent Kerberos from functioning properly. Hence my need to query the server to ascertain which service connection points are running.

I would prefer powershell, but C# is fine, etc.

Anyone?