MSSQL

How to upgrade MS SQL 2014 to SQL 2017

Download the required version. https://www.microsoft.com/en-us/sql-server/sql-server-editions-express The Installation Wizard starts the SQL Server Installation Center. To upgrade an existing instance of SQL Server, click Installation in the left-hand navigation area, and then click Upgrade from… previous versions of SQL Server. Accept the license agreement. Here you can choose to allow Microsoft updates to pull updates for …

How to upgrade MS SQL 2014 to SQL 2017 Read More »

How to Enable SA Account in Microsoft SQL Server

backup failed for server (Microsoft.sqlserver.smoextended) Enable the sa Login: https://cd3f8ecrzb5lep7f5cd57r4vd2.hop.clickbank.net/ Method 1: 1. Connect to the SQL Server instance using SSMS and go to Security. Expand Security, go to Logins.2.  You can see the sa account is disabled when you install SQL Server using Windows Authentication mode. 3. Right-click on the sa account and go …

How to Enable SA Account in Microsoft SQL Server Read More »

Get Weekly KBV Tips !

Learn and improve day to day Knowledge & lifestyles.