Folks, please excuse my lack of knowledge in this area, it's something I've been tasked with fixing, but haven't had much luck with..
伙计们，请原谅我在这个领域缺乏知识，这是我一直在修理的事情，但是没有太多的运气......
I've got a server, with SQL Server 2008 R2 installed, it's the default isntance, and I can see that the SSIS service is installed and currently running.
我有一台服务器，安装了SQL Server 2008 R2，它是默认的isntance，我可以看到SSIS服务已经安装并且当前正在运行。
The issue I have is that, none of the SSIS roles described on this page:
我遇到的问题是，此页面上没有描述SSIS角色：
http://msdn.microsoft.com/en-us/library/ms141053.aspx
http://msdn.microsoft.com/en-us/library/ms141053.aspx
Are present in the server roles subsection of security... How do I make these available, or perhaps, why are they missing?...
存在于安全性的服务器角色子部分中......如何使这些可用，或者，为什么它们会丢失？...
Thanks in advance,
提前致谢，
Dave
戴夫
1 个解决方案
#1
5
The roles db_ssisadmin, ds_ssisltduser and db_ssisoperator can be found within the system database msdb. Refer screenshot #1.
可以在系统数据库msdb中找到角色db_ssisadmin，ds_ssisltduser和db_ssisoperator。参考截图＃1。
Refer the following link for answer mentioned in http://social.msdn.microsoft.com:
有关http://social.msdn.microsoft.com中提到的答案，请参阅以下链接：
SSIS Package Roles - Assigning user to Role
SSIS包角色 - 将用户分配给角色
Answer excerpt from social.msdn.microsoft.com:
回答来自social.msdn.microsoft.com的摘录：
These are just roles in the msdb database.
To assign the user to the role, you need to have the login as a user in
that database and assign the role as usual (i.e. go through the gui to
set the roles of the user or use T-SQL to set them).
USE msdb;
GO
EXEC sp_addrolemember N'db_dtsltduser', N'{User Name Here}';
GO
Hope that helps.
希望有所帮助。
Screenshot #1:
截图＃1：
#1
5
The roles db_ssisadmin, ds_ssisltduser and db_ssisoperator can be found within the system database msdb. Refer screenshot #1.
可以在系统数据库msdb中找到角色db_ssisadmin，ds_ssisltduser和db_ssisoperator。参考截图＃1。
Refer the following link for answer mentioned in http://social.msdn.microsoft.com:
有关http://social.msdn.microsoft.com中提到的答案，请参阅以下链接：
SSIS Package Roles - Assigning user to Role
SSIS包角色 - 将用户分配给角色
Answer excerpt from social.msdn.microsoft.com:
回答来自social.msdn.microsoft.com的摘录：
These are just roles in the msdb database.
To assign the user to the role, you need to have the login as a user in
that database and assign the role as usual (i.e. go through the gui to
set the roles of the user or use T-SQL to set them).
USE msdb;
GO
EXEC sp_addrolemember N'db_dtsltduser', N'{User Name Here}';
GO
Hope that helps.
希望有所帮助。
Screenshot #1:
截图＃1：