Close

SQL 2012

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

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