XWG: How to find out the XSW database version in SQL SERVER?

XWG: How to find out the XSW database version in SQL SERVER?

The easiest way is to Open the SQL Server Management Studio and run the below query. In the example below, the database version is XSW 3.25.
  1. Open Microsoft SQL Server Management Studio.
  2. Click to open Databases folder 
  3. Right click on the XYGATESW database
    1. select Run Query
in the query editor space enter:
select * from [common].[xyVer]

click the Execute button.



In the column for DB_Version will give you the version of XSW.


If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.


 

    • Related Articles

    • XSW: "Incompatible database version" error generated during connection test

      Customer can use upgrade option on the XSW Data Management tool to upgrade the Database to the version compatible with GUI. Steps: 1. Opening the XSW Data Management GUI 2. Making sure Server Instance Name and Authentication Mode are both correct. 3. ...

    • XSW: How to add new XSW users to the XSW SQL server database

      To assign a new user to the xsw_role, In SQL server management studio, select: Security logins right-click on the user to be added to the xsw_role properties user mapping then select xsw_role and hit "OK" to save the change. If you are unable to ...

    • XSW: "Incompatible Database Version" Wrong Error

      The actual problem was found in the SQL database error log, this error was " Error occurred - schema common cannot be created." The Database User, who will be creating the database should have the sysadmin role (or similar permissions to a sysadmin ...

    • XSW: Enabling SQL Remote Connections

      Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. 1. Open MS/SQL Management Studio and right-click server name in the left pane and select Properties 2. Select Connections in the left pane and ...

    • XSW: how to configure read only access for users accessing the XSW SQL server database

      Currently, ?sysadmin? access is needed to even start the XSW GUI and connect to the SQL DB. So, the read-only access for a user is not working and is not supported. If you are unable to locate the solution needed or if you need additional assistance ...