Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Analysis Services?

Author  Topic 

jhermiz

3564 Posts

Posted - 2008-02-06 : 08:54:24
Does anyone know if the analysis services CD is seperate from the SQL 2k5 enterprise CD's? We are trying to install it on a server and when we go to add / remove programs to check if analysis services is installed it is not listed. To add it it tries to go to the setup process but asks for the analysis services cd..which I cannot find anywhere! Is this a seperate CD install ?

Thanks,
Jon


Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-06 : 09:00:21
Nope.it comes with SQL 2005 and its called Business Intelligence suite (consisting of Reporting Services,Integration Services & Analysis Services).You need to select them while installing it.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2008-02-06 : 09:06:50
quote:
Originally posted by visakh16

Nope.it comes with SQL 2005 and its called Business Intelligence suite (consisting of Reporting Services,Integration Services & Analysis Services).You need to select them while installing it.



Hmm then I guess we do have them installed ? How would I know if it is installed? If I look in the programs menu for MS Sql 2005 I see analysis services and the only selection is "Deployment Wizard".




Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-06 : 09:07:27
You can add them later, with the installation cd for sql server.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

jhermiz

3564 Posts

Posted - 2008-02-06 : 09:26:56
quote:
Originally posted by Peso

You can add them later, with the installation cd for sql server.



E 12°55'05.25"
N 56°04'39.16"




?

Not sure what you mean. Is there any check to see if I have it loaded? When I go to analysis services i see "deployment wizard". I guess this is looking to deploy just an analysis service project?
When it brings up the dialog it is looking for an .asdatabase file?

Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-06 : 09:40:13
One way to check is to see the MSSSQL.x directories in Program Files\Microsoft SQL Server
MSSSQL.1 usually is the database server
MSSSQL.2 usually is the analysis server
MSSSQL.3 usually is the reporting server



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-02-06 : 15:16:11
Easy, just go to management studio/connect/analysis services.



http://www.sqlserverstudy.com
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-07 : 00:31:15
You should see analysis service if installed.
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-02-07 : 02:00:26
the service is usually called MSSQLServerOLAPService, the exe is msmdsrv.exe.




elsasoft.org
Go to Top of Page
   

- Advertisement -