Several ways:
First.
Right click on your project name in the BI Dev Studio select "Properties". Click on "Deployment" node on the left and you will see the name of the server you deploying to. By default it is "localhost" , change it to boco-ace
Second.
Open SQL Management Studio. Right Click on your database name->Script database to->Create ...
Send resulting script to your new server. Make sure you process your database after creating it.
Third.
Run MigrationWizard application and point it to the project files. At some point it will ask you which server you'd like to deploy it to.
I am sure I can come up with some more.. Like Sync , Backup/Restore, ...
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
i think maybe because i built roles,so i delete the role.but it daps another error"login failed for user"NT AUTHORITY\ANONYMOUS LOGON"",i do not know how to correct it?
thanks.
database's login mode is SQL's security
|||You should use windows integrated security when connecting to Analysis Server.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment