The location of Microsoft SQL Server folders varies depending on Operating System and SQL version. The Database Properties utility will assist you to determine the location of your SQL instance. Each sub-folder within the location is a self-contained SQL Instance, requiring individual configuring for your Firewall and Antivirus software.
The Root Directory field of Database Properties refers to the location of the MedicalDirector HCN Database, and can be used to determine your SQL Installation folder and Instance name.
For example: Root Directory: C:\Program Files\Microsoft SQL Server\MSSQL10_50.HCNSQL07\MSSQL\DATA\ confirms that Microsoft SQL is installed in "C:\Program Files\Microsoft SQL Server" and the Instance name is "HCNSQL07"
Instance Name |
SQL Server Version |
Folder Name |
SQL2005 |
~Microsoft SQL Server\MSSQL.x |
|
SQL2008 |
~Microsoft SQL Server\MSSQL10.HCNSQL07 |
|
SQL2008 R2 |
~Microsoft SQL Server\MSSQL10_50.HCNSQL07 |
|
SQL 2012 |
~Microsoft SQL Server\MSSQL11.HCNSQL07 |
|
SQL 2014 |
~Microsoft SQL Server\MSSQL12.HCNSQL07 |
|
SQL2005 |
~Microsoft SQL Server\MSSQL.x |
|
SQL2008 |
~Microsoft SQL Server\MSSQL10.HCNMOB07 |
|
SQL2008 R2 |
~Microsoft SQL Server\MSSQL10_50.HCNMOB07 |
|
SQL 2012 |
~Microsoft SQL Server\MSSQL11.HCNMOB07 |
|
SQL 2104 |
~Microsoft SQL Server\MSSQL12.HCNMOB07 |
|
SQL2000 |
~Microsoft SQL Server\MSQL$ESP |
|
SQL2005 |
~Microsoft SQL Server\MSSQL.x |
|
SQL2008 |
~Microsoft SQL Server\MSSQL10.ESP |
|
SQL2008 R2 |
~Microsoft SQL Server\MSSQL10_50.ESP |
|
SQL 2012 |
~Microsoft SQL Server\MSSQL11.ESP |
|
SQL 2104 |
~Microsoft SQL Server\MSSQL12.ESP |