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 […]
Active Directory Creation On Windows Server 2016 – using a Virtual Machine running under Windows 10 Pro Hyper-V Screenshots: DNS: AD should now be functional, for other servers to join this domain. Note, most core production servers use static ip addresses , and not dynamic/DHCP as might be seen in the screenshots […]
Screenshots of upgrading SQL Server 2016 to SQL Server 2017 [vNext – the latest release as the posting of this atricle]
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.
For SQL 2014/2016: Concise guide here: Quick Start: Extended events in SQL Server – click here Root URL on extended events – click here.
Screenshots on setting up active Directory on Windows Server 2012/2016: after installing Windows Server and running all updates Add the role Active Directory – server manager,local server,add roles and features wizard, AD Domain services
In order to get this to work in Windows 10 , l ran the command below. Install-module -Name SqlServer -Scope CurrentUser – Force -AllowClobber Useful Links: Powershell Gallery Download SSMS -SQL Server Management Studio
“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 […]
Microsoft SQL Server 2016 – Basic Installation in picture steps. Note the differences from SQL 2012/2014 installation. Also, SSMS [SQL Server management studio] 2016 is a separate installation which you can download from here, Links Hardware and software requirements Installation of SQL 2016 SSMS 2016