报告服务如何存储连接数据源时的SQL用户密码?

huangapple go评论66阅读模式
英文:

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 表中。用户名和密码分别存储在 UserNamePassword 列中,并以加密形式存储,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.

huangapple
  • 本文由 发表于 2023年2月8日 22:26:48
  • 转载请务必保留本文链接:https://go.coder-hub.com/75387211.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定