烂泥：SQL Server 2005数据库安装-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

烂泥：SQL Server 2005数据库安装

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:57 PM

Installdatabase

本文首发于烂泥行天下。为了能更好的利用服务器，所以打算把该业务进行迁移。因为该业务比较特殊，需要服务器上有相应的硬件支持，所以打算直接升级该服务器目前

为了能更好的利用服务器，所以打算把该业务进行迁移。因为该业务比较特殊，需要服务器上有相应的硬件支持，所以打算直接升级该服务器目前的操作系统。目前公司服务器使用的windows server 2003 32bit企业版。如果使用虚拟机的话，只能安装32bitOS，所以打算直接升级OS，安装成windows server 2008 R2 64bit。

但是在进行升级之前，需要对该业务的数据库进行备份。该业务数据库使用的是SQL Server 2005。说实话，以前对SQLServer数据库不是很熟悉。只能先在测试机器上进行测试。

首先在测试机器上安装windows server 2008 R2，，如下图：

clip_image001

下载SQLServer2005 64bit进行安装,然后进行安装。

clip_image002

点击下一步

clip_image003

监测安装必备组件

clip_image004

clip_image006

clip_image008

检查安装SQLServer 2005所需要的条件

clip_image009

clip_image010

在这要选择SQL Server Database Services组件，如果要使数据库可以自动备份数据库的话，在此一定要选择Intergration Services组件。同时也可以根据实际的情况，进行选择具体所要安装的组件。

clip_image011

clip_image012

实例名称我们在此选择默认。

clip_image013

在服务帐户中选择“使用内置系统帐户”中的“本地系统”。

clip_image014

“身份验证模式”中我们选择“混合模式”。

clip_image015

clip_image016

clip_image017

clip_image018

clip_image019

安装完毕后，我们来配置SQLServer相关IP地址，如下图：

clip_image020

clip_image021

可以看到TCP/IP是禁用状态

clip_image022

clip_image023

clip_image024

clip_image025

clip_image026

本文出自 “烂泥行天下” 博客，请务必保留此出处

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles