Hi there I work with dozens of SharePoint 2007 farms and a problem I keep encountering recently is working out which server in the farm is the encryption key server for SSO. I have to log on to each backend (usually 3 per farm) and try to open up the SSO page in Central admin --> operations Does anyone know of a script I can run that can call the object model or SQL - it would really be useful Cheers Jonj

I found where this info is in SQL - it's in the SSO Database in the SSO_Config table - I can surface it using a simple Select - just need to figure how to wrap this into Powershell now... use SSO select SecretServer from dbo.SSO_Config

Hi, Thanks to share your post. For the issue, If have an assembly (exe or dll) with the class in it, PowerShell can load it via [System.Reflection.Assembly]::LoadFile("PathToYourAssembly") or in V2 Add-Type -Path "PathToYourAsembly" If you are creating a runspace in your application and would like to make an assembly available, you can do that with a RunspaceConfiguration. RunspaceConfiguration rsConfig = RunspaceConfiguration.Create(); AssemblyConfigurationEntry myAssembly = new AssemblyConfigurationEntry("strong name for my assembly", "optional path to my assembly"); rsConfig.Assemblies.Append(myAssembly); Runspace myRunSpace = RunspaceFactory.CreateRunspace(rsConfig); myRunSpace.Open(); Hope this could help you! Leo

Thanks for joining in Leoyi - but I'm not sure what I'm supposed to do with that I found a way to surface the info i needed using a SQL query - it would be nice if I could put that into a PowerShell script - I havn't done that bit yet as I don't know how to connect to SQL from Powershell - but that's abit off topic I think Thanks anyway