DTS is a sysadmin, serveradmin. It still can't deploy SSAS project, why? the error is "Error 1 Either the 'WCSQL1\DTS' user does not have permission to create a new object in 'WCSQL1', or the object does not exist. 0 0 "
Thanks!
Katie
When you say "sysadmin", "serveradmin" - I think you mean that he has these permissions on SQL Server. You need to grant this user permissions on Analysis Services - go to Management Studio, and then on Server Properties -> Security tab, add WCSQL1\DTS user into server role.
No comments:
Post a Comment