Sccm Install issue. Fails on Create and Initialize Database
SCCM and remote Sql on 64 Windows 2008 R2, SQl 2008 64bit Installing SCCM 2007 with service pack 2 All prereqs completed, Added SCCM machine ot admin group on Sql. Has permission in Sql Verified CLR enabled. Seems to create most of the database and tables, I see the roles created but it fails before completion of item . Tail end of log file <06-10-2011 09:55:27> SQL Script: Create SQL object MP_GetEncryptionCertificateForSMSID <06-10-2011 09:55:27> SQL Script: Create SQL object sp_GetPublicKeyForSMSID <06-10-2011 09:55:27> ***SqlError: [42000][1038][Microsoft][ODBC SQL Server Driver][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name. <06-10-2011 09:55:27> SqlExecute <IF OBJECT_ID('') IS NOT NULL DROP PROCEDURE dbo.[]> <06-10-2011 09:55:27> Could not drop object . <06-10-2011 09:55:27> FAILED SQL Script: Create SQL object <06-10-2011 09:55:27> SQL error <> <06-10-2011 09:55:27> Setup cannot create the required database tables. Contact your SQL administrator.
June 10th, 2011 1:04pm

Is the account you are installing with a sys admin in the SQL instance? Is the system account of the ConfigMgr server also a sys admin in the SQL instance? (being a local admin does not make you a sys admin in SQL) Jason | http://myitforum.com/cs2/blogs/jsandys | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 3:26pm

Thanks for your reply. Yes both those things are true. It seems to create the database, and I see a large number of tables. I also see all the roles installed, and have verified security on the created database - it all looks good. I have tried to install to a different DB server and had the same issue. After seeing this I downloaded a new copy of the DVD and that seems to have fixed the issue (non-issue)
June 10th, 2011 4:15pm

Thanks for your reply. Yes both those things are true. It seems to create the database, and I see a large number of tables. I also see all the roles installed, and have verified security on the created database - it all looks good. I have tried to install to a different DB server and had the same issue.
Free Windows Admin Tool Kit Click here and download it now
June 10th, 2011 4:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics