SOLVED SQL error while installing SCCM

[apsenn]

I am trying to setup SCCM in a test env. And keep getting an error during the SCCM Server install. The error is related to creation of SQL tables, although it creates some of them.

Server OS = 2016 Tech Preview
SQL = Microsoft SQL Server Enterprise Evaluation (64-bit) w\Service Pack 3 (11.0.6020.0)

Have went through the steps of installing everything else up to and including WSUS, but then the SCCM install keeps giving this error after around 17 Minutes

I have also placed it in public on my dropbox

https://dl.dropboxusercontent.com/u/59229956/ConfigMgrSetup.log

Any assistance would be greatly appreciated

I am in the process of downloading SQL server again and going to try an install on a server 2012 box with different SQL version to see if that is whats causing the issue. Will report back if that changes anything

 

[Prajwal Desai]

I see the following error in the log file

ERROR: SQL Server error: [22003][220][Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error for data type tinyint, value = 279. $$<Configuration Manager Setup><03-11-2016 08:05:24.936+480><thread=3228 (0xC9C)>
INFO: Executing SQL Server command: < ~ IF NOT EXISTS (select * from DeviceClientCustomCodes) ~ BEGIN ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12001, 'No more handles could be generated at this time') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12002, 'The request has timed out') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12003, 'An extended error was returned from the server. This is typically a string or buffer containing a verbose error message.') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12004, 'An internal error has occurred') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12005, 'The URL is invalid') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12006, 'The URL scheme could not be recognized or is not supported') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12007, 'The server name could not be resolved') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12008, 'The requested protocol could not be located') ~ insert DeviceClientCustomCodes (MessageID, MessageName) values (12009, 'A request to InternetQueryOption or InternetSetOpt

May I know what version of SQL server and SCCM are you using and have you checked its compatibility with 2016 OS TP ?.

 

[apsenn]

Hello

I did not look for compatibility on the OS, I assumed wrongly I see that the OS wouldn't give those SQL type errors. Although i believe that is the issue now, I have done the following now

Installed it all on a Server 2012 R2 box now with MSSQL 2012 SP1 and it all worked with no errors, So I went back and did it on the Server 2016 with SQL 2012 SP1 (Instead of SP3) and got the same error.

Making me believe it is OS related, so going to stick with using 2012 for the SCCM Server and 2016 for others in my test env

 

[Prajwal Desai]

Thank you for confirmation. Marking this thread as Solved.