Shulou(Shulou.com)06/02 Report--

How to install sql on Cloud Virtual Machine? In response to this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more small partners who want to solve this problem find a simpler and easier way.

Some novice users don't know how to install SQL in Cloud Virtual Machine. Here we introduce the process of installing SQL 2008 in Cloud Virtual Machine according to the sharing of netizen named [Suzhou WeChat].

I. Installation preparation

1. Requires. Net framework 3.5, if 3.5 SP1 support is required on Vista or later OS (installation will be updated automatically before SQL2008 installation).

2. Widnows PowerShell support is required, WPS is a very powerful Shell application, commands are compatible with DOX/UNIX and support direct calls to. NET modules for line command editing, it is worth further study of the tool (SQL2008 installation will automatically update the installation).

3. Windows Installer needs to be successfully started, version 4.5 or above is required, and the service startup status needs to be checked.msc.

4. MDAC 2.8 sp1 support is required (XP and above systems have been integrated).

5. If Visual Studio 2008 has been installed on the cloud host, you need support for VS 2008 sp1 or above, and you need to download and install it from MS website.

II. Configuration process

1. Install SQL Server 2008 on a new PC by selecting the installation option,"New SQL Server Standalone or to an existing installation feature," and a default SQL instance will be installed.

2. Function selection. For installing only database server, the function selection can not be formulated according to actual work needs. General selection: database engine service, client tool connection, SQL Server Books Online, management tools-basic, management tools-complete. Database engine service is the core service of SQL database. Analysis and Reporting services can be installed according to deployment requirements. These two services may require IIS support.

3. For column setting, you can directly select the default instance for installation, or multiple data service columns in the same server can be installed according to different column names.

4. Server configuration, server configuration is mainly the configuration of the service startup account, the account name of the service is recommended to use NT AUTHORITY\SYSTEM system account, and specify the startup type of the currently selected service.

5. Database engine configuration. In the current configuration, SQL login authentication mode and account password are mainly set. Mixed mode is recommended for authentication with SQL data storage directory and authentication mode. The password of SQL Server system administrator account (sa) built in during installation is special.

SQL 2008 requires a relatively high password strength for SA, consisting of upper and lower case letters, numbers and symbols, otherwise you are not allowed to continue installation. It is best to specify the local system administrator in Specify Sql Server Administrator.

About how to install sql on the Cloud Virtual Machine, the answer to the question is shared here. I hope the above content can be of some help to everyone. If you still have a lot of doubts, you can pay attention to the industry information channel to learn more relevant knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.