[Windows Server 2008] Installing SQL Server 2008

★ 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 2008
· SQL Server is a database that is widely used in Windows platforms and has excellent performance, often in conjunction with ASP and ASP.

1. Preparatory work
• I have downloaded the installer in advance, is an ISO file, requires a virtual drive mode, so we also need to download the virtual CD drive.

2. Installing SQL Server
• We install to the D drive.
· SQL Server is already installed.

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
It is not recommended to use the SA account to connect to the database, which is more dangerous.
• Create a database user first
• CREATE DATABASE permission mappings again

5, test database connection is normal
You can connect to the database through ASP.

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.

Accompanying documents:
<%
Option Explicit
Response.buffer=true
Dim conn
Set Conn=server.createobject ("Adodb.connection")
Const database= "HWS"
Const username= "Hws_user"
Const password= "hws123"
Conn.Open "Provider=sqloledb;data source= (local); uid=" &Username& ";p wd=" &Password& ";d atabase=" &database
Response.Write "The database connection is OK."
Conn.close
Set conn=nothing
%>

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

[Windows Server 2008] Installing SQL Server 2008