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
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
Last Comment
2Cs
check if the id ippy\awilden is having access to the database server..
ASKER
I can contact the db but not that module. Only the domain admin account can.
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
Al
ASKER CERTIFIED SOLUTION
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.