Go Premium for a chance to win a PS4. Enter to Win

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

sql login access

I have a web application(.net), which need to have access to DB and executes a SSIS package.
What permissions do I have to give to the login?
0
dedri
Asked:
dedri
1 Solution
 
9l1vesCommented:
the user needs to be part of the DB_SSISLTDUSER group and the user will need the permissions required in the DB i.e. permissions required to do the tasks that the SSIS package executes.

for the SSIS:
MSDB --> Security --> Roles --> db_ssisltduser --> add the user/group name --> check the two boxes related to DB_SSISLTDUSER [probably already done].
0
 
thombeckCommented:
for access the DB the user needs to be added to the SQL Logins and he needs db_datareader rights to the database (or it there is somethink to writhe / change db_datawriter)


To grant access to the Integration Services service

    Run Dcomcnfg.exe. Dcomcnfg.exe provides a user interface for modifying certain settings in the registry.

    In the Component Services dialog, expand the Component Services > Computers > My Computer > DCOM Config node.

    Right-click Microsoft SQL Server Integration Services 11.0, and then click Properties.

    On the Security tab, click Edit in the Launch and Activation Permissions area.

    Add users and assign appropriate permissions, and then click Ok.

    Repeat steps 4 - 5 for Access Permissions.

    Restart SQL Server Management Studio.

    Restart the Integration Services Service.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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