k*****n 发帖数: 361 | 1 郁闷搞了3天了deploy cube一直报错连不上服务器
公司机器:
本人computer不是admin,data source design view里面选中要连接的server,相应的数
据库也出来了,test connection成功!
右击properties里面deployment也是一致server和database,但是最后deploy还是说连
不上server
google了很久,这个帖子说
I also faced same issue while trying to deploying AdvantureWords Analysis
service.
I changed the following setting and after that i am able to deploy
successfully.
1) Change the SQL server Browser service running Account to Local System
Account
2) Create My Login Account in SQL >Security->Login
3) Double click on AdvantureWork.ds from DataSource (From Solution Explorer)
. and in Impersonation Information Select the Use the Service Account.
after apply all these steps i am able to deployed analysis services.
最后发现我本人机器不是admin连SQL browser都进不了?
因为不是admin所以我就不能deploy到自己的机器localhost?
那deploy到原来的server上行吗?
但是为啥我test connection server 成功,management studio也能成功query 这个服
务器的database,最后deploy还是说不能成功连接服务器?
希望牛人解答! | g***l 发帖数: 18555 | 2 不是LOCAL ADMIN SQL BROWSER你可能不行,要求是ADMIN好了,你要搞开发,当然要装
东西 | a****b 发帖数: 489 | 3 即便不是Admin应该也可以。但是你需要对你用来运行AS Service的账户进行相应的权
限设置。 | k*****n 发帖数: 361 | |
|