Tuesday, March 6, 2012

About the MSPetShop

"/Web"应用程序中的服务器错误。


用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。

说明:执行当前 Web请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息:System.Data.SqlClient.SqlException:用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。

源错误:

行 216:

行 217: if (conn.State != ConnectionState.Open)

行 218: conn.Open();

行 219:

行 220: cmd.Connection = conn;


源文件:C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs :218

堆栈跟踪:

[SqlException (0x80131904):用户 'mspetshop'登录失败。原因:未与信任 SQL Server连接相关联。]

System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +458

System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85

System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89

System.Data.SqlClient.SqlConnection.Open() +160

PetShop.DBUtility.SqlHelper.PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, CommandType cmdType, String cmdText, SqlParameter[] cmdParms) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:218

PetShop.DBUtility.SqlHelper.ExecuteReader(String connectionString, CommandType cmdType, String cmdText, SqlParameter[] commandParameters) in C:\Program Files\Microsoft\.NET Pet Shop 4.0\DBUtility\SQLHelper.cs:127

PetShop.SQLServerDAL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\SQLServer\Category.cs:27

PetShop.BLL.Category.GetCategories() in C:\Program Files\Microsoft\.NET Pet Shop 4.0\BLL\Category.cs:20

PetShop.Web.NavigationControl.Page_Load(Object sender, EventArgs e) +51

System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +13

System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +45

System.Web.UI.Control.OnLoad(EventArgs e) +80

System.Web.UI.Control.LoadRecursive() +49

System.Web.UI.Control.LoadRecursive() +132

System.Web.UI.BasePartialCachingControl.LoadRecursive() +113

System.Web.UI.Control.LoadRecursive() +132

System.Web.UI.Control.LoadRecursive() +132

System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429

System.Data.ProviderBase.DbConnectionPool.PoolCreateRequest(Object state) +321


版本信息: Microsoft .NET Framework版本:2.0.50727.42; ASP.NET版本:2.0.50727.42

About the MSPetShop

It said user"mspetshop" distrust connect to SqlServer

What Can I Do?

why the user"MSpetshop"can't to connect the SqlServer2k?

change the Database?

SqlServer2005?

but my pc's memory is just 256mb~

|||Since Microsoft .NET Pet Shop is a winforms question, the MSDN Forums is probably a better place for this question.

It's hard to know what the problem is without seeing the exact English version of the error message. If you show us the connection string, we *might* be able to help. It sounds like you need to give the account login access to your database (viasp_grantlogin).

No comments:

Post a Comment