Om4mp.png' alt='Problems Installing Sql Server 2005 On Server 2008 R2' title='Problems Installing Sql Server 2005 On Server 2008 R2' />I am running windows server 2008 R2. I need to uninstall the remains of my sql 2005 install, but it will just not uninstall. I went through the addremove. SQL Server 2005 Service Pack 4 is now available on Microsoft Update MU Windows Update WU. Minimize downtime when patching clusters by upgrading your SQL Server 2005 clusters to SQL Server 2008 to take advantage of its rolling upgrade functionality. SOLUTION SCCM Query to Obtain SQL Server Version Edition. I need assistance creating an SCCM Query that will tell me which version and edition of SQL Server each server that has SQL on it is running. Specifically I need to know if its running SQL 2. Windows Xp Sp3 Gladiator Vista V3.0. MSDE, Standard, Enterprise, Datacenter, Etc, or SQL 2. MSDEExpress, Standard, Enterprise, Datacenter, Etc, SQL 2. MSDEExpress, Standard, Enterprise, Datacenter, Etc, or SQL 2. R2 MSDEExpress, Standard, Enterprise, Datacenter, EtcMy original Shown Below query gives me the first part of the SQL version whether it is running SQL Server 2. For content related to previous versions of SQL Server, see Installation for SQL Server 2014. Documentation to help you install, configure, and use SQL Server. The. Starting with SQL Server 2008, the local Administrators group is no longer added by default during SQL Server setup you even have to use a manual step to add the. SQL Server articles, scripts, and discussion groups. What version of SQL Server do I have This unofficial build chart lists all of the known Service Packs SP, Cumulative Updates CU, patches, hotfixes and other. Sqlnclix64. msi cannot be found while installing SQL Server 2005 64bit on Windows Server 2008 R2. SQL Server 2. 00. SQL Server 2. 00. MSDEExpress, Standard, Enterprise, Datacenter, or some other edition is not returned by the SCCM Query below. I am hoping there is a quick and easy way to modify my original SCCM Query shown below so that I can grab and display the edition information that corresponds to each servers version information. Original SCCM Queryselect distinct SMSRSystem. Resource. Id, SMSRSystem. Resource. Type, SMSRSystem. Name, SMSRSystem. Client, SMSGSystemADDREMOVEPROGRAMS. Display. Name, SMSGSystemCOMPUTERSYSTEM. Model, SMSGSystemCOMPUTERSYSTEM. Manufacturer, SMSGSystemCOMPUTERSYSTEM. Number. Of. Processors from  SMSRSystem inner join SMSGSystemADDREMOVEPROGRAMS on SMSGSystemADDREMOVEPROGRAMS. Resource. ID SMSRSystem. Resource. Id inner join SMSGSystemCOMPUTERSYSTEM on SMSGSystemCOMPUTERSYSTEM. Resource. ID SMSRSystem. Resource. Id where SMSGSystemADDREMOVEPROGRAMS. Display. Name Microsoft SQL Server 2. SMSGSystemADDREMOVEPROGRAMS. Display. Name Microsoft SQL Server 2. SMSGSystemADDREMOVEPROGRAMS. Display. Name Microsoft SQL Server 2.