Hi, I am looking for an answer to my recent problem with Security Compliance Manager 1.0. When I attempt to duplicate a Microsoft template i get the following error: XQuery [Setting.Check.modify()]: There is no function '{http://www.w3.org/2004/07/xpath-functions}:upper-case()' Full error is shown below: ============================= System.Data.SqlClient.SqlException ================== XQuery [Setting.Check.modify()]: There is no function '{http://www.w3.org/2004/07/xpath-functions}:upper-case()' ------------------ Additional data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 09.00.4035 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 2395 HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink HelpLink.LinkId: 20476 ------------------ Program Location: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SecurityComplianceManager.Database.XTransDataSetTableAdapters.BaselineTableAdapter.DuplicateBaseline(Nullable`1 baselineID, Nullable`1 baselineRevisionNum, Nullable`1 duplicateBaselineID, Nullable`1 duplicateBaselineRevisionNum, String duplicateBaselineName, String duplicateBaselineDescription, Nullable`1 duplicateBaselineMode, Nullable`1 duplicateBaselineMajor, Nullable`1 duplicateBaselineMinor, Nullable`1 duplicateBaselinePublisherID) at Microsoft.SecurityComplianceManager.ClientObjects.Baselines.Baseline.InsertNewBaseline(Guid newID, Int32 newRevrsionNum, String newName, BaselineMode newMode, String newDescription, Guid newPublisherID, Int32 versionMajor, Int32 versionMinor) at Microsoft.SecurityComplianceManager.ClientObjects.Baselines.Baseline.Duplicate(Guid baselineId, Int32 baselineRevisionNum, String baselineName, String baselineDesc) at Microsoft.SecurityComplianceManager.UI.DuplicateBaseline.ButtonSaveClick(Object sender, RoutedEventArgs e) OS i have tried: XP SP2 Server 2003 SP2 Both with SQL Express 2005 SP3 After some searching it looks like there is a problem with SQL however I am unsure and have no idea how to resolve this. Any assitance welcome. Thanks

Hi Tom, Thank you for posting here. As the issue is more related to Security Compliance Manager, regarding the Security Compliance Manager issue, please find the support in Security Troubleshooting and support. Security Troubleshooting and Support http://social.technet.microsoft.com/forums/en-US/winserversecurity/threads/ Sincerely, Wilson JiaThis posting is provided "AS IS" with no warranties, and confers no rights. Please click "Mark as Answer" when you get the correct reply to your question.

I could solve that issue by installing the correct SQL 2008 Express Version http://www.microsoft.com/downloads/details.aspx?FamilyId=58CE885D-508B-45C8-9FD3-118EDD8E6FFF&displaylang=en