Avatar of 2Cs
2Cs
Flag 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
Microsoft SQL ServerDatabasesMicrosoft Server OSMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
2Cs

8/22/2022 - Mon
san_spy

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

ASKER
I can contact the db but not that module. Only the domain admin account can.
tbsgadi

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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
2Cs

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.