英文:
How reporting service store the password of SQL user when connect the data source?
问题
当我们在报告服务中创建数据源时,我们需要分配连接到该数据源的帐户,可以是Windows用户或SQL用户。
如果我们选择SQL用户,我们想知道SQL用户的密码存储在何处,或者是否使用某种算法进行加密?
我可以参考任何官方文件来解决这个问题吗?
英文:
When we create the datasource in the reporting service, we need to assign the account to connect to that datasource, either windows, sql user.
If we choose sql user, we wonder that where is the password of sql user is stored. Or does it encrypt with any algorithm?
Can I refer to any official document regarding this issue?
答案1
得分: 0
细节存储在 dbo.DataSource
表中。用户名和密码分别存储在 UserName
和 Password
列中,并以加密形式存储,ConnectionString
列也是如此。除非最终用户获取了由 SSRS 内部使用的解密密钥,否则他们无法解密它。
英文:
The details are stored in the dbo.DataSource
table. The Username and Password are stored in the UserName
and Password
columns respectively and are encrypted, as is the ConnectionString
column. An end user would not be able to decrypt it, unless they obtained the decryption key used internally by SSRS.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论