1

Closed

Dell Deployment Pack Install fails when Database server for the ConfigMgr 2007 is SQL server 2008

description

The installation of the Dell Server deployment pack for the ConfigMgr fails when it tries to install Broadcom drivers in to the WInpE. Looking at the logs it seems to be failing due to the SQL query statements. Please find the error below
"[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations."
 
After doing some searches in the Net it was found that the issue is mainly due to the SQL server 2008 compatability issue.
 
http://www.mydigitallife.info/2009/05/17/how-to-set-compatibility-level-for-sql-server-2008-or-2005-database/
 
http://technet.microsoft.com/en-us/library/cc431377.aspx
 
I have attached the Logs for the failure.

file attachments

Closed Dec 17, 2009 at 9:28 PM by rhearn
Fixed by hotfix in ConfigMgr http://support.microsoft.com/kb/955262 and included in SP2

comments

rhearn wrote Aug 24, 2009 at 8:06 PM

I consistently use SQL 2008 for testing of the integration components and have no issues.

The first link you provided mentions that the incompatibility is around using the "=" and "=" join operators, but those operators are never used in queries from the integration components.
The TechNet link you provided doesn't say anything about SQL incompatibilities and only mentions Windows Server 2008.

Please re-open this work item if it is still an issue.

wrote Aug 27, 2009 at 6:14 PM

rhearn wrote Nov 18, 2009 at 11:59 PM

see previous comments



** Closed by rhearn 8/27/2009 11:14 AM

rhearn wrote Nov 18, 2009 at 11:59 PM

We are able to consistently reproduce it, and it has also been reported by multiple customers. We are also aware that setting SQL 2008 to work in compatibility mode with SQL 2005 will bypass this issue. However, we need to get it working without setting this backward-compatibility mode.


The logs (attached in codeplex) clearly indicate the issue caused due to SQL statements in the SCIF code. Relevant excerpts below:
instance of SMS_ExtendedStatus
{
CauseInfo = "";
Description = "Error waiting for query to return.";
ErrorCode = 1078464258;
File = "e:\nts_sms_fre\sms\siteserver\sdk_provider\smsprov\sspobjectquery.cpp";
Line = 4845;
ObjectInfo = "Select * From SMS_Driver Where DriverINFFile='b06nd.Inf'";
Operation = "ExecQuery";
ParameterInfo = "Select * From SMS_Driver Where DriverINFFile='b06nd.Inf'";
ProviderName = "WinMgmt";
SQLMessage = "[42000][1934][Microsoft][ODBC SQL Server Driver][SQL Server]SELECT failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER, CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS, ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.";
SQLSeverity = 16;
SQLStatus = 1934;
StatusCode = 2147749889;
};
Could you please re-open the issue and provide a resolution at the earliest?

rhearn wrote Nov 19, 2009 at 12:08 AM

Looks like this is a ConfigMgr issue (not a SCIF issue), specifically addressed in the hotfix here: http://support.microsoft.com/kb/955229/
(and then replaced here: http://support.microsoft.com/kb/970170/)


Please update this work item with results of further testing.

rhearn wrote Dec 10, 2009 at 10:30 PM

The issue is that "SET QUOTED_IDENTIFIER ON" is not explicitly enabled by the ConfigMgr stored procedure for getting driver information, and any query of "Select * From SMS_Driver" would trigget this exception. This is why Configmgr issued the following hotfix: http://support.microsoft.com/kb/955262 (links below go to the files)

http://hotfixv4.microsoft.com/SCCM%202007/sp1/SCCM2007_SP1_KB955262_X64_ENU/04.00.6221.1117/free/357828_ENU_x64_zip.exe
http://hotfixv4.microsoft.com/SCCM%202007/sp1/SCCM2007_SP1_KB955262_X86_ENU/04.00.6221.1117/free/357827_ENU_i386_zip.exe


This hotfix should be included in ConfigMgr 2007 SP2.

wrote Dec 17, 2009 at 9:28 PM

wrote Feb 13, 2013 at 10:45 PM

wrote May 16, 2013 at 5:21 AM