Hi, I get the following error while trying to execute a powershell script.New-Object : Cannot find type [Microsoft.SQlServer.Management.Sdk.Sfc.SqlStoreConnection]: make sure the assembly containing this type is loaded.I'm trying to implement policies across different sql server instances from a primary instance. The script can be found @ http://blogs.msdn.com/sqlpbm/archive/2008/06/14/running-against-sql-server-2005-and-sql-server-2000.aspxThanks for your help.
AFAIK, the type is in Microsoft.SqlServ rer .Management.Sdk.Sfc.dll which should be GACed. Can you find whether this file exist under %windows%\assembly folder?
Hope it helps.
A, I agree with Jim. You can also take a look of the posting athttp://epmframework.codeplex.com/Thread/View.aspx?ThreadId=50564
- Proposed as answer by Vindy-MSFT Saturday, August 21, 2010 5:17 PM