November 3, 2019 Vignesh Sathiyanantham

AWS offers two main options for deploying SQL Server in the cloud – Elastic Compute Cloud and Relational Database Service. I lately read a few blogs and did some searches with both the types of deployment of SQL Server and learnt a few things, in this blog, I am sharing my findings Relational Database Service AWS RDS offered a Database as a Service (DaaS). It removed the complete complexity of installing, configuring the database. All instance options exposed by AWS are configured on the RDS dashboard. Options such as license model, port number, domain membership, authentication mode, backup settings etc….

November 3, 2019 Vignesh Sathiyanantham

After the availability of SQL Server 2019 and Windows Server 2019, I decided to play around with that in my lab. Microsoft, owing to the new demands and other technological advancements in the software industry, has released the upgraded version of SQL Server 2017, which is the SQL server 2019. This was announced and introduced in the Ignite 2018 event, on September 24th. However, this was just a preview edition. A more technically advanced and detail picture of SQL Server 2019, was submitted only in the PASS Summit, which happened later in November, in the same year. The newer version…

April 20, 2019 Vignesh Sathiyanantham

We got a support case user created a backup of the Virtual Machines with MS SQL running but he cannot see the databases running on the machine We checked the added credential, it was Windows Active Directory user added to administrator groups, after we disable the UAC on the Windows Server 2019 user can able to list all the backups To Disable the UAC on Windows Server 2019 Right-click at the bottom of the Windows Server 2012 Start screen, select All apps and click Run.Enter regedit and click OK. The Registry Editor window opens.Expand HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > policies > system.Right-click EnableLUA, and then select Modify.In Value data, enter 0 and then click OK. The following message displays:You must restart your computer…

January 18, 2019 Vignesh Sathiyanantham

One of our Nimesa customers get this error on Event Logs, CheckTokenMembership. hr = 0x80070005, Access is denied when he takes a consistent backup using Nimesa. We found out this error is from VSS Requestor, This happens when UAC(user account control) is active. Which blocks even the administrators group users from performing operation in admin mode. Right-click at the bottom of the Windows Server Start screen, select All apps and click Run.Enter regedit and click OK. The Registry Editor window opens.Expand HKEY_LOCAL_MACHINE > SOFTWARE > Microsoft > Windows > CurrentVersion > policies > system.Right-click EnableLUA, and then select Modify.In Value data, enter 0 and then click OK.  The following message displays:You must restart your computer to turn off User Account Control Click to restart this computer

January 18, 2019 Vignesh Sathiyanantham

When we are deploying our Nimesa Appliance and running on client environment, we noticed that there are no disk serial number for virtual disks on Windows server 2016, later we came to know that deployment of Windows Server 2016 happened using deprecated vSphere thick client As per the VMware KB article, If the VM is not created with vSphere WebClient, the advanced parameter “disk.EnableUUID” is not set. and we have noticed this issue happening only with Microsoft Windows Server 2016 not in Windows 2k12 and 2K12 R2 In this scenario, we have to set the enable the disk UUID for…