SQL Server 2005 Directory Structure

Nothing too serious, it is something everyone need to be aware.

Generally if you have full / default installation you will get the directory structure like shown below:










When you conduct default installation SQL Server (data / backup etc) will be installed MSSQL.1 directory. Analysis Services related stuff in MSSQL.2 dorectory and Reporting Services related stuff in MSSQL.3 directory.

What you have to be aware is that for example if you just install Analysis Services on a new server it will install under MSSQL.1 directory. On the other hand if you install another instance of SQL Server, Analysis Server and Reporting Server in the above scenario, they will get MSSQL.4, MSSQL.5 and MSSQL.6 directory as 1,2 and 3 already exists as shown above.

Specially you have to be aware if you use within your application / reports where Reporting Services sits etc.

The directory names would differ between servers depending on installation.

Thanks
Sutha