Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 781
  • Last Modified:

to grant full permisson with windows authentication for sql services

I have a user..this user have to logon Integration services on sql server 2005..but he try to logon integration service but he can not logon this service..he have a permission to log on the database engine,he can logon database engine with windows authentication  but he can not log on the other services,for example Integration services,reporting services and analysis service..how can I give permission to log on these services?
0
teodor76
Asked:
teodor76
  • 3
  • 2
1 Solution
 
imran_fastCommented:
Add this user to the group SQLServerDTSUser on the machine.
0
 
teodor76Author Commented:
where is this group on machine?
0
 
imran_fastCommented:
right click my computer --> manage--> user groups

you will find it there
0
 
teodor76Author Commented:
what is the SQLServerDTSUser ? can you please explain to me?
0
 
imran_fastCommented:
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now