How to Identify the Current SQL Server Version and Edition Installed in xPortalNet Server PC

Problem (Issue) Statement:	How to identify the current SQL Server version and edition installed in xPortalNet Server PC
Description:	A guide to identify current SQL Server version and edition installed in xPortalNet Server PC. Assume that require to plan for relocate current XPNDB to new workstation or computer or simulate current site complaint with site XPDB. The first though that is "What is the MS SQL version and edition using on site".
Related Software:	xPortalNet PS/ xPortalNet Lite/ xPortalNet Standard v1.5 xPortalNet v1.0 Microsoft SQL Server
Related Hardware:	NA
System Application:	NA
Symptom and Finding:	NA
Cause:	For first time guide to identify current SQL Server version and edition installed in xPortalNet Server PC.
Solution:	Warning! Users are not recommended to run any xPortal software in Windows XP* operating system as the system is unstable* Users are also advised to stop the xPortal Services before shutting down the Server PC* to prevent any missing transaction issues.* . . Summary: Method 1: Check MS SQL Server Version using SQL Server Properties. Method 2: Use SQL Query to find installed MS SQL server version. . Note Users may choose either Method 1 OR Method 2 to identify the installed SQL Server version. . Step-by-step Guide: Method 1: Check MS SQL Server Version Using MS SQL Server Management Studio: Step 1: Open the MS SQL Server Management Studio and connect to your SQL Server database. Figure 1: Microsoft SQL Server Management Studio Window Connected to the SQL Database . Step 2: Right-click the server name in the Object Explorer panel and click Properties. Figure 2: Clicking Properties from the Right-click Menu under Server Name . Step 3: The Server Properties window will be shown. In the General page, users will be able to see the relevant information such as the Product and Version details of the installed SQL instance. Figure 3: Server Properties Window Showing the SQL Server Edition and SQL Server Version Information . . Method 2: Use SQL Query to find installed MS SQL server version: Step 1: Open the MS SQL Server Management Studio and connect to your SQL Server database. Figure 4: Microsoft SQL Server Management Studio Window Connected to the SQL Database . Step 2: Click the New Query icon to launch an SQL command. Figure 5: Click New Query Icon to Launch an SQL Command . Step 3: Type Select @@Version in SQL command window. Figure 6: Typing the Command in the SQL Command Window . Step 4: Click the Execute icon in the menu ribbon. Figure 7: Click the Execute Icon in the Menu Ribbon . Step 5: The following Results panel will be shown, indicating the information of the installed SQL instance. Figure 8: Information about the Installed SQL Instance Shown in the Results Panel
Common Issue	NIL
Date Documentation:	24/3/2020 (Rev 1.0)