Upgrade Server 2012 (In Place)
Upgrade Server 2012 KB ID 0001802 Server 2012 End Of Life Windows Server 2012 (and Windows Server 2012 R2) will go end of life on October 10th 2023. Start planning to migrate your productions workloads off this platform as soon as you can. I’ve mentioned before on the site, I’m not a fan of ‘in place’ upgrades, you get to migrate all the ‘broken bits’ (that you didn’t realise were broken), and...
Error sqlservr.exe is using too much memory
KB ID 0000190 Problem Seen on SBS 2008 with WSUS. The Windows internal database (the one used by WSUS) has no memory reservation limit, so it can use as much as it wants, this is a BAD thing! Your server will struggle because the following consumes to much memory. SQL/MSSQL$MICROSOFT##SSEE Solution 1. Click Start > In the search/run box type CMD {enter}. 2. At command line issue the following commands, sqlcmd -S...
SQL Install Error “SQL Server Browser Service Group Does Not Exist”
KB ID 0000689 Problem Seen when reinstalling SQL 2008 R2 on a domain controller. Note: as a background the SQL Server was installed previously and then the server was promoted to a domain controller. Then when the attempt to reinstall SQL was carried out this happened: Microsoft SQL Server 2008 R2 Setup The following error has occurred. SQL Server Browser service group does not exists. Check for earlier failures in the setup Note:...
Microsoft SQL – ‘Error While Enabling Windows Feature : NetFx3’
KB ID 0000958 Problem I was installing SQL Server 2012 and suddenly this popped up; The following error has occurred: Error while enabling Windows feature: NetFx3, Error Code: -2146498298, Please try enabling Windows feature: NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features, see http://go.microsoft.com/fwlink/?linkid=227143 Solution I’ve been bitten by .Net on...
SQL Sever 2012 Setup Error – Rule ‘Setup Account Privileges’ Failed
KB ID 0000976 Problem When trying to install SQL Server 2012 (Standard c/w SP2). This popped up; Rule Check Result Rule “Setup account privileges” failed. The account that is running SQL Server Setup does not have one or all of the following rights: the right to back up files and directories, the right to manage auditing and the security log and the right to debug programs. To continue, use an account with both of these...