Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heliang
Starting Member
38 Posts |
 Posted - 2013-06-17 : 17:13:07
|
| How can I add a computer account (computer$) from another computer to the analysis service security?Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 00:47:44
|
| hmm...why should you add another computer account? you should be using windows authentication to connect and should create a domain account for this.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
heliang
Starting Member
38 Posts |
Posted - 2013-06-18 : 09:18:23
|
| Because I have a SQL job calling SSIS package and the sql agent is running under network service which is computer$. I probably can setup a domain account and change the sql agent run under this account, but I want to know if I can add computer$ to the AS security. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-18 : 10:15:13
|
| nope. for that you need to add a proxy account ( a domain one) and give it access to AS and SSIS. Also make sql sgent job run under it.Didnt understand why you need to change AS security for running SSIS package though. Is it doing something on the cube?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
heliang
Starting Member
38 Posts |
Posted - 2013-06-19 : 09:32:55
|
| Yes, SSIS calles the cube. How does this proxy account works? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Add couputer$ account to SSAS