Conneting remote database error RSS

• • Reply
  

  som1987

  0 Points

  2 Posts

  Conneting remote database error

  Nov 11, 2012 06:43 PM|LINK

  I am connecting a remote sql server database from my asp.net application. Using the connection string  in web config file

  <add key="SqlConnectionString" value="Data Source=http://p1.mtxinc.com:8234;Database=test;Uid='test';Pwd='test';Network Library =dbmssocn"/>

  But i am getting this error:

  <div>System.Data.SqlClient.SqlException was unhandled by user code</div> <div>  class="20"</div> <div>  ErrorCode=-2146232060</div> <div>  HResult=-2146232060</div> <div>  LineNumber=0</div> <div>  Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)</div> <div>  Number=123</div> <div>  Server=""</div> <div>  Source=.Net SqlClient Data Provider</div> <div>  State=0</div> <div>  StackTrace:</div> <div>       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)</div> <div>       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div> <div>       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)</div> <div>       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)</div> <div>       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)</div> <div>       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)</div> <div>       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions)</div> <div>       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)</div> <div>       at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)</div> <div>       at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions)</div> <div>       at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions)</div> <div>       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)</div> <div>       at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)</div> <div>       at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)</div> <div>       at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)</div> <div>       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)</div> <div>       at System.Data.SqlClient.SqlConnection.Open()</div> <div>       at companystores._default.deleteAllProd() in J:\loreal\companystores---Catalog-Free-Goods-Website\companystores\default.aspx.vb:line 346</div> <div>       at companystores._default.Page_Load(Object sender, EventArgs e) in J:\loreal\companystores---Catalog-Free-Goods-Website\companystores\default.aspx.vb:line 126</div> <div>       at System.Web.UI.Control.OnLoad(EventArgs e)</div> <div>       at System.Web.UI.Control.LoadRecursive()</div> <div>       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div> <div>  InnerException: System.ComponentModel.Win32Exception</div> <div>       ErrorCode=-2147467259</div> <div>       HResult=-2147467259</div> <div>       Message=The filename, directory name, or volume label syntax is incorrect</div> <div>       NativeErrorCode=123</div> <div>       InnerException: </div> <div></div> <div></div> <div>Can anyone help in solving this problem.</div> <div>Thanks</div> <div>Sodmeb</div>
  • Edited by som1987 on Nov 11, 2012 06:43 PM
  • Edited by som1987 on Nov 11, 2012 06:44 PM
  • Edited by som1987 on Nov 11, 2012 06:44 PM
• • Reply
  

  codeasp

  Star

  14735 Points

  2545 Posts

  Re: Conneting remote database error

  Nov 12, 2012 02:17 AM|LINK

  Can you connect to the SQL instance using Management Studio.  Exception is too broad but It may be SQL server is not configured to accept  any incoming connections over TCP/UDP.  You will need to contact the DBA to make sure the SQL is configured to accept connections.

• • Reply
  

  som1987

  0 Points

  2 Posts

  Re: Conneting remote database error

  Nov 12, 2012 03:07 PM|LINK

  Same error is coming with connection with sql management studio

  Thanks

• • Reply
  

  codeasp

  Star

  14735 Points

  2545 Posts

  Re: Conneting remote database error

  Nov 13, 2012 01:41 AM|LINK

  Who is the owner of the database?  The SQL server should be configured to accept incoming connections via TCP/UDP.  If you have access to the SQL server then you can configure it by yourself.  Google with keywords "sql server accept remote connections".  If not you have to rely on the owner to open the connection for you.

  • Marked as answer by Angie xu - MSFT on Nov 18, 2012 10:53 PM