none
Falling at the first hurdle (SQL Server errors during diagnostics) RRS feed

  • Question

  • I have a clean install of Windows Server 2008 R2 Standard.

    I have installed HPC Pack Beta 1 (I know, it's old, but I'm trying to reproduce a working test case that's failing in the latest RC1) - no problems.

    I run the diagnostics. Service Errors Report fails with:

    MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'all_objects', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'all_views', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'all_columns', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'all_parameters', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'all_sql_modules', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'objects', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'tables', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'views', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'extended_procedures', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'system_objects', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'system_views', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'columns', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'system_columns', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'parameters', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'system_parameters', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'computed_columns', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'identity_columns', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'indexes', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'xml_indexes', because it does not exist or you do not have permission. MSSQL$COMPUTECLUSTER 7/16/2010 11:29:41 AM Error Cannot find the object 'partitions', because it does not exist or you do not have permission.

    Any ideas?

     

    UPDATE:

    I get the same errors for this diagnostic on my newly-created cluster (HPC Server 2008 R2, HPC Pack 2008 R2 RC1). I must be missing something...

    The echo test seems to work just fine on both servers...

    Friday, July 16, 2010 3:48 PM

Answers

  • It could also be related to this....

     

    http://support.microsoft.com/kb/976899/en-us:

     

     

    Friday, August 6, 2010 5:36 PM
  • Dear Jake,

     

      Sometimes if there are errors with multiple installation attempts with SQL and HPC you may need to first

    - Uninstall HPC and remove any residual HPC components in Program Files - and remove the Dirs where you stored the SQL data and logs. 

    - Uninstall SQL (cleaning out everything related to SQL in Program Files and Program Files (x86)

    - Check for pending updates and KB's (as above)

    - Then install SQL

    - Then install HPC

    Hope this helps.

    Mark

     

    Saturday, November 13, 2010 12:02 AM

All replies

  • Dear wbradney,

      The Service Errors Report Diagnostic only looks for Event Viewer type errors and if there are errors within the past 2 hours or so, then it will report those back and have the diagnostic fail. 

       Are you installing your Database / SQL instance before you install HPC (so you are using something other than SQL express?) or are you just having the database be installed with the HPC Product?

       Also, is the SQL instance hosted on the same box as your Head Node?

    Mark

     

    Friday, July 30, 2010 8:45 PM
  • Mark,

    From bare metal, I installed Windows Server 2008 R2, then HPC Pack Beta 1, created a head node, ran diagnostics.

    On another box, again from bare metal, I installed Windows HPC Server 2008 R2, then HPC Pack RC1, created a head node, ran diagnostics.

    I got the same result on both boxes re the Service Errors Report. So I guess in both cases I'm using the default SQL express instance installed by the HPC Pack.

    Friday, July 30, 2010 9:16 PM
  • Before you install HPC can you check the event viewer to see what kind of errors are there?  The "Service Errors Report" Diagnostic isn't running any tests (per se) but rather checking the logs for errors.

    I've tried various combinations trying to repro what could possibly be happening (for example installing as a local admin vs a domain user that has admin rights on the machine) but I didn't see any errors of the sort you are describing.

    Could you try clearing your events in the event viewer before installing HPC?  Also if you are switching between HPC versions on the same machines (or older versions of HPC have been on that machine in the past) you may want to also manually clean out / delete the directories where the SQL databases are being stored (those aren't deleted when doing an uninstall).

    Mark

     

    Monday, August 2, 2010 4:05 PM
  • Just did another bare metal install (as in with a brand new hard drive), this time with the RTM bits, and got the same results. I checked the event viewer before installing HPC and didn't see anything out of the ordinary related to SQL or anything else (not that there would be any SQL errors if SQL wasn't installed yet...)

    I cleared all the logs anyway, and installed HPC. Configured a head node, ran diagnostics -- got the above errors.

     

    Wednesday, August 4, 2010 4:12 PM
  • So it's clearly something that's failing with SQL while installing HPC.

    Despite the diagnostic failures, I can bring the head node online and run the Echo test just fine.

    When I clear the SQL errors from the event log, the diagnostic obviously succeeds.

    I really don't think this is a very big deal, I'm just surprised I seem to be the only one that's encountered it (every time I install HPC, about six times now). It's disconcerting to get diagnostic errors right out of the gate.

    Wednesday, August 4, 2010 4:25 PM
  • Do you see anything in any of the setup logs that might shed more light onto the SQL issues?  Perhaps you could look through

    C:\Windows\Temp\HPCSetupLogs

    there should be both setup and msi files relating to the installation of the Head Node.

    same thing with

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

     

    Wednesday, August 4, 2010 11:07 PM
  • Yes, I see several failures:

    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\RuntimeEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\RuntimeEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:407]: Executing op: ActionStart(Name=UninstallManifest_HpcNodeManager,,)
    MSI (s) (D8:10) [09:04:15:407]: Executing op: CustomActionSchedule(Action=UninstallManifest_HpcNodeManager,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcNodeManager.man")
    MSI (s) (D8:CC) [09:04:15:409]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI46F.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcNodeManager.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcNodeManager.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:439]: Executing op: ActionStart(Name=UninstallManifest_Scheduler,,)
    MSI (s) (D8:10) [09:04:15:440]: Executing op: CustomActionSchedule(Action=UninstallManifest_Scheduler,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SchedulerEvents.man")
    MSI (s) (D8:94) [09:04:15:441]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI48F.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SchedulerEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SchedulerEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:473]: Executing op: ActionStart(Name=UninstallManifest_SDMSvc,,)
    MSI (s) (D8:10) [09:04:15:473]: Executing op: CustomActionSchedule(Action=UninstallManifest_SDMSvc,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SdmEvents.man")
    MSI (s) (D8:F8) [09:04:15:474]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI4AF.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SdmEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\SdmEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:510]: Executing op: ActionStart(Name=UninstallManifest_DiagnosticSvc,,)
    MSI (s) (D8:10) [09:04:15:510]: Executing op: CustomActionSchedule(Action=UninstallManifest_DiagnosticSvc,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\DiagnosticsEvents.man")
    MSI (s) (D8:F0) [09:04:15:511]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI4DF.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\DiagnosticsEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\DiagnosticsEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:544]: Executing op: ActionStart(Name=UninstallManifest_CredentialProvider,,)
    MSI (s) (D8:10) [09:04:15:545]: Executing op: CustomActionSchedule(Action=UninstallManifest_CredentialProvider,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcCredentialProviderEvents.man")
    MSI (s) (D8:30) [09:04:15:547]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI500.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcCredentialProviderEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcCredentialProviderEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:578]: Executing op: ActionStart(Name=UninstallManifest_MgmtSvc,,)
    MSI (s) (D8:10) [09:04:15:578]: Executing op: CustomActionSchedule(Action=UninstallManifest_MgmtSvc,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\MgmtSvcEvents.man")
    MSI (s) (D8:D4) [09:04:15:580]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI520.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\MgmtSvcEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\MgmtSvcEvents.man. Incorrect function.
    MSI (s) (D8:10) [09:04:15:609]: Executing op: ActionStart(Name=UninstallManifest_ReportingSvc,,)
    MSI (s) (D8:10) [09:04:15:609]: Executing op: CustomActionSchedule(Action=UninstallManifest_ReportingSvc,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="wevtutil.exe" um "C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcReportingEvents.man")
    MSI (s) (D8:AC) [09:04:15:611]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI540.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcReportingEvents.man(0): Error 0x800c0005: At column=0, The system cannot locate the resource specified.
    CAQuietExec: 
    CAQuietExec:  Failed to load xml document C:\Program Files\Microsoft HPC Pack 2008 R2\Bin\HpcReportingEvents.man. Incorrect function.
    ...

    MSI (s) (D8:10) [09:04:38:052]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:38:053]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:90) [09:04:38:054]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI5D05.tmp, Entrypoint: ExecuteSqlStrings
    ExecuteSqlStrings:  Error 0x80040e14: failed to execute SQL string but continuing, error: The server principal 'QUANTIFINY\WBRADNEYHPCRTM$' already exists., SQL key: Diag_AddHeadnodeLogin SQL string: create login  from windows
    MSI (s) (D8:10) [09:04:39:087]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:39:088]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:E4) [09:04:39:090]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI610D.tmp, Entrypoint: ExecuteSqlStrings
    ExecuteSqlStrings:  Error 0x80040e14: failed to execute SQL string but continuing, error: The server principal 'QUANTIFINY\WBRADNEYHPCRTM$' already exists., SQL key: Rpt_AddHeadnodeLogin SQL string: create login  from windows
    MSI (s) (D8:10) [09:04:39:421]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:39:422]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:14) [09:04:39:423]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI6257.tmp, Entrypoint: ExecuteSqlStrings
    MSI (s) (D8:10) [09:04:39:788]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:39:789]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:A8) [09:04:39:791]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI63CF.tmp, Entrypoint: ExecuteSqlStrings
    ExecuteSqlStrings:  Error 0x80040e14: failed to execute SQL string but continuing, error: Cannot drop the user 'ccpheadnode', because it does not exist or you do not have permission., SQL key: Schd_DropHeadnodeUser SQL string: drop user 
    MSI (s) (D8:10) [09:04:39:917]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:39:918]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:60) [09:04:39:920]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI644D.tmp, Entrypoint: ExecuteSqlStrings
    ExecuteSqlStrings:  Error 0x80040e14: failed to execute SQL string but continuing, error: Cannot drop the user 'ccpheadnode', because it does not exist or you do not have permission., SQL key: Diag_DropHeadnodeUser SQL string: drop user
    MSI (s) (D8:10) [09:04:40:075]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:40:076]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:2C) [09:04:40:077]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI64EA.tmp, Entrypoint: ExecuteSqlStrings
    ExecuteSqlStrings:  Error 0x80040e14: failed to execute SQL string but continuing, error: Cannot drop the user 'ccpheadnode', because it does not exist or you do not have permission., SQL key: Rpt_DropHeadnodeUser SQL string: drop user
    MSI (s) (D8:10) [09:04:40:344]: Executing op: ActionStart(Name=ExecuteSqlStrings,Description=Executing SQL Strings,)
    MSI (s) (D8:10) [09:04:40:345]: Executing op: CustomActionSchedule(Action=ExecuteSqlStrings,ActionType=25601,Source=BinaryData,Target=**********,CustomActionData=**********)
    MSI (s) (D8:F0) [09:04:40:346]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI65F4.tmp, Entrypoint: ExecuteSqlStrings
    ...

    MSI (s) (D8:94) [09:05:54:561]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI8815.tmp, Entrypoint: CAQuietExec
    CAQuietExec: 
    CAQuietExec:  SERVICE_NAME: hpcmanagement
    CAQuietExec:          TYPE               : 10  WIN32_OWN_PROCESS 
    CAQuietExec:          STATE              : 4  RUNNING
    CAQuietExec:                                  (STOPPABLE, NOT_PAUSABLE, ACCEPTS_SHUTDOWN)
    CAQuietExec:          WIN32_EXIT_CODE    : 0  (0x0)
    CAQuietExec:          SERVICE_EXIT_CODE  : 0  (0x0)
    CAQuietExec:          CHECKPOINT         : 0x0
    CAQuietExec:          WAIT_HINT          : 0x0
    MSI (s) (D8:10) [09:05:54:609]: Executing op: ActionStart(Name=StartBNServices,,)
    MSI (s) (D8:10) [09:05:54:610]: Executing op: CustomActionSchedule(Action=StartBNServices,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="cmd.exe" /c net.exe start HpcBroker)
    MSI (s) (D8:C0) [09:05:54:612]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI8845.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  The requested service has already been started.
    CAQuietExec: 
    CAQuietExec:  More help is available by typing NET HELPMSG 2182.
    CAQuietExec: 
    CAQuietExec:  Error 0x80070002: Command line returned an error.
    CAQuietExec:  Error 0x80070002: CAQuietExec Failed
    CustomAction StartBNServices returned actual error code 1603 but will be translated to success due to continue marking
    MSI (s) (D8:10) [09:05:54:710]: Executing op: ActionStart(Name=SetServiceReg,,)
    ...

    CAQuietExec: 
    MSI (s) (D8:84) [09:05:59:116]: Executing op: ActionStart(Name=Install_RemoveDiagnosticTests1,,)
    CAQuietExec:     Ended : Wed Aug 04 09:05:59 2010
    MSI (s) (D8:84) [09:05:59:117]: Executing op: CustomActionSchedule(Action=Install_RemoveDiagnosticTests1,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="test.exe" remove udfsvcloading)
    MSI (s) (D8:44) [09:05:59:117]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI99F4.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  Error: Test alias udfsvcloading is not valid.
    CAQuietExec:  Error 0xffffffff: Command line returned an error.
    CAQuietExec:  Error 0xffffffff: CAQuietExec Failed
    MSI (s) (D8:84) [09:05:59:510]: Executing op: ActionStart(Name=CopyToSetupSharedFolder,,)
    ...

    CAQuietExec: 
    MSI (s) (D8:84) [09:05:59:561]: Executing op: ActionStart(Name=Install_RemoveDiagnosticTests2,,)
    CAQuietExec:     Ended : Wed Aug 04 09:05:59 2010
    MSI (s) (D8:84) [09:05:59:561]: Executing op: CustomActionSchedule(Action=Install_RemoveDiagnosticTests2,ActionType=3137,Source=BinaryData,Target=CAQuietExec,CustomActionData="test.exe" remove excelworkbook)
    MSI (s) (D8:B8) [09:05:59:562]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI9BAB.tmp, Entrypoint: CAQuietExec
    CAQuietExec:  Error: Test alias excelworkbook is not valid.
    CAQuietExec:  Error 0xffffffff: Command line returned an error.
    CAQuietExec:  Error 0xffffffff: CAQuietExec Failed
    MSI (s) (D8:84) [09:05:59:679]: Executing op: ActionStart(Name=InstallDiagnosticTests,,)

    Thursday, August 5, 2010 1:00 PM
  • In SQL Server error log:

    2010-08-04 09:02:52.42 spid7s      Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
    2010-08-04 09:02:52.42 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'COMPUTECLUSTER'.
    2010-08-04 09:02:52.42 spid7s      
    2010-08-04 09:02:52.42 spid7s      ----------------------------------
    2010-08-04 09:02:52.42 spid7s      Execution of INSTMSDB.SQL complete
    2010-08-04 09:02:52.42 spid7s      ----------------------------------
    2010-08-04 09:02:52.63 spid7s      
    2010-08-04 09:02:52.63 spid7s      Populate syssubsystem table...
    2010-08-04 09:02:52.66 spid7s      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
    2010-08-04 09:02:52.67 spid7s      Using 'xplog70.dll' version '2007.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'fulltext_stopwords', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'fulltext_stoplists', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'fulltext_index_fragments', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'database_audit_specification_details', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'database_audit_specifications', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'conversation_priorities', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'change_tracking_tables', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'spatial_index_tessellations', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'spatial_indexes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'function_order_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'table_types', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'system_sql_modules', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'plan_guides', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'module_assembly_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'type_assembly_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'fulltext_index_catalog_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'service_queue_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'parameter_type_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.74 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.74 spid7s      Cannot find the object 'column_type_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'message_type_xml_schema_collection_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'parameter_xml_schema_collection_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'column_xml_schema_collection_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'asymmetric_keys', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'internal_tables', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'certificates', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'crypt_properties', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'key_encryptions', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'symmetric_keys', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_collections', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'transmission_queue', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'routes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'remote_service_bindings', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_component_placements', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_wildcard_namespaces', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_wildcards', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_attributes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_model_groups', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_elements', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_facets', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_types', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_components', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'xml_schema_namespaces', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'extended_properties', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'database_files', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'conversation_endpoints', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'conversation_groups', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'service_contract_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'services', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'service_contract_message_usages', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'service_contracts', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.75 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.75 spid7s      Cannot find the object 'service_message_types', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'fulltext_catalogs', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'destination_data_spaces', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'partition_schemes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'filegroups', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'data_spaces', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'partition_range_values', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'partition_parameters', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'partition_functions', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'assembly_references', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'assembly_files', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'assemblies', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'database_permissions', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'database_role_members', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'database_principal_aliases', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'database_principals', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'schemas', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'assembly_types', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'types', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'sql_dependencies', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'service_queues', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'synonyms', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'numbered_procedure_parameters', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'numbered_procedures', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'assembly_modules', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'sql_modules', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'trigger_events', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'events', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'event_notifications', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'triggers', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'procedures', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'foreign_key_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.76 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.76 spid7s      Cannot find the object 'foreign_keys', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'default_constraints', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'check_constraints', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'key_constraints', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'fulltext_index_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'fulltext_indexes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'stats_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'stats', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'index_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'allocation_units', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'partitions', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'xml_indexes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'indexes', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'identity_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'computed_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'system_parameters', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'parameters', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'system_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'system_views', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'system_objects', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'extended_procedures', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'views', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'tables', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.77 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.77 spid7s      Cannot find the object 'objects', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.79 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.79 spid7s      Cannot find the object 'all_sql_modules', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.79 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.79 spid7s      Cannot find the object 'all_parameters', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.79 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.79 spid7s      Cannot find the object 'all_columns', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.79 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.79 spid7s      Cannot find the object 'all_views', because it does not exist or you do not have permission.
    2010-08-04 09:02:52.79 spid7s      Error: 15151, Severity: 16, State: 1.
    2010-08-04 09:02:52.79 spid7s      Cannot find the object 'all_objects', because it does not exist or you do not have permission.
    2010-08-04 09:02:53.11 spid7s      
    2010-08-04 09:02:53.11 spid7s      Revoke any permission to public role...

    Thursday, August 5, 2010 1:03 PM
  • can you try this command

     

    Sqlcmd -S .\computecluster -Q "ALTER DATABASE HPCScheduler SET AUTO_CLOSE OFF",

    does this help?

    if it doesn't then you may have to

    1) run this command (Sqlcmd -S .\computecluster -Q "ALTER DATABASE HPCScheduler SET AUTO_CLOSE OFF", )

    2) uninstall HPC

    3) reinstall HPC - this should succeed.

    4) confirm with logs for same errors

    Mark

    Thursday, August 5, 2010 11:04 PM
  • It could also be related to this....

     

    http://support.microsoft.com/kb/976899/en-us:

     

     

    Friday, August 6, 2010 5:36 PM
  • I'm having the same problem I think, so thought I'd jump into this post (fyi...Im very new to HPC and Windows Server).

    I've got a fresh install of Windows Server 2008 R2 HPC edition and have set up a new domain for the head node. I've tried installing HPC pack and get as far as the HPC pack 2008 server components when the installation fails( SQL server SP1 installs fine as far as I can tell, as do the client components). The installation gets bar gets right to the end where it says starting services, then fails and starts rolling back. I've looked at the setup logs and get pretty much identical errors as seen above by wbradney.

    I've tried reinstalling many times to no avail and have also tried the command shown above...which gives this result;

    C:\Users\Administrator>Sqlcmd -S .\computecluster -Q "ALTER DATABASE HPCSchedule
    r SET AUTO_CLOSE OFF"
    Msg 5011, Level 14, State 5, Server WIN-TSK8CBU425S\COMPUTECLUSTER, Line 1
    User does not have permission to alter database 'HPCScheduler', the database doe
    s not exist, or the database is not in a state that allows access checks.
    Msg 5069, Level 16, State 1, Server WIN-TSK8CBU425S\COMPUTECLUSTER, Line 1
    ALTER DATABASE statement failed.

    I've also tried the cumulative update 6 for SQL server SP1 with no improvement. Is there another work around or manual install for the HPC server components

    Any help would be much appreciated!

    Jake :)

     

     

    Thursday, October 28, 2010 2:32 PM
  • Dear Jake,

     

      Sometimes if there are errors with multiple installation attempts with SQL and HPC you may need to first

    - Uninstall HPC and remove any residual HPC components in Program Files - and remove the Dirs where you stored the SQL data and logs. 

    - Uninstall SQL (cleaning out everything related to SQL in Program Files and Program Files (x86)

    - Check for pending updates and KB's (as above)

    - Then install SQL

    - Then install HPC

    Hope this helps.

    Mark

     

    Saturday, November 13, 2010 12:02 AM
  • Hello, I have the same problem when try to install Sharepoint 2010 on Windows 7 x64  (http://msdn.microsoft.com/en-us/library/ee554869.aspx).

    I installed all additionals without errors:

     7. If you are using Windows Vista Service Pack 1, Windows Vista Service Pack 2, or Windows 7, install the following additional prerequisites:

     

    Restart notebook, run SharePoint setup in standalone mode and get 20-30 errors like this:

    Error Cannot find the object 'all_objects', because it does not exist or you do not have permission. MSSQL$SHAREPOINT

    I have no HPC on my notebook. And haven't ideas about this problem. I uninstall all components, delete all old dirs, reinstall -- the same result -- errors.

    Help, please.

     

     

    Friday, January 14, 2011 1:06 PM