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