win2008 R2 Web Environment Configuration MSSQL Server 2008 R2 installation graphics and text tutorial and remote connection settings method _win Server

Microsoft®sql Server™ is a database management and analysis system for e-business, line-of-business, and data warehousing solutions. Is Microsoft's business database software. Now that the latest version has been developed to SQL Server 2014, Microsoft has launched a Windows Azure SQL Cloud database.

The purpose of this tutorial is to lead you to install SQL Server 2008 R2, for each step to make a general explanation, said the place, please point out, we common progress.

This server is the sky Wing Cloud 1 yuan host, bought is for everybody to do the tutorial use. If everyone feels good, please pay more attention to this blog.

Installation steps

1, first, before installing the database, please restart the server first. I've already unpacked the SQL ISO file, so just double-click Setup.exe,

Click "New installation or add functionality to existing installation" directly.

The Installer Support Rules page, which is preceded by a green tick, is passed, directly "OK",

Enter the product password,

Accept the license terms, must support ... Otherwise, Microsoft is not to use.

Installer support file, click "Install", the following figure

Finish loading as shown above, I here Firewall alarm, this does not matter, next,

Select SQL Server feature installation, and Next,

Select the features you want to install, because sometimes you can use tools such as manager on the server, so I choose all of them here. If you're unsure about what functionality you need, select it all first.

At the same time modify the "shared feature directory" for D disk down the path, as shown above.

Again, the rules of Detection, Microsoft is very meticulous.

My server is the first time to install SQL 2008 R2, so directly with the default instance MSSQLServer. A single server can install multiple instances.

The instance ID cannot be the same.

For the SQL service account, I use the Network Service account for easy management.

Cloud-dwelling Community Small Note: You can create a new normal user, so you can customize the operation of low privileges, it is indeed more secure than 2003. 2003 is the SQL Server service that runs directly on the system administrator account.

Set up a good service account situation, as shown above.

Our SQL is used to do the site database, so it is recommended to use "Mixed Mode", and the SA account to set a password, the password needs to meet the complexity requirements. and add the current user as the database administrator account.

Modify the related directory of the database, all set to the D disk directory,

Also add the current user as Analysis Services administrator,

"Install native mode default configuration",

Once again configure the rule, as long as the green hook can be installed down,

The path to the configuration file, which preserves the various configurations we set up earlier, and starts the installation,

Installation will be slow, depending on the server configuration, installation time, as long as the patient waiting for installation can be completed.

After the slow installation, finally installed, directly open SSMs login to see it.

Because the SSMS is used directly on the server and there is only one default database instance, fill in the server name bar directly. , you can also use "127.0.0.1" or "localhost".

If you have more than one instance, you need to precede it with an instance name, such as 127.0.0.1\newsqlserver.

On-machine logon, authentication can be used with Windows authentication and SQL Server authentication.

Remote connection Settings

We can not modify the database every time Remote Desktop to the server, the most use is to use the local SSMS manager to connect remote database server, so we have to set up to support remote connection database. If everyone is installed like me, just add a SQL inbound rule to the firewall.

Open firewall, inbound rule, new rule,

Here I select the port, also can select the program.

The SQL SERVER default port is 1433,

Allow connections,

Rule scope,

Save it with a name.

Open the SSMs manager locally, fill in the server's IP address and sa password to log on to the database server, just as easily as operating a local database.

There are many tutorials on the web that need to turn on the SQL Server Browser service, but I don't have this service open here.

This concludes the article.

Welcome to the discussion.

Original works, allow reprint, reprint, please be sure to hyperlink form to indicate the original source of the article, author information and this statement. Otherwise, legal liability will be held.