web.config配置问题!大虾帮我
我的web.config 如下:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="ConnectionString" value="server=localhost;database=UDS;User Id=sa;pwd=;"/>
<!-- <add key="ConnectionString" value="server=xm2003;database=uds_dongzhou_net2.0;User Id=sa;pwd=;"/>-->
<add key="IndexConnectionString" value="Provider=MSIDXS; Data Source=UDS;"/>
</appSettings>
<system.web>
<compilation defaultLanguage="c#" debug="true">
<!-- <assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies>--><assemblies><add assembly="CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.ReportSource, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Shared, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/><add assembly="CrystalDecisions.Web, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"/></assemblies></compilation>
<customErrors defaultRedirect="Error.aspx" mode="Off"/>
<authentication mode="Forms">
<forms name="UDSAuth" loginUrl="SubModule/Login/index.aspx" protection="None" timeout="216000" path="/"/>
</authentication>
<globalization requestEncoding="gb2312" responseEncoding="gb2312" fileEncoding="gb2312" culture="zh-cn"/>
<httpRuntime maxRequestLength="102400" useFullyQualifiedRedirectUrl="true" executionTimeout="300"/>
</system.web>
<!-- set secure paths -->
<location path="Inc">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="SubModule">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
</configuration>
错误如下:
Server Error in '/UDS' Application.
--------------------------------------------------------------------------------
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Line 101: }
Line 102: if(con.State ==System.Data.ConnectionState.Closed)
Line 103: con.Open();
Line 104:
Line 105: }
Source File: C:\Inetpub\wwwroot\UDS\Components\Database.cs Line: 103
==============================================================================
我的sa 人密码为空,在装sql时,我用的是混合登陆.如何解决!!!!!
有别的方法来解决吗!
问题点数：0、回复次数：4Top
1 楼Miracle（新一代的开山怪）回复于 2004-12-04 04:33:14 得分 0
首先，再次确认你的SQLServer登录验证方式为混合模式，而不是Windows验证
其次，套用一下下面这个连接字串模板：
packet size=4096;user id=sa;data source=localhost;persist security info=True;initial catalog=UDS;password=Top
2 楼lvwaike（螃蟹）回复于 2004-12-15 12:54:26 得分 0
你可以把password= 改成password=""Top
3 楼ch21st（www.blanksoft.com）回复于 2004-12-29 15:53:42 得分 0
如果不知道连接字符串如何写可以随便选择一个可以自动生成连接字符串的工具来生成，比如vb6中的adodc控件，。net中也有类似的东东Top
4 楼a7lang（阿七( 啥时候结婚呢？)）回复于 2004-12-29 15:56:59 得分 0
<add key="ConnectionString" value="Data Source=CSHU;Initial catalog=Snowman;user id=sa;password=" />Top
