Executing the query ...
Either the user, PCHOME\max, does not have access to the Analysis Services Project1 database, or the database does not exist.
Execution complete
i try another way: i click right mouse on my database from analysis service, so i choice "Script database as "--> CREATE to... and i get a new XMLA file so igo to another computer, and run it, SQL return follow error:
Executing the query ...
Either the user, PCHOME\max, does not have access to the AAAA database, or the database does not exist.
Execution complete
can i solve this problem.
thanks
Another way to do this is to use BI dev studio to import the database and then redeploy to another server
For example
Launch BI Dev Studio
New Project/Business Intelligence Projects/Import Analysis Services 9.0 Database
After loaded, go to project properties and set the target server.
Also you can use the Deployment Wizard under the start menu/SQL Server 2005/Analysis Services/Deployment Wizard
You do need to be an administrator on the target server in order to create a database there.
HTH
-Jamie
|||sorry, i want to create on new computer not connect to my computer, how to export analysis services database to import to another computerAs you said, i have to use
Launch BI Dev Studio
New Project/Business Intelligence Projects/Import Analysis Services 9.0 Database
on my computer and select database on my computer, after that change target server. on properties change server name,
then i go to another computer and open my project on target server?
i can't understand about your idea,
can you explain to me
This link gives more information about the deployment wizard: http://msdn2.microsoft.com/en-us/library/ms176121.aspx which can create a database on Computer B from a project on Computer A
This link gives information about the synchronization wizard which may also be useful: http://msdn2.microsoft.com/en-us/library/ms174488.aspx - it can copy a database from Computer A to Computer B
There also other methods, 5 in total, described here: http://msdn2.microsoft.com/en-us/library/ms175446.aspx
Which method you use will depend on exactly what you would like to acheive. But I think you will find one of these methods suitable.
No comments:
Post a Comment