Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Sql Server_2008 installation and configuration

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

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

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

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report