Deploy ODBC Settings via Group Policy
KB ID 0000805 Problem I’ve briefly mentioned this before when I wrote about Group Policy Preferences so when I had to do this on-site this week, I jumped straight into the group policy management console, and found that because my ODBC connection was using SQL authentication (with the SQL sa account), this would NOT WORK, (it only works with Windows authentication and even then it needs a tweak). If you are using SQL...
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...
SCCM Install Error “The site server computer’s machine account does not…”
KB ID 0000296 Problem Seen while installing System Center Configuration Manager 2007 Error: Setup cannot complete the specified installation on this computer for the following reasons. The site server computer’s machine account does not have Administrator’s privileges on the SQL server selected for the site database installation. To install a Configuration Manager site, all servers must be in an active directory domain...
Install SCCM 2007 on Windows Server 2008 R2 – Step by Step
KB ID 0000297 Problem I had to work out how to do this for a client, and as is my modus operandi, I’ll try and save you some of the pain I endured, Products Used System Center Configuration Manager 2007 SP2 Windows Server 2008 R2 SQL 2008 R2 (At time of writing neither officially supported or not supported on SCCM) Note: I was originally going to use SQL 2005 – hence the reason the SQL servers name is SCCM-SQL2005, however...
Windows SBS – Moving the Windows Software Update Services Database (SUSDB.mdf)
KB ID 0000609 Problem Last week a client rang in to say their servers system drive was running out of room. A quick scan showed me the biggest thing on there was a 12 GB database called SUSDB.mdf. A few searches told me what I’d already guessed from the name, WSUS was the offender, so I set about moving it to their data drive that had lots of free space. Solution 1. Launch the Windows SBS Console > Backup and Server Storage...