程序博客网 > 侧吸 顶吸 知乎

SQL Server 2014 安装图解

来源：互联网 发布：侧吸 顶吸 知乎 编辑：程序博客网 时间：2024/06/05 08:17

今天在虚拟机上搭建了SQL Server 2014，顺便将安装步骤进行了整理，此次安装的是SQL Server 2014 Enterprise Edition x64版本，具体安装图解如下：

 

  1. 打开安装文件，找到Setup.exe并双击；

Machine generated alternative text:Th P 〔 DVD Drive (E:) SQL2014 ENU 4 Date modified 占 24 ／ 2m4 1 之 45 AM 占 24 ／ 2m4 1 之 45 AM 占 24 ／ 2m4 1 之 45 AM 占 24 ／ 2m4 1 之 45 AM 占 24 ／ 2m4 1 之 45 AM 占 24 ／ 2m4 1 之 47 AM ' 7 2m4455 AM 」 ' 2 」 ' 2m4 」 2 AM 21 2m4 17 P M 1 引 7 ／ 2m4 i27 P M 占 21 ／ 2m4 20 P M 占 21 ／ 2m4 20 P M V 0 Search DVD Drive (E.) SQL201 " ， 0 Name 10 ENU LP redist Streamlnsight Tools ' Media nfo setup setup 獸 已 | SqlSetupBootstr | sqmapi.dll per.dll Size 70 KB 1 KB 1 § 」 KB 147 KB Fi 丨 e folder Fi 丨 e folder Fi 丨 e folder Fi 丨 e folder Fi 丨 e folder Fi 丨 e folder Setup Information XML Document Application CONFIG Fil e Application extens … Application extens …

  1. 新搭建选项第一项"New SQL Server stand-alone …."；

Machine generated alternative text:Planning Tools Advanced Options MicrosoftSQL Server2014 Installatio New SQL Server stand alone installation or add features to an existing installation La u n ch wizard to installSQL Server 2014 i n a non-cl d envlronment or to add features to n existing SQL Server 2014 i n New SQL Server failover cluster installation Launch a wizard to install a single-node SQL Server 2014 failover cluster. Add node to a SQL Server failover cluster Launch a wizard to add a node to an existing SQL Server 2014 failover cluster. Upgrade from SQL Server 20 〕 ， SQL Server 20 〕 ， SQL Server 20 〕 B R2 or SQL Server 2012 La u n ch wizard to upgrade SQL Server 20 〕 ， SQL Server 20 〕 ， SQL Server 20 〕 8 R2 or SQL Server 2012 to SQL Server 201

  1.  弹出的画面中填写key值，License页面选择accept，点击Next；

Machine generated alternative text:SQL Server 2014 Setup License Terms 10 In 靈 訓 SQL Server 2014 you must accept the Microsoft Software License Terms. Produ ey License Terms Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete MICROSOFT SOFTWARE LICENSE TERMS MICROSOFT SQL SERVER 201 ENTERPRISE SERVER/CAL [ DI 丨 10 These llcense terms are an agreement between Microsoft Corporation ()r based on where you 小 ， one of affiliates) and 四 上 Please read them. They apply to the software named above, which includes the media on which you received 怎 f any. The terms 引 so apply to any Microsoft updates, supplements, 丨 丨 丨 accept the license terms. Copy 以 目 rl nt n Customer Experience Improvement Program (" 〔 E ， " 〕 and Error Repotting to help improve the ellablllty and performance of Microsoft SQL Sewer 2D14 ． See the Microsoft L Server 2m4 P ， 1M30 Statement for more Information. ， Microsoft SQL Server 2014 0 includes Visual S 忆 匕 io component th will have CE settings turned 0 切 ' default. If Visual & u ， 0 is In ， 匕 this component ill use the CEIP settings for Visual Studio ' 〔 Next ， Cancel

  1. SQL Server自动进行安装前检查，都成功后点击Next；

Machine generated alternative text:SQL Server 2014 Setup 6 № b 引 Rules Setup Global R 了 ” identify problems that might 000ur wh n i n 引 I SQL Server Setup support files. Failures must be corrected before Setup can contlnue. Re-run Cancel Status Passed Passed Passed Passed Passed Passed Passed Passed Passed Next ， Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete Operation completed Pa e Fal led 0. Warning0. Skipped 0 Hide details ' ' View detai I ed re rt @ @ @ @ @ @ @ @ Ru I e Setup administrator Setup 〔 〔 aunt privileges computer Wi n d OWS Management Instrumentation (WMI) service 00n en 彎 validation for SQL Server registry' Long path names to files on SQL Server installation media SQL Server Setup P rod u ct Incompatibility ． N ET 2 £ n d .NET 5 Service 1 update for Wi n d OWS 20 〕 B " Edition WOV 4 platform ' 〔

  1. 下面弹出的Microsoft Update和Product Updates直接点击Next；

Machine generated alternative text:SQL Server 2014 Setup Microsoft Update use Microsoft Update to check for Important updates Product Key Global Rules Microsoft Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete M 忑 rc 0 什 Update 0 ， fe 低 security' n 匕 other important updates for Windows and other Microsoft of ， N 以 r ： including SQL Server 2014 Updates are delivered using Automatic 」 p 匕 or you 03n Visit the M 忑 rc 0 什 Update website. [ 囗 use M 忑 rc 0 什 Update to check for updates (recommended) Next ， Cancel Microsoft u Microsoft u Statement ' 〔

 

Machine generated alternative text:SQL Server 2014 Setup Install Setup Files ， an update forSQL ServerSetup found and specified to be Included, the update Will be In 靈 引 引 Next ， Cancel Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete Scan for product updates Down I oa d Setup files Extra ct Setup files I n 訓 Setup files Status Completed Skipped Skipped N ot stated ' Back

  1. 在弹出的安装规则检查都成功后点击Next；

Machine generated alternative text:SQL Server 2014 Setup Install Rules Setup rules identify potential problems that might 0 = = ur while running Setup Fal I u res must be 00 “ ecte 以 before Setup Re-run Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete Operation completed Pa e 引 6 Fal led 0. Warning 1 ． Skipped 0 Hide details ' ' View detai I ed re rt Status Passed Passed Passed Passed Passed Passed Cancel @ @ @ @ @ 小 @ Ru I e Fusion ct 卜 止 Template Library (ATL 〕 Previous releases of SQL Server 20 〕 B Business Intelligence Devel.. 00n en 彎 validation for SQL Server registry' Computer d 0m n controller Microsoft ． N ET Application Security Wi n d Ows Fi rewall 引 0 i n 訓 when Microsoft SQL Server 2014 CTPI is present. ' Back Next ，

  1. 本次安装为了存储SharePoint数据，选择第一项“SQL Server Feature Installation”；

Machine generated alternative text:SQL Server 2014 Setup Setup Role 0 ic 疑 the SQL Server Feature I ， t 引 tia ， 1 0 ion to in 匕 ivi 匕 u ， ， select which featu re 00mp0 ， len 乸 ， 0 i ， -'Stall, or 以 ic featu re role to In 靈 訓 specific configuration Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Feature Configuration Rules Ready to Install Installation Progress Complete · SQL Sewer Feature 丨 n 靈 引 t 丨 on 丨 n 靈 訓 SQL Server Database E ， 1 ， ， -'e Services, An 訓 is Services Reporting SeNices Integration Services, and other featu res. SQL Sewer 目 owe ， ot for ShareP01nt 丨 n 靈 訓 PowerPivot ， or SharePoi ， It on 3 new or existing ShareP01nt sewer ， 0 support PowerPivot data access i ， 1 the farm 0 ion ， ， add the SQL Sep.'er r 回 at n 引 以 3 b e engine to use the new farm's d t 以 b 以 server 丨 丨 匕 d SQL Server Database Relational Engine Services to this installation. （ 〕 All Featu res With Defaults 丨 n 靈 訓 訓 features using default values forthe service accounts. Cancel ' 3a 〔 Next ，

  1. Features中默认全部勾选，大家也可以根据需要选择部分安装；

Machine generated alternative text:Feature Selection Select the Enterprise featu res to In 靈 訓 SQL Server 2014 Setup Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Features: I n Features Database Engine Services SQL Server Replication Fu I I Text n d Semantic Extractions for S Data Quality Services An is Services Reporting Services - Native Shared Features Reporting Services - SharePoint Reporting Services Add-in for SharePoint P r Data Quality Client Client Tools Connectivity Integration Services Feature description The configuration n d operation of each i nsta n ce feature Of SQL Sewer i nsta n ce isolated from other SQL Server instances SQL Prerequisites for selected features: Already installed: 一 Wi n d Ows PowerSheII 2 £ D 疑 Space Requirements Drive 0 ， 〕 28 MB required, 37g57 MB available Select All Unselect All C.IProgram FilesWicrosoft SQL Serverl C.IProgram FilesWicrosoft SQL Serverl C.IProgram Files (x86 〕 lMicrosoft SQL Serverl Instance dlrectory Shared feature directory: Shared feature directory ， 8 ， ： ' 〔 Next ， Cancel

  1. 设置默认实例还是命名实例，根据需要选择即可；

Machine generated alternative text:SQL Server 2014 Setup Instance Configuration Specify the name and Instance ID for the Instance of SQL Sewer. Instance ID becomes pat of the In 靈 引 t ℃ n path Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install @ Default Instance （ 〕 Named Instance: Instance 丨 0 SQL Server directory na ， 引 Services directory Reporting Services directory MSSQLSERVER MSSQLSERVER C.IProgram FileslMlcrosoft SQL ServerlMSSQL12. MSSQLSERVER C.IProgram FileslMlcrosoft SQL ServerlMSAS12. MSSQLSERVER C.IProgram FileslMlcrosoft SQL ServerlMSRS12. MSSQLSERVER 丨 n 靈 引 d Instances: I nsta n ce Nam Features ' 3a 〔 Edition Next ， Cancel I nsta n ce I D

  1. Service选择了默认，需要时再修改；

Machine generated alternative text:SQL Server 2014 Setup Server Configuration Speclfy the e e 以 〔 乸 and collatlon conflguratlon use 以 separate account for each SQL Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Service oun Collation Microsoft recommends that pu SQL Semer Agent SQL Server Database Engine SQL Server n y 卣 Services SQL Server Reporting Services 4000unt Nam NT ServicelSQLSERVERA... NT ServicelMSSQLSERVER NT ServiceWSSQLServe NT ServicelRepoftServer NT ServiceWsDtsServer.. NT ServicelSQL Server D.. NT ServicelSQL Server D.. NT ServiceXMSSQLFDLa... NT AUTHORITYXLOCAL " Password Startup Type Ma n ual Automatic Automatic Automatic Automatic Ma n ual Ma n ual Manual Disabled Cancel SQL Server Integration Services 12 £ SQL Server Distributed Replay Client SQL Server Distributed Replay 00n ． " SQL Fu I I text Filter Daemon Launc... SQL Server Browser ' 〔 Next ，

  1. 认证方式和数据默认存储路径，可根据需要调整。建议认证方式选择Mixed Model，这样即使Windows认证的用户无法访问时，也可以用超级用户sa连接；

Machine generated alternative text:SQL Server 2014 Setup Database Engine Configuration Specify D 以 t 以 b 以 Engine authentication security mode, administrators and data directories. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Server Configuration Data Directories FILESTREAM Specify the authentication mode and 以 匕 min tr 以 to forthe Databa Engine Authentication Mode （ 〕 Windows authentication mode M.: ， Mode 阝 QL Sewer authentication and Windows authentication) Specify the password for the SQL Sewer system administrator ， 丬 account. Enter password: Confirm password: Specify SQL Server 匕 min tr 以 to CET'üIC;eciminiftretcr ， 匕 mini 噩 tc 以 Next ， SQL administrators have unrestricted 〔 〔 e to the Database Engine Cancel Add Current user 匚 巨 囗 ] ' 〔

  1. 设置Service的用户，可以使用当前用户，也可以点add新加用户；

Machine generated alternative text:SQL Server 2014 Setup Analysis Services Configuration Specify n ， 引 Services server modes administrators and data directories. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration Analysis Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Configuration Data Directories Server Mode: （ 〕 Multidimensional and Data Mining Mode （ 〕 Tabular Mode Specify which users have administrative permissions for na ， 引 Services. CET'üIC;eciminiftretcr (Administratcr) Next ， An y 卣 Services administrators have unrestricted 〔 〔 e to An i ' Services. Cancel Add Current user Remove ' 〔

  1. Reporting Service配置，选择只安装，需要时候再配置；

Machine generated alternative text:SQL Server 2014 Setup Reporting Services Configuration Specify the Reporting Services configuration mode. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Re 巾 四 Services Configuram Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Reporting Services Native Mode （ 〕 丨 n 靈 訓 and configure Installs 引 configures the repot sewer In n mc 匕 已 The report server operatio ， 1 引 after setup completes. @ 丨 n 靈 訓 on ， Installs the report server files. After in 鼯 tion, use Repo ， ti ， Services Configuration Manager conflgure the server for natlve 匕 已 Reporting Services ShareP01nt Integrated Mode @ 丨 n 靈 訓 on ， ． Installs the report server files. After installation use SharePoi ， It Central Administration to complete the configuration. Verify the SQL Sewer Reporting Services semice 靈 ar d 引 create at one SQL Reportlng service p ， 工 ion ． For more Information, c 疑 Help. ' 〔 Next ， Cancel

  1. 填写要使用的用户；

Machine generated alternative text:SQL Server 2014 Setup Distributed Replay Controller Specify Distributed Replay ControllerseNlce 3 “ e permissions. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay （ on 0 e Distributed Replay Client Feature Configuration Rules Ready to Install Specify which users have permissions for the Distributed Replay Controllerservice. CET'üIC;eciminiftretcr ， 匕 mini 噩 tc 以 Next ， Users that have been granted permission will have u n I i m 〔 〔 e to the Distributed Replay Cancel Add Current user 匚 巨 囗 ] ' 〔

  1. 直接点击Next；

Machine generated alternative text:SQL Server 2014 Setup Distributed Replay Client Specify the corresponding controller and data directories for the Distributed Replay Client. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Specify controller mac h Ine name and directory locations. Controller Name: Working Directory Result Directory C.IProgram Files (x86 〕 lMicrosoft SQL ServerlDReplayClientlWorkingDirl C.IProgram Files (x86 〕 lMicrosoft SQL ServerlDReplayClientlResultDirl ' 〔 Next ， Cancel

  1. Overview页面，点击Install进行安装；

Machine generated alternative text:SQL Server 2014 Setup Ready to Install 、 ri ， the SQL Server 2014 features to be in 靈 訓 ． Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Ready to In 靈 訓 SQL Server 2D14 ． Summary Edition: Enterprise - Action: Install (Product Update) Prerequisites Already installed: Windows PowerSheII 2 £ Microsoft ． N ET Framework 王 5 Microsoft ． N ET Framework 4 £ To be installed from media: 一 Microsoft Visual Studio 2010 Redistributables 一 Microsoft Visual Stu d i 0 2010 Shell Microsoft Visual Studio Tools for Applications 3 £ General Configuration Database Engine Services SQL Server Replication Fu I I Text n d Semantic Extractions for Search Configuration file path: CAProgram FilesXMicrosoft SQL Server112DsSetup B00 trap \ Log \ 201 以 〕 514 14202"onfigurationFile.ini ' 〔 丨 n 靈 引 Cancel

  1. 等待安装直至完成。

Machine generated alternative text:Installation Progress Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install SQL Server 2014 Setup FulltextCcnflgActlcn In 靈 訓 shutdownnclnstance Cpu64 Next ， Cancel

 

Machine generated alternative text:SQL Server 2014 Setup Complete YourSQL Server 2014 In 靈 引 t ℃ n completed successfully With product updates. Product Key Global Rules Mi “ 0 ' 0 Update Product Updates Install Setup Files Install Rules Setup Role Feature Selection Feature Rules Instance Configuration Server Configuration Database Engine Configuration An i ' Services Configuration Reporting Services Configuration Distributed Replay Controller Distributed Replay Client Feature Configuration Rules Ready to Install Information 以 bc 上 the Setup operation or pc 引 b next steps: Feature Management Tc c Is ． Ccmplete Client Tools Connectivity Client Tools SDK Client Tools 〔 w d Compatibility Management Tools Basic D 歐 引 Status Succeeded Succeeded Succeeded Succeeded Succeeded Viewing od " ct Documentation for SQL Server Only the components that you u s e to 、 w and manage the documentation for SQL Server have been installed "default the Help Viewer component u s e s the online library After installing SQL Server you can u s e the Help Library Manager component to download documentation to your local computer For more information s e e Use Microsoft Books Onlinefor SQL Server Chtt a_micrasaft com/fi.vlink/7LinklDz2gg57b Summary og file has been 以 ve 匕 to the following 丨 0 〔 以 t 丨 on 0 P ram Files Microsoft Serve 1 20 Setu 300t 靈 r 以 umma 2015 20160514 142D 2 § txt 20160614 142D2 § 00

  1. 此时，打开SQL Server，能够正常访问使用，安装成功。

Machine generated alternative text:Connect to Server M icrosoft SQL Server 2014 Servertwe Server name Password: Database Engine S 9201 E Windows 」 thentication DEMONzdministrator [ 囗 Remember password [ 〕 〕 〕 ] 匚 [ 〕 〕 ]

 

Machine generated alternative text:File Edit View 0b 」 ect Explorer Debug Tools Window Help ， New Qu 」 匕 彎 刂 一 」 」 卜 0 ． Mlcrosoft SQL Server Management StudlO (Admlnlstrator) ， ， ， 寻 | 凵 丨 冫 2D1 5 阝 QL Semer 12.0.2000 - DEMO 囗 二 Databases 囗 System Databases 囗 二 Database Snapshots 囗 Security 囗 Server Objects 囗 Replication 囗 AlwaysOn High Availability 囗 Management Integration Services Catalogs SQL Server Agent (Agent XPs d isa b I

 

感谢阅读！

0 0
侧吸 顶吸 知乎 侧吸 顶吸 知乎
原创粉丝点击
热门IT博客
最有效的淘宝付费推广最有效的淘宝付费推广
十金数据财经日历十金数据财经日历
淘宝卖家工具排名
淘宝玉石吊坠
北拓投资怎么样 知乎
服务器端软件包括什么
信贷资源配置需要优化
剑倚天下仙骑进阶数据
天津建站优化推广
阿里大文娱数据打通
美国警察 黑人 知乎
金蝶无法引出数据
软件方案文档模板
营养配餐软件下载
闲鱼淘宝二手
剑3怎么导入捏脸数据
淘宝人气浏览器插件
JavaScript招聘
计算机的软件系统
淘宝商家入驻资料
热门问题 老师的惩罚 人脸识别 我在镇武司摸鱼那些年 重生之率土为王 我在大康的咸鱼生活 盘龙之生命进化 天生仙种 凡人之先天五行 春回大明朝 姑娘不必设防，我是瞎子 软鞋 包邮女童鞋 为什么白鞋包卫生纸还会黄 鞋类三包 鞋包批发网 包鞋 鞋的三包规定 聚划算鞋包 耐克鞋三包期多久 包臀裙配什么鞋 女士鞋包 月子鞋一定要包跟吗 鞋包批发市场 鞋包店装修效果图 鞋包店铺名字 羽毛球包 鞋袋 鞋包 鞋包网站 鞋包店铺 鞋包柜 衣鞋包 鞋包服饰 丹比奴鞋包 品牌鞋包 软底休闲鞋 鞋白边有黑印小窍门 耐克鞋盒钢印 白鞋上的黑印怎么去掉 兴昂鞋厂 鞋厂招聘 找事8鞋厂 裕元鞋厂 鞋厂招工 宝元鞋厂 宁波鞋厂 鞋厂图片 鞋厂设备 附近鞋厂 鞋厂代加工 鞋厂验厂 鞋厂胶水

程序博客网，程序员的互联网技术博客家园。csdn论坛精品 msdn技术资料都在这里