初级问题关于SQL Server

[pankane]

我运行quickstart和一些带数据库得网络例程，总是出现一下错误怎么回事啊？我安装了SQL Server 2000并让他运行拉，我应改怎么配置，谢谢啦我是刚学这个好多不懂麻烦说详细些！
Server Error in '/bbs' Application.
--------------------------------------------------------------------------------

用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。
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.OleDb.OleDbException: 用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OleDbException (0x80004005): 用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
Forum.Db.OpenDb()
Forum.Db.GetGrid(String Sql, String Tb)
Forum.Db.GetCon()
Forum.Index.SetModel()
Forum.Index.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720

[pankane]

我把验证改成了windows和Sql server这下好了错误变成这个了
No error information available: E_FAIL(0x80004005).
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.OleDb.OleDbException: No error information available: E_FAIL(0x80004005).

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[OleDbException (0x80004005): No error information available: E_FAIL(0x80004005).]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203
Forum.Db.OpenDb()
Forum.Db.GetGrid(String Sql, String Tb)
Forum.Db.GetCon()
Forum.Index.SetModel()
Forum.Index.Page_Load(Object sender, EventArgs e)
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +720




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

怎么回事啊，我到现在网上下得Sql server得.Net程序都是这样怎么解决啊？

[shuker]

请把这里面OleDbConnection的连接字符串贴出来

[kertcobain]

看看你的SQL SERVER 2000服务启动了没有!!
自己做个ODBC连接看看能不能连上啊?

[pankane]

我启动啦，我自己用VS.net做的就没有问题
key="StrConn" value="PROVIDER=SQLOLEDB;DATA SOURCE=(local);UID=sa;PWD=;DATABASE=AspxAppForum;connect timeout=120"

[kld3000]

检查sql server 2000启动没
再检查登陆字段是否正确
主要看你的sa密码是否为空

[hhzh426]

oleDbConnection.ConnectionString
User ID=sa;Data Source=服务器IP地址;Password=sa密码;Initial Catalog=数据库名;Provider=SQLOLEDB.1

sqlConnection.ConnectionString
user id=sa;data source=服务器IP地址;initial catalog=数据库名;password=sa密码

odbcConnection.ConnectionString
PWD=sa密码;UID=sa;DRIVER=SQL Server;Network=DBMSSOCN;DATABASE=数据库名;SERVER=数据库IP";

[llitcwl]

是quickstart的连接串有点问题，用文件替换工具把DATA SOURCE=(local)\ASPNET替换成DATA SOURCE=(local)就行了，所有和数据库有关的文件都要替换

[caff]

quickstart使用的是ASPNET用户,到管理界面里看看你的用户里有没有

[wy1086]

把你的程序贴出来！

[可可与二宝]

找到web.config文件，将其相应的字符串改一下。