On later versions of Windows (e.g. Windows 10, Windows Server 2012), Microsoft no longer mdtq.vns earlier versions of SQL Server Express, such as 2005 and 2008 R2, which are included with Wasp products InventoryControl, MobileAsset, and WaspTime.

Bạn đang xem: Sql server download quick links


As a result, Wasp"s automated installers can fail to install SQL Server Express properly (with no error given), and manual installations of SQL Server Express give compatibility warnings and/or various error messages (e.g. 1935).
To work around these issues, SQL Server 2012 Express can be downloaded and installed instead. Read, understand, and follow the steps, including running the batch file (or follow the manual installation article below).

Xem thêm: 1 Tháng 6 Là Ngày 1/6 Là Ngày Gì? Nguồn Gốc Và Ý Nghĩa Của Ngày 1/6


As noted by Microsoft, Windows needs .NET v3.5 SP1 and .NET v4.x enabled/installed before installation. These are usually enabled by default.Due to the size of the download, it may take a while to complete. Do not change the filename; otherwise the batch file below won"t work. Save the file to your PC; don"t just run the installer from the download link.After SQL Server 2012 Express is installed, the Wasp product"s installer will normally see the existing WASPDBEXPRESS SQL instance, and install its databases into it. If you are installing the Enterprise edition of a Wasp product, and the database installer prompts for server connection information and does not automatically fill in the server name, you will need to enter the server name and instance name into the server box, like \WASPDBEXPRESS. The username is sa, and the password is Wasp$07Wasp$07

 

Advanced User Info:

The procedure above will work for all editions of the Wasp software (Standard, Professional, and Enterprise) and for both 32-bit and 64-bit Windows. The following information is optional for advanced users with the Enterprise edition of Wasp software only.

Note 1: The Standard and Professional editions of Wasp products MUST use the 32-bit version (x86) as listed above, and will not work with the 64-bit version (x64) below. (This is true regardless of whether you have 32 or 64-bit Windows.)Note 2: Enterprise editions of Wasp products can use the 32-bit version (x86), and also have the option of using the 64-bit version (x64), 3rd checkbox ENU\x64\SQLEXPRWT_x64_ENU.exe (1.1 GB).

Note 3: SQL Server 2014 Express also comes in both 32-bit and 64-bit editions, but Wasp has not tested (and will not) IC, MA & WT with versions later than 2012. We have no reason to believe there would be a problem with 2014.

Note 4: SQL Server 2016 and later are only available in 64-bit edition, meaning the Standard and Professional edtions of IC, MA & WT will not work with them. The Enterprise editions of IC, MA & WT are expected to work with these later SQL versions, but Wasp has not tested with them.Alternate, direct link to the 64-bit file (Ent only). DO NOT use this for Standard or Professional editions. If you don"t know what you have, use the 32-bit one above.https://download.microsoft.com/download/F/6/7/F673709C-D371-4A64-8BF9-C1DD73F60990/ENU/x64/SQLEXPRWT_x64_ENU.exe

For 64-bit: Use this batch file instead of the one above:http://dl.mdtq.vn.com/kb/sql/WaspAutoInstallSQL2012Exp-x64.zip

extracted batch file contents

setup.exe /QS /IACCEPTSQLSERVERLICENSETERMS /ACTION=INSTALL /features=sql,is,tools /INSTANCENAME=WASPDBEXPRESS /SECURITYMODE=SQL /SAPWD="Wasp$07Wasp$07" /ISSVCSTARTUPTYPE=Automatic /BROWSERSVCSTARTUPTYPE=Automatic /SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1 /SQLSVCACCOUNT="NT AUTHORITY\Network Service" /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"pause