renaming Analysis Server datasource

Hello,
I have a datasource that some existing cubes are utilizing that is has a server name in the name of the datasource. This is minor, as you can point the datasource to any SQL server you want, but I'd like to change the name of the datasource or create a
new one that the cubes can in turn use that has a more meaningful name. Is this possible?
-Kind Regards, Brian Parker
Unfortunately you cannot.
See the Analysis Services Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
Search for "Data Source Configuration"
Dave Wickert [MS]
dwickert@.online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"brian parker" <anonymous@.discussions.microsoft.com> wrote in message
news:88889B58-6D9B-4BE1-9F2A-D5E4C28485BD@.microsoft.com...
> Hello,
> I have a datasource that some existing cubes are utilizing that is has a
server name in the name of the datasource. This is minor, as you can point
the datasource to any SQL server you want, but I'd like to change the name
of the datasource or create a new one that the cubes can in turn use that
has a more meaningful name. Is this possible?
> -Kind Regards, Brian Parker

renaming Analysis Server datasource

Hello,
I have a datasource that some existing cubes are utilizing that is has a ser
ver name in the name of the datasource. This is minor, as you can point the
datasource to any SQL server you want, but I'd like to change the name of t
he datasource or create a
new one that the cubes can in turn use that has a more meaningful name. Is
this possible?
-Kind Regards, Brian ParkerUnfortunately you cannot.
See the Analysis Services Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
Search for "Data Source Configuration"
--
Dave Wickert [MS]
dwickert@.online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"brian parker" <anonymous@.discussions.microsoft.com> wrote in message
news:88889B58-6D9B-4BE1-9F2A-D5E4C28485BD@.microsoft.com...
> Hello,
> I have a datasource that some existing cubes are utilizing that is has a
server name in the name of the datasource. This is minor, as you can point
the datasource to any SQL server you want, but I'd like to change the name
of the datasource or create a new one that the cubes can in turn use that
has a more meaningful name. Is this possible?
> -Kind Regards, Brian Parker

Renaming Analysis DB

Hi

Is it possible to rename an analysis db on analysis services 2000?

Thanks in advance

Thomas

It's been a while since I've messed with 2000, but I do not believe you can change the name. Take a look at the DSO object library to see the the database name can be changed there. If not, then I think you're out of luck.

One solution is to open the AS manager, right-click the database, select copy then paste, and provide a new name. You'll need to reprocess (and possibly remove the old database), but this is how we used to handle this problem.

Good luck,
Bryan

|||

Hi Brian

This works for me. Thank you very much.

Thomas

Rename an AS Database?

Is there a way to rename an Analysis Services database? Can I do it through
the Analysis Manager interface?
Thanks!
Unfortunately, No. You need to do a copy and then a paste. When the paste
runs, it notices that you already have a database with that name and will
prompt for a new name. You enter a new name; then reprocess the database (an
option on the right-click menu). Then you can go back and delete the old
database.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:45D8C536-72F1-47BE-8BFA-9915DE6EE107@.microsoft.com...
> Is there a way to rename an Analysis Services database? Can I do it
through
> the Analysis Manager interface?
> Thanks!
sql

Rename an AS Database?

Is there a way to rename an Analysis Services database? Can I do it through
the Analysis Manager interface?
Thanks!Unfortunately, No. You need to do a copy and then a paste. When the paste
runs, it notices that you already have a database with that name and will
prompt for a new name. You enter a new name; then reprocess the database (an
option on the right-click menu). Then you can go back and delete the old
database.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:45D8C536-72F1-47BE-8BFA-9915DE6EE107@.microsoft.com...
> Is there a way to rename an Analysis Services database? Can I do it
through
> the Analysis Manager interface?
> Thanks!

removing system administrators from fixed server role

Hello all,

On Analysis Services 2005 the members of the Administrators local group are also members of the fixed server role, therefore they have full control over Analysis Services databases.

I think this can be a problem becouse many system administrators don't need full control over AS. Does someone kwon how can I remove those high privileges to the local administrator?

Thank you.

Hernan.

In Management Studio right click on the server, select properties, turn on the "Show Advanced (All) Properties" option and scroll down to the bottom and set the "Security\BuiltInAdminsAreServerAdmins" property to false.|||

Thank you Darren, your post is very usefull.

Before create this thread I tried some searches in google, microsoft and BOL... I didn't get any importart results. I would like to known how you learned this.. maybe if you used a web serach... what words did you use?

|||Sorry, I can't remember. I am a bit of an SSAS junkie and it's just one of thost things I knew.