How do I find out what version of SQLExpress is installed?

Note: You must be an Administrator to perform this solution.

1. Open a Command Prompt Window.

2. Type the following command and then press Enter.

    

   OSQL –S servername\instancename –Usa

    

   Where servername\instancename is replaced with the host name of the computer\the instance name if you installed SQL with one and –U is replaced with the database username. The default database user is sa. Depending on your installation environment this may be different.

    

3. If you have successfully logged into the SQL server a 1> will display. At the 1> type select @@version and press enter.

4. At the 2> type go.

    

   Example:

   1> select @@version

   2> go

    

5. Press Enter.

6. The version of SQL Express should be displayed.

Example 1:

DocuShare 6.6.1 Build 257, 801 and later include:

Microsoft SQL Server 2012 - 11.0.2100.60 (Intel X86)

Example 2:

DocuShare 6.6.1 Builds139 and earlier include:

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)

Note: DocuShare 6.01 and older Legacy versions included MSDE bundled with DocuShare which is no longer supported. If you are still running a legacy version of DocuShare, upgrading to the latest version is strongly recommended.

Solution Published: June 21, 2016

Solution ID: 1754