SCCM 2012 SQL Troubleshooting FAQs

This page contains the various categories for the SCCM 2012 SQL Troubleshooting FAQs.

Errors

• “The process cannot access the file because it is being used by another process” when trying to copy a Database

Installation

• “C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQL Server 2008R2\resources\1033\setup.rll is either not designed on Windows or it contains an error.”

Site Databases

• Why are my Site Databases different sizes?

SPNs

• “error 0x2098/8344 -> Insufficient access rights to perform the operation” when trying to run setspn
• Setspn -L fails with “FindDomainForAccount: Call to DsGetDcNameWithAccountW failed with return value 0x0000054B”

SQL Server Management Studio

• Why does SQL Server Management Studio crash as soon as I try to open a new Query window?