Analysis services connection

Hi!!
1. I am working with Analysis services 2005 and I would want to know
if, Is it recommendable to separate the DB server from of server AS?,
Since when I consult the cubes diminishes the performance the server of
database.
2. How I can to create news administrators OLAP in SQL 2005?
Is there one book what you can recommend on how connecting to me of
remote form?
Thanks,
Cecilia
Chile
1. Yes, you can run SQL and AS on separate machines, just be aware that
each machine would require its own SQL license.
2. To create add a user to the administration group at the server level
for AS you need to open up SQL Server Management Studio, connect to your
server, right click and select "properties" and then go to the security
settings and add the user to the list there.
Regards
Darren Gosbell [MVP]
Blog: http://geekswithblogs.net/darrengosbell
*** Sent via Developersdex http://www.codecomments.com ***
|||The connection of server work, thanks Darren.
Now I have other doubts:
1. if I have SQL server and AS on separate machines and I execute a MDX
query for a rolap cube, consume this query too many resources on the BD
server?
2. it really improves the performance of my server, if i separate it in
the 2 mentioned machines?
3. What percent of the load of a query takes the BD machine, (aprox)?
Thanks,
Cecilia