Arkadaşlar benim sorunum üzerinde sadece adminlik yaptığım site ile ilgili sitede normalde sadece Çeşitli dosya transferleri ve güncellemeler yapıyorum o da sitenen kendi arayüzündeki yönetici panelinden. Birde yeni dosyaları Smart FTP ile siteye yüklüyorum ancak son birkaç gündür siteye ulaşırken aşağıdaki hatayı alıyorum.Bir de FTP ye girdiğimde site passive modda görünüyor,o işareti kaldırsam bile ikinci girişti passive modu işaretli görüyorum bilgisi olan arkadaşlar fikirlerini paylaşırsa sevinirim.
Sorun detayı
Server Error in '/' Application. --------------------------------------------------------------------------------
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) 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: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
Source Error:
Line 16: if (!Page.IsPostBack) Line 17: { Line 18: foreach (MembershipUser user in Membership.GetAllUsers()) Line 19: { Line 20: if (user.IsOnline)
Stack Trace:
[SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning() +13 System.Data.SqlClient.TdsParserStateObject.WriteSni() +682631 System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode) +265 System.Data.SqlClient.TdsParser.SendPreLoginHandshake(Byte[] instanceName, Boolean encrypt) +689 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +287 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +1658 System.Web.Security.Membership.GetAllUsers(Int32 pageIndex, Int32 pageSize, Int32& totalRecords) +63 System.Web.Security.Membership.GetAllUsers() +26 _Default.Page_Load(Object sender, EventArgs e) in d:\inetpub\vhosts\uludagrotary.org\httpdocs\Default.aspx.cs:18 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
-------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
Öncelik ile anladığım kadarıyla sorunun SQL Server 2005 bağlantısından kaynaklanıyor.
C:\Windows\System32\drivers\etc 'de host dosyasını not defterini açtığında şu şkilde bir ibare olması gerekiyor
xxx.xxx.xxx.xxx KSSQLSRVR sen bunu xxx.xxx.xxx.xxx KSSQLSRVR\SPDEV01
yazman yeterlidir. Eğer host dosyasında bu şekilde bir satır bulunmuyorsa host dosyasını buraya yapıştırırsanız yardımcı olmaya çalışırım. Kolay gelsin.
Çok teşekkür ediyorum sorun dediğiniz şekildeymiş çözüldü :))