مشکل در آپود سایت در IIS

[mohammad diba]

سلام بر دوستان بزرگوار
من یه سایتی نوشتم که با دیتابیس SQL server در ارتباط هست این سایت تویه IDE خود سی شارپ کاملا درست اجرا میشه ولی تویه IIS نمی دونم چرا از دیتابیس error میگیره ترفند خاصی داره البته دسترسی من به wwwroot به صورت کامله.

[Saman Hashemi]

ارور قرار بدين تا ببين چي ميگه اينجوري كه نميشه كمك كرد...!

[mohammad diba]

این خطا رو میده


Server Error in '/' Application.
--------------------------------------------------------------------------------

Login failed for user 'SAZGAR-2FECE262\ASPNET'.
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 'SAZGAR-2FECE262\ASPNET'.

Source Error:


Line 19: SqlConnection con = new SqlConnection("Data Source=.\\sql2008;Initial Catalog=shahrdari;Integrated Security=True");
Line 20: SqlCommand com = new SqlCommand("select carnoo from carnoo where code=101", con);
Line 21: con.Open();
Line 22: SqlDataReader read = com.ExecuteReader();
Line 23: if (read.Read())


Source File: D:\WebApplication1\WebApplication1\Default.aspx.cs Line: 21

Stack Trace:


[SqlException (0x80131904): Login failed for user 'SAZGAR-2FECE262\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +5009598
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlInternalConnectionTds.Com pleteLogin(Boolean enlistOK) +35
System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +524
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +479
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlConnection.Open() +125
WebApplication1._Default.Button1_Click(Object sender, EventArgs e) in D:\WebApplication1\WebApplication1\Default.aspx.cs :21
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEven t(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

[raziee]

Integrated Security=True
اگه تو دیتابیستون نگاه کنید همچین یوزری وجود نداره!! SAZGAR-2FECE262\ASPNET
برای اتصال دیگه از User Windows برای ارتباط با بانک استفاده نمیکنه.
برای دیتابیستون یک User درست کنید. و بعد User ID و Password رو در Conntection String ذخیره کنید.

[mohammad diba]

مرسی دوست عزیز مشکل من حل شد.