我用的是SQL2000,SQL2000的数据库我用detach和attach转到另一电脑的(也是SQL2000),dotnetnuke的源文件是全部COPY过去的,但是报错“When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.”
我知道是下面连接SQL2000的代码注释掉了!当然,我在原电脑(SQL2000数据库)上不会报错;
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=sa;pwd=sa;"
providerName="System.Data.SqlClient" />
-->
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" />
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=sa;pwd=sa;"/>
-->
上面是我在原电脑上的WEB。CONFIG的配置,可以用。但是转到另一台就不行了,为什么?
别外,我用的是SQL2000,那下面的代码为什么会注释掉,而且可以有我那原电脑上可用?(我是按‘DotNetNuke高级编’程‘那书安装配置的)
<!-- Connection String for SQL Server 2000/2005
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=sa;pwd=sa;"
providerName="System.Data.SqlClient" />
-->
谁装把dotnetnuke在SQL2000数据库上的?问题有点长,请帮我看看吧!