如何使用命令行安装SQLEXPRESS [英] How to install SQLEXPRESS using command line

问题描述

你好....
我只想通过我的vb.net应用程序包含SQLEXPRESS部署

我目前正在手动运行SQLEXPRESS安装程序，
在这种情况下，

首次安装时未显示默认实例"选项
下次尝试时，它会显示默认实例"选项，并且安装成功完成



所以，我只想问一个问题，
1.为什么在安装过程中每次都需要浪费两次尝试.
2.还有其他安装SQLEXPRESS的方法(例如使用命令行)

Hello There....
I just want to include the SQLEXPRESS deployment through my vb.net application

I am currently running the SQLEXPRESS setup manually,
In this case,

First time the installation doesn''t shows the "Default Instance" option
At next attempt, it shows the "Default Instance" option and the setup is completed successfully



So, I just wanted to ask,
1. Why I need to waste two attempts every time during installation.
2. Is there any other way to install SQLEXPRESS (like by using command line)

推荐答案

使用以下命令行并替换instancename和password:

Use the following command line and replace the instancename and password:

SQLEXPR32.EXE /qb ADDLOCAL=ALL INSTANCENAME=<instancename> SECURITYMODE=SQL SAPWD=<password> SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0</instancename>

这篇关于如何使用命令行安装SQLEXPRESS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！