Link to home
Start Free TrialLog in
Avatar of 2Cs
2CsFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Authentication SQL 2008 Integrated Services

Hi all,

On our domain users have been using the domain administrator account for some time, I have now locked this down and want them to use their own accounts.

Now issues are appearing due to configuration problems. When any user regardless of group membership logs onto the SQL server, opens Server Management Studio and connects to the Intergration Services, then tries to open a folder called MSDB in Store Packages they get the attached error.

When I log in as the domain administrator account this works fine, I have added the required groups & tried specific users into the msdtsserver001 DCOM component but no change.

Can anyone help?

Al
SQLserver2008.jpg
Avatar of san_spy
san_spy
Flag of India image

check if the id ippy\awilden is having access to the database server..
Avatar of 2Cs

ASKER

I can contact the db but not that module. Only the domain admin account can.
Avatar of 2Cs

ASKER

Sorry made no difference, that appears to be issues with the database access, it is actually the Integrated Services that we are unable to expand logged in as any user other than an Domain Admin.

Al
ASKER CERTIFIED SOLUTION
Avatar of 2Cs
2Cs
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial