Close

SQL 2014

SQL Server 2016 – DQS Error – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySession”:

Got this error below while attempting to run DQC – Data Quality Client – which previously worked on this SQL Server which had previously an ok/verified DQS – Data Quality Server installation. Error text: SQL Server Data Quality Services ——————————————————————————– Message Id: LogOnWindowFailedToConnect Cannot connect to <SERVER>. A .NET Framework error occurred during execution of […]

Read More

Security Update for SQL Server 2014 Service Pack 2 GDR (KB3194714)

“KB Articles: KB3194714 Security bulletins:SQL Server 2014 MS16-136 Security issues have been identified in SQL Server 2014 Service Pack 2 that could allow an attacker to compromise your system and gain control over it. You can help protect your computer by installing this update from Microsoft. After you install this item, you may have to […]

Read More

SQL Server Fixed Server Role Permissions

SQL Server Fixed Server Role Permissions – run – sp_srvrolepermission ServerRole Permission bulkadmin Add member to bulkadmin bulkadmin BULK INSERT dbcreator Add member to dbcreator dbcreator ALTER DATABASE dbcreator CREATE DATABASE dbcreator DROP DATABASE dbcreator Extend database dbcreator RESTORE DATABASE dbcreator RESTORE LOG dbcreator sp_renamedb diskadmin Add member to diskadmin diskadmin DISK INIT diskadmin sp_addumpdevice […]

Read More

Unable to start execution of step 1 (reason: JobOwner domain\domainuser

On a server running SQL 2014 SSIS with SSISDB configured, one of the SQL Agent jobs configured to run using a proxy account kept failing with the error below. Message Unable to start execution of step 1 (reason: JobOwner domain\domainuser doesn‘t have permissions to use proxy 1 for subsystem SSIS). The step failed. Solution that […]

Read More

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

Transferring logins and passwords between separate SQL server Instances

Transferring logins and passwords between separate SQL Server instances eg SVR1\DEV to SVR1\DEV2 can be done by scripting out the encrypted passwords using the stored procedures sp_hexadecimal and sp_help_revlogin which can be found by following this detailed link by clicking here.

Read More