.
Setting Up Tools For Data Warehouse Development Environment
(SQL SERVER + VISUAL STUDIO)
Appendix 1 |
Password = Pa$$w0rd |
Analysis Service Configuration |
Reporting Service Configuration |
Run Sql Server Configuration Manager to start/stop the server |
Right-click the icon, select properties, go to the service tab, select start mode, select manual. |
Installation Configuration C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20220824_221638\ConfigurationFile.ini |
;SQL Server 2016 Configuration File [OPTIONS] ; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter. ACTION="Install" ; Specifies that SQL Server Setup should not display the privacy statement when ran from the command line. SUPPRESSPRIVACYSTATEMENTNOTICE="False" ; By specifying this parameter and accepting Microsoft R Open and Microsoft R Server terms, you acknowledge that you have read and understood the terms of use. IACCEPTROPENLICENSETERMS="False" ; Use the /ENU parameter to install the English version of SQL Server on your localized Windows operating system. ENU="True" ; Setup will not display any user interface. QUIET="False" ; Setup will display progress only, without any user interaction. QUIETSIMPLE="False" ; Parameter that controls the user interface behavior. Valid values are Normal for the full UI,AutoAdvance for a simplied UI, and EnableUIOnServerCore for bypassing Server Core setup GUI block. UIMODE="Normal" ; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and False or 1 and 0. By default SQL Server Setup will include updates that are found. UpdateEnabled="True" ; If this parameter is provided, then this computer will use Microsoft Update to check for updates. USEMICROSOFTUPDATE="False" ; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS, MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality Services (DQS) server. The Tools feature will install shared components. FEATURES=SQLENGINE,DQ,DQC,CONN,IS,SDK,SNAC_SDK,MDS ; Specify the location where SQL Server Setup will obtain product updates. The valid values are "MU" to search Microsoft Update, a valid folder path, a relative path such as .\MyUpdates or a UNC share. By default SQL Server Setup will search Microsoft Update or a Windows Update service through the Window Server Update Services. UpdateSource="MU" ; Displays the command line parameters usage HELP="False" ; Specifies that the detailed Setup log should be piped to the console. INDICATEPROGRESS="False" ; Specifies that Setup should install into WOW64. This command line argument is not supported on an IA64 or a 32-bit system. X86="False" ; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine (SQL), Analysis Services (AS), or Reporting Services (RS). INSTANCENAME="MSSQLSERVER2016" ; Specify the root installation directory for shared components. This directory remains unchanged after shared components are already installed. INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server" ; Specify the root installation directory for the WOW64 shared components. This directory remains unchanged after WOW64 shared components are already installed. INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server" ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will incorporate the instance ID of the SQL Server instance. INSTANCEID="MSSQLSERVER2016" ; TelemetryStartupConfigDescription SQLTELSVCSTARTUPTYPE="Automatic" ; TelemetryUserNameConfigDescription SQLTELSVCACCT="NT Service\SQLTELEMETRY$MSSQLSERVER2016" ; TelemetryStartupConfigDescription ISTELSVCSTARTUPTYPE="Automatic" ; TelemetryUserNameConfigDescription ISTELSVCACCT="NT Service\SSISTELEMETRY130" ; Specify the installation directory. INSTANCEDIR="C:\Program Files\Microsoft SQL Server" ; Agent account name AGTSVCACCOUNT="NT Service\SQLAgent$MSSQLSERVER2016" ; Auto-start service after installation. AGTSVCSTARTUPTYPE="Manual" ; Startup type for Integration Services. ISSVCSTARTUPTYPE="Manual" ; Account for Integration Services: Domain\User or system account. ISSVCACCOUNT="NT Service\MsDtsServer130" ; CM brick TCP communication port COMMFABRICPORT="0" ; How matrix will use private networks COMMFABRICNETWORKLEVEL="0" ; How inter brick communication will be protected COMMFABRICENCRYPTION="0" ; TCP port used by the CM brick MATRIXCMBRICKCOMMPORT="0" ; Startup type for the SQL Server service. SQLSVCSTARTUPTYPE="Manual" ; Level to enable FILESTREAM feature at (0, 1, 2 or 3). FILESTREAMLEVEL="0" ; Set to "1" to enable RANU for SQL Server Express. ENABLERANU="False" ; Specifies a Windows collation or an SQL collation to use for the Database Engine. SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" ; Account for SQL Server service: Domain\User or system account. SQLSVCACCOUNT="NT Service\MSSQL$MSSQLSERVER2016" ; Set to "True" to enable instant file initialization for SQL Server service. If enabled, Setup will grant Perform Volume Maintenance Task privilege to the Database Engine Service SID. This may lead to information disclosure as it could allow deleted content to be accessed by an unauthorized principal. SQLSVCINSTANTFILEINIT="False" ; Windows account(s) to provision as SQL Server system administrators. SQLSYSADMINACCOUNTS="LAPTOP-NQBCHBNR\razzi" ; The default is Windows Authentication. Use "SQL" for Mixed Mode Authentication. SECURITYMODE="SQL" ; The number of Database Engine TempDB files. SQLTEMPDBFILECOUNT="8" ; Specifies the initial size of a Database Engine TempDB data file in MB. SQLTEMPDBFILESIZE="8" ; Specifies the automatic growth increment of each Database Engine TempDB data file in MB. SQLTEMPDBFILEGROWTH="64" ; Specifies the initial size of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILESIZE="8" ; Specifies the automatic growth increment of the Database Engine TempDB log file in MB. SQLTEMPDBLOGFILEGROWTH="64" ; Provision current user as a Database Engine system administrator for %SQL_PRODUCT_SHORT_NAME% Express. ADDCURRENTUSERASSQLADMIN="False" ; Specify 0 to disable or 1 to enable the TCP/IP protocol. TCPENABLED="0" ; Specify 0 to disable or 1 to enable the Named Pipes protocol. NPENABLED="0" ; Startup type for Browser Service. BROWSERSVCSTARTUPTYPE="Disabled" |
Installation report |
Overall summary: Final result: Passed Exit code (Decimal): 0 Start time: 2022-08-24 22:19:21 End time: 2022-08-24 22:53:34 Requested action: Install Machine Properties: Machine name: LAPTOP-NQBCHBNR Machine processor count: 8 OS version: Microsoft Windows 11 Home Single Language (10.0.22000) OS service pack: OS region: United States OS language: English (United States) OS architecture: x64 Process architecture: 64 Bit OS clustered: No Product features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Configured Package properties: Description: Microsoft SQL Server 2016 ProductName: SQL Server 2016 Type: RTM Version: 13 Installation location: E:\x64\setup\ Installation edition: Developer Slipstream: True SP Level 3 Patch Level: 13.3.6404.1 Product Update Status: Success: KB 5003279, KB 5006943 Product Updates Selected for Installation: Title: Microsoft SQL Server 2016 with SP3 Knowledge Based Article: KB 5003279 Version: 13.3.6300.0 Architecture: x64 Language: 1033 Title: SQL Server update Knowledge Based Article: KB 5006943 Version: 13.3.6404.0 Architecture: x64 Language: All Update Source: Slipstream User Input Settings: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT Service\SQLAgent$MSSQLSERVER2016 AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: MULTIDIMENSIONAL ASSVCACCOUNT: <empty> ASSVCPASSWORD: <empty> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: <empty> ASTELSVCACCT: <empty> ASTELSVCPASSWORD: <empty> ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <empty> CLTRESULTDIR: <empty> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <empty> CLTSVCPASSWORD: <empty> CLTWORKINGDIR: <empty> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20220824_221638\ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <empty> CTLRSVCPASSWORD: <empty> CTLRUSERS: <empty> ENABLERANU: false ENU: true EXTSVCACCOUNT: <empty> EXTSVCPASSWORD: <empty> FEATURES: SQLENGINE, DQ, DQC, CONN, IS, SDK, SNAC_SDK, MDS FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <empty> FTSVCACCOUNT: <empty> FTSVCPASSWORD: <empty> HELP: false IACCEPTROPENLICENSETERMS: false INDICATEPROGRESS: false INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <empty> INSTANCEDIR: C:\Program Files\Microsoft SQL Server\ INSTANCEID: MSSQLSERVER2016 INSTANCENAME: MSSQLSERVER2016 ISSVCACCOUNT: NT Service\MsDtsServer130 ISSVCPASSWORD: <empty> ISSVCSTARTUPTYPE: Manual ISTELSVCACCT: NT Service\SSISTELEMETRY130 ISTELSVCPASSWORD: <empty> ISTELSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: <empty> MATRIXNAME: <empty> MRCACHEDIRECTORY: NPENABLED: 0 PBDMSSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE PBDMSSVCPASSWORD: <empty> PBDMSSVCSTARTUPTYPE: Automatic PBENGSVCACCOUNT: NT AUTHORITY\NETWORK SERVICE PBENGSVCPASSWORD: <empty> PBENGSVCSTARTUPTYPE: Automatic PBPORTRANGE: 16450-16460 PBSCALEOUT: false PID: ***** QUIET: false QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSHPINSTALLMODE: DefaultSharePointMode RSSVCACCOUNT: <empty> RSSVCPASSWORD: <empty> RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQL SQLBACKUPDIR: <empty> SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS SQLSVCACCOUNT: NT Service\MSSQL$MSSQLSERVER2016 SQLSVCINSTANTFILEINIT: false SQLSVCPASSWORD: <empty> SQLSVCSTARTUPTYPE: Manual SQLSYSADMINACCOUNTS: LAPTOP-NQBCHBNR\razzi SQLTELSVCACCT: NT Service\SQLTELEMETRY$MSSQLSERVER2016 SQLTELSVCPASSWORD: <empty> SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR: <empty> SQLTEMPDBFILECOUNT: 8 SQLTEMPDBFILEGROWTH: 64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR: <empty> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE: 8 SQLUSERDBDIR: <empty> SQLUSERDBLOGDIR: <empty> SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: true UpdateSource: Slipstream USEMICROSOFTUPDATE: false X86: false Configuration file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20220824_221638\ConfigurationFile.ini Detailed results: Feature: Client Tools Connectivity Status: Passed Feature: Client Tools SDK Status: Passed Feature: Database Engine Services Status: Passed Feature: Data Quality Services Status: Passed Feature: Master Data Services Status: Passed Feature: Integration Services Status: Passed Feature: Data Quality Client Status: Passed Feature: SQL Browser Status: Passed Feature: SQL Writer Status: Passed Feature: SQL Client Connectivity Status: Passed Feature: SQL Client Connectivity SDK Status: Passed Rules with failures: Global rules: Scenario specific rules: Rules report file: C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20220824_221638\SystemConfigurationCheck_Report.htm |
Appendix 2 |
Run the installer: SSMS-Setup-ENU-(16.5.3).exe |
Wait for installation to finish |
Installation completed. |
Run SQL Server Management Studio to start using the application. |
(You may need to start the SQL Server Services first) |
Connected. |
Appendix 3 |
Select the backup file. |
Select OK to start the restoration. |
Database restored successfully. |
Check the database name in the Object Explorer panel. |
NEXT: restore AdventureWorksDW2012.bak |
Appendix 4 |
Appendix 5 |
Run Visual Studio 2015 |
Check that the Business Intelligence template is installed. |
Further reading: |
Appendix 6 |
Create new Integration Services project |
Select Connection Manager |
Connect using OLEDB |
Add data flow task |
.
