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.
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,JonWeblog -- [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. |
 |
|
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] |
 |
|
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" |
 |
|
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] |
 |
|
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 ServerMSSSQL.1 usually is the database serverMSSSQL.2 usually is the analysis serverMSSSQL.3 usually is the reporting server E 12°55'05.25"N 56°04'39.16" |
 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-07 : 00:31:15
|
You should see analysis service if installed. |
 |
|
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 |
 |
|
|
|
|