SLTechnology News&Howtos › Servers ›

Sql Server_2008 installation and configuration

Shulou Source: shulou.com Published: 2022-06-02 20:46:10 09月22日 Update

One: prepare the system environment before installation

Install NetFx20SP2_x86 and ndows Installer 4.5 (WindowsServer2003-KB942288-v4-x86)

Two: install SqlExpress_2008

2.1 Environmental detection

2.2 agree to the agreement

2.3 default instance name

2.4 Select an account to run the service

2.5 both SQL account and Windows system account login are supported.

So far the installation has been successful

Three: configure SQL 2008 snooping

Finally, telnet 192.168.41.51 1433 test listening port

Four: configure the client connection tool

4.1 install the DotNet35_SP1 patch tool and download the SQLManagementStudio_x86_CHS.exe client connection tool

4.2 install the SQLManagementStudio_x86_CHS.exe client connection tool

Download the windows powershell patch and retest after WindowsServer2003-KB926140-v5-x86-CHS.exe installation

Five: test the connection to the database

5.1 windows identity login authentication database connection

5.2 SQL Server identity login authentication database connection