问题:主机数据库用户密码修改后,出现了网站连接不上数据库的现象;查看数据库链接文件时,呈现的却是加密的代码行,那么这是什么原因,以及如何修改这个文件?
分析:在网站信息配置中,有一个对数据库字符串进行加密的选项,当初配置是你是否操作过。加密后,会产生如同以下格式的配置:
<connectionStrings configProtectionProvider="RsaProtectedConfigurationProvider">
<EncryptedData Type="http://www.w3.org/2001/04/xmlenc#Element"
xmlns="http://www.w3.org/2001/04/xmlenc#">
<EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#tripledes-cbc" />
<KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">
<EncryptedKey xmlns="http://www.w3.org/2001/04/xmlenc#">
<EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#rsa-1_5" />
<KeyInfo xmlns="http://www.w3.org/2000/09/xmldsig#">
<KeyName>Rsa Key</KeyName>
</KeyInfo>
<CipherData>
<CipherValue>Jmlei4qjTvOqASpxt/oGZmWvvCEMex3NoYmAByZZxFVz3zyeh1A6whzEbklPIm/sFDUZBb/XWcAm7t4i5jkItSjluyd/0zK/SYUG9Q5
h+p9MWmWe2wJ9eFy5sqdgsoCbcvi1NjU/Jl+j6ur4VqKYFlc9RR7d6YiGaSQbVGVotG8=</CipherValue>
</CipherData>
</EncryptedKey>
</KeyInfo>
<CipherData>
<CipherValue>S2eYS7Dt8JSuwWximwRU/2Ql5Lx90EQNvCXxA4xNkFjY3E3CNVCFjOaYpNOyyVPMpnIW7Y+zoLNPV6z4l3JfV5ad3V4xHbB1zmLBdlq
5jmsBo3oNAY7Atpl6IJ7N1JXmGGTtH4lrQc0giiXYVSZHbuAPVZeDmFeOCmEtcgmi+8lErFFSY7BZZEDexDKx1WuQ6DdUF3hsWvAgNjobGqna6UcGhy+
7wQP2/evpMM1cbd9raCeZZICjSYc64c9o0/E7eBvAasQGIto=</CipherValue>
</CipherData>
</EncryptedData>
</connectionStrings>
解决:打开Config\ConnectionStrings.config文件,把里面的代码用下面的代码替换就可以了(注意设置好数据库参数)
<connectionStrings>
<add name="Connection String" connectionString="server=(local);database=××××;uid=×××××;pwd=×××"
providerName="System.Data.SqlClient" />
</connectionStrings>