Hi.

I have Ms project server 2007 and SQL Enterprise 2005. I want to create a
OLAP cubes. I follow the installation guides but I don't have MSSQL.2
directory.

How i create this? I read it is necessary to create an instance, but how i
do that? I'm not a expert in SQL.

Thanks

--

When you install a SQL Server instance, that folder is created automatically
by SQL Server. Its number, depends on your SQL Server instances.

To go to this folder follow the following path:

"C:\Program Files\Microsoft SQL Server\"

You'll see your MSSQL.x folders there... Data, Log etc. files are being
stored in those folders.

In short, every instance has its own "MSSQL.x" folder.

For example, your first SQL Server Instance's folder would be like MSSQL.1

If you want to learn more about this topic, visit the following page from
BOL which is going to be very useful for your I believe:

File Locations for Default and Named Instances of SQL Server 2005:
http://msdn2.microsoft.com/en-us/library/ms143547.aspx

--
Ekrem Önsoy



[quoted text, click to view]