sccm 2007 sp2, sql 2008r2 error creating database tables
This is a new install. none of the other threads on this issue seem to apply to me. SQL server is on same box as sccm. Running install as enterprise/domain administrator. I keep getting: Setup cannot create the required database tables. Contact your SQL administrator. If its any help here's part of the config mgr setup log: <08-24-2011 17:09:17> SQL Script: Create SQL object spPurgeExpiredCertificates <08-24-2011 17:09:17> SQL Script: Create SQL object spGetUpdatedClientKeyData <08-24-2011 17:09:17> SQL Script: Create SQL object spRemoveClientKeyDataChanges <08-24-2011 17:09:17> SQL Script: Create SQL object MP_GetEncryptionCertificateForSMSID <08-24-2011 17:09:17> SQL Script: Create SQL object sp_GetPublicKeyForSMSID <08-24-2011 17:09:17> ***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. <08-24-2011 17:09:17> SqlExecute <IF OBJECT_ID('') IS NOT NULL DROP PROCEDURE dbo.[]> <08-24-2011 17:09:17> Could not drop object . <08-24-2011 17:09:17> FAILED SQL Script: Create SQL object <08-24-2011 17:09:17> SQL error <> <08-24-2011 17:09:17> Setup cannot create the required database tables. Contact your SQL administrator. <08-24-2011 17:09:34>
August 25th, 2011 12:28am

As per another thread here I downloaded the dvd from the Microsoft Licensing site again and it worked. I guess the error checking in the microsoft download manager isn't perfect. Either that or there was a bad iso on the site for a while which managed to catch a few of us.
Free Windows Admin Tool Kit Click here and download it now
August 25th, 2011 1:10am

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

Other recent topics Other recent topics