[Windows Server 2003] Installing SQL Server 2005

★ Welcome to The Guardian God · V Classroom, website address: http://v.huweishen.com
★ Guardian God · V Classroom is a Web site dedicated to providing server instructional video for the Guardian God, updated weekly video.
★ This section we will lead you: Install SQL SERVER 2005

· SQL Server is a database that is widely used in Windows platforms and has excellent performance, often in conjunction with ASP and ASP.
• This section takes SQL Server 2005 as an example, and SQL Server 2008 has a similar installation method.

1. Preparatory work
• Download SQL Server in http://soft.huweishen.com/.
• Virtual drive mode is required for installation, so we also need to download the virtual CD drive.

2. Installing SQL Server
• We install to the D drive.

3. Create a Database
• Database names are suggested to start with a letter, and if you start with a number, you'll get a lot of trouble later.

4. Create a secure connected user

• Create a database user first
• CREATE DATABASE permission mappings again

5, test database connection is normal

If you need to create multiple databases, repeat steps 3, 4.

If you also want to learn more about SQL Server operations (such as security settings, database restores, etc.), please refer to my station other videos.

Now that this section is over, please visit the Guardian God website (www.huweishen.com) for more instructional videos.

Reprint please specify the source (http://v.huweishen.com/video/17.html), thank you!

[Windows Server 2003] Installing SQL Server 2005