Version | *nnn* | {nn} |
---|---|---|
SQL Server 2019 (15.x) | 150 | 15 |
SQL Server 2017 (14.x) | 140 | 14 |
SQL Server 2016 (13.x) | 130 | 13 |
SQL Server 2014 (12.x) | 120 | 12 |
SQL Server 2012 (11.x) | 110 | 11 |
Component | Default path | Configurable or Fixed Path |
---|---|---|
Database Engine server components | Program FilesMicrosoftSQL ServerMSSQL{nn}.<InstanceID> | Configurable |
Database Engine data files | Program FilesMicrosoftSQL ServerMSSQL{nn}.<InstanceID> | Configurable |
Analysis Services server | Program FilesMicrosoftSQL ServerMSAS{nn}.<InstanceID> | Configurable |
Analysis Services data files | Program FilesMicrosoftSQL ServerMSAS{nn}.<InstanceID> | Configurable |
Reporting Services report server | Program FilesMicrosoftSQL ServerMSRS{nn}.<InstanceID>Reporting ServicesReportServerBin | Configurable |
Reporting Services report manager | Program FilesMicrosoftSQL ServerMSRS{nn}.<InstanceID>Reporting ServicesReportManager | Fixed path |
Integration Services | <Install Directory>nnnDTS 1 | Configurable |
Client Components (except bcp.exe and sqlcmd.exe) | <Install Directory>nnnTools 1 | Configurable |
Client Components (bcp.exe and sqlcmd.exe) | <Install Directory>Client SDKODBCnnnToolsBinn | Fixed path |
Replication and server-side COM objects | <drive>:Program FilesMicrosoft SQL ServernnnCOM 2 | Fixed path |
Integration Services component DLLs for the Data Transformation Run-time engine, the Data Transformation Pipeline engine, and the dtexec command prompt utility | <drive>:Program FilesMicrosoft SQL ServernnnDTSBinn | Fixed path |
DLLs that provide managed connection support for Integration Services | <drive>:Program FilesMicrosoft SQL ServernnnDTSConnections | Fixed path |
DLLs for each type of enumerator that Integration Services supports | <drive>:Program FilesMicrosoft SQL ServernnnDTSForEachEnumerators | Fixed path |
SQL Server Browser Service, WMI providers | <drive>:Program FilesMicrosoft SQL ServernnnShared | Fixed path |
Components that are shared between all instances of SQL Server | <drive>:Program FilesMicrosoft SQL ServernnnShared | Fixed path |