Close

Microsoft SQL Server

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 2016 Cluster – Partially Running – CEIP

SQL Server 2016 Cluster – Partially Running [half red/half green] – came across below issue, and upon further investigation l noticed the nodes has CEIP versions of Analysis services as well as Agent. Simply removing these roles, returned the server roles status to running/green   Click here for reference link on msdn.microsoft forum Click here […]

Read More

SQL Server Error – SSMS GUI – Mismatch in column datatype and tessellation scheme

When below error occurs, remember to change the Tesselation scheme, in this case from Geometry grid to Geography auto [if the case]   Example code:   SET ARITHABORT ON SET CONCAT_NULL_YIELDS_NULL ON SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON SET NUMERIC_ROUNDABORT OFF   GO CREATE SPATIAL INDEX [SpatialIndex-Vegetation1] ON [dbo].[VEGETATION1] […]

Read More