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 […]
SQL Server 2017 Development Edition Installation – installation source , click here.
Error screenshots and resolution. Issue from SSMS 2017 – Click here to download SSMS 2017 Get Powershell Gallery from this link. Click here.
Issue: SQL Server 2016 would not send mail on a new server migration to Windows Server 2016 Solution: By default, Windows Server 2016 installs .net framework 4.7 The database mail feature needs .Net 3.5 Install this windows feature and this issue gets resolved.
“R is a free software environment for statistical computing and graphics” – source click here. Useful links: Getting Started with Microsoft R Client Microsoft R Installing DeployR for Microsoft R Server 2016 (8.0.5) on Windows Set up SQL Server R Services (In-Database) SQL Server 2016 R Services: Guide for Server Configuration Quick notes: You […]
Highlights and useful links. SQL Server 2016 SQL Server on Linux Microsoft Data management and analytics
Below is an error that showed up while trying to execute a stored procedure on instance X from SQL server instance y. MYSERVER here represents the name of SQL Server instance X Msg 7411, Level 16, State 1, Line 1 Server ‘MYSQLSERVER′ is not configured for RPC. Solution to this was to set RPC in/out […]
Click here for the download link for Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013 – this installs Microsoft SQL Server Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services that support Visual Studio 2013, SSIS 2012/2014 etc.
Click here for a download link for this useful SQL Server 2012 System Views Map – in PDF and XPS file format(s)