Close

Windows Server 2008 R2

Sample Configurationfile.ini

Below is a sample configurationfile.ini which can be used for an unattended/automatic installation of SQL 2012/2014 This file is usually found here [for SQL 2012 installs]: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log For 2014 Installations, change 110 to 120 in the above path. To generate this, run the GUI setup almost to the end, answering installation […]

Read More

Resolving SQL Server Agent Job Issue – System.InvalidOperationException: Unable to generate a temporary class (result=1)

Below is the final error message l kept getting when setting up a SQL Server Agent Job which ran an SSIS package. The SSIS package is designed to create a folder in a network share as well as copy some files into that folder.   Message Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 […]

Read More

Windows Server 2008 R2 – Disable UAC

Steps to disable UAC on Windows Server 2008 R2. In some situations, UAC hinders full functionality of some SQL Server components such as SSIS 2008/2012/2014 Click on Start button Control Panel User Accounts Change UAC Settings Slide down to Never notify Select OK Select Yes Restart Computer/Server  

Read More