PDA

View Full Version : سوال: مشکل در اجرای برنامه در کلاینت ها



moferferi
شنبه 20 تیر 1388, 21:50 عصر
سلام.
من طبق اموزش هایی که توی تایپیک های مختلفی که توی سایت هست از جمله
http://barnamenevis.org/forum/showthread.php?t=149074&highlight=%D9%86%D8%B5%D8%A8+sql+%D8%AD%D8%A7%D9%8 4%D8%AA+remote

1.حالت remote sql2005 خودم را کردم
با استفاده از sql configuration manager و فعال کردن گزینه enabeled در قسمت
porotocols for mydatabase-->tcp\ip و وارد کردن پورت مورد نظر .
و با استفاده از کانکشن زیر
string strcon = @"Data Source=192.168.0.1,1580;Initial Catalog=mynetsql;Integrated Security=SSPI";
و یا

string strcon = "Server = 192.168.0.1,1580; Database = mynetsql;Integrated Security=SSPI";اما این کد ها فقط در کامپیوتری که اس کیو ال روش نصبه( یا همون سرور )فقط کار میده و در بقیه کامپیوتر ها پیغام میده که ممکنه حالت ریموت اس کیو ال تون فعال نباشه.

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. 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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at testip.Form1.button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\rap\My Documents\Visual Studio 2005\Projects\testip\Form1.cs:line 30
مشخصات سیستم:
windows xp sp2
sql 2005 developer

لطفا راهنمایی کنید.
خواهش میکنم نگید سرچ نکردی .چون تموم تایپیک ها را گشتم.