Avatar of dedri
dedri
Flag for United States of America asked on

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?
Microsoft SQL ServerMicrosoft SQL Server 2008SSIS

Avatar of undefined
Last Comment
thombeck

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
9l1ves

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
thombeck

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy