Cannot Connect From Amazon aws t2.micro windows 2012 instance to Amazon RDS SQL Express 2014












0















I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.




  1. I cannot connect through UDL file, and also not through my asp.net mvc web application.


Windows EC2 Instnace ID: i-0fe6390a77605e7f2
Availaibility Zone: us-east-2c



RDS SQL Server Instnace ID: tandt-201901-2
RDS SQL Server Zone: us-east-2c



I am able to connect to this RDS SQL Server through following on port 1433 :
1. SQL Server Management Studio from my development laptop
2. UDL File from my development laptop
3. Asp.NET MVC 4 Entity framework Web App from my development laptop.



Detailed Error Message from asp.net mvc web application is pasted below:




[Win32Exception (0x80004005): The wait operation timed out]

[SqlException (0x80131904): 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: TCP Provider, error: 0 - The wait operation
timed out.)]

System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean
allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +345

System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, TaskCompletionSource1 retry, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +156

System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource
1 retry, DbConnectionOptions
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +258

System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312

System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
1
retry) +202

System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
retry) +413 System.Data.SqlClient.SqlConnection.Open() +128

System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
openCondition, DbConnection storeConnectionToOpen, DbConnection
originalConnection, String exceptionCode, String attemptedOperation,
Boolean& closeStoreConnectionOnFailure) +40 [EntityException: The
underlying provider failed on Open.]

System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
openCondition, DbConnection storeConnectionToOpen, DbConnection
originalConnection, String exceptionCode, String attemptedOperation,
Boolean& closeStoreConnectionOnFailure) +208

System.Data.EntityClient.EntityConnection.Open() +128

System.Data.Objects.ObjectContext.EnsureConnection() +83

System.Data.Objects.ObjectQuery
1.GetResults(Nullable1
forMergeOption) +48

System.Data.Objects.ObjectQuery
1.System.Collections.Generic.IEnumerable.GetEnumerator()
+40 System.Linq.Enumerable.First(IEnumerable`1 source) +212




Your urgent help is required to solve this issue.










share|improve this question





























    0















    I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.




    1. I cannot connect through UDL file, and also not through my asp.net mvc web application.


    Windows EC2 Instnace ID: i-0fe6390a77605e7f2
    Availaibility Zone: us-east-2c



    RDS SQL Server Instnace ID: tandt-201901-2
    RDS SQL Server Zone: us-east-2c



    I am able to connect to this RDS SQL Server through following on port 1433 :
    1. SQL Server Management Studio from my development laptop
    2. UDL File from my development laptop
    3. Asp.NET MVC 4 Entity framework Web App from my development laptop.



    Detailed Error Message from asp.net mvc web application is pasted below:




    [Win32Exception (0x80004005): The wait operation timed out]

    [SqlException (0x80131904): 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: TCP Provider, error: 0 - The wait operation
    timed out.)]

    System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
    owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean
    allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions
    userOptions, DbConnectionInternal& connection) +345

    System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
    owningObject, TaskCompletionSource1 retry, DbConnectionOptions
    userOptions, DbConnectionInternal& connection) +156

    System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
    owningConnection, TaskCompletionSource
    1 retry, DbConnectionOptions
    userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
    connection) +258

    System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
    outerConnection, DbConnectionFactory connectionFactory,
    TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312

    System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
    1
    retry) +202

    System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
    retry) +413 System.Data.SqlClient.SqlConnection.Open() +128

    System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
    openCondition, DbConnection storeConnectionToOpen, DbConnection
    originalConnection, String exceptionCode, String attemptedOperation,
    Boolean& closeStoreConnectionOnFailure) +40 [EntityException: The
    underlying provider failed on Open.]

    System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
    openCondition, DbConnection storeConnectionToOpen, DbConnection
    originalConnection, String exceptionCode, String attemptedOperation,
    Boolean& closeStoreConnectionOnFailure) +208

    System.Data.EntityClient.EntityConnection.Open() +128

    System.Data.Objects.ObjectContext.EnsureConnection() +83

    System.Data.Objects.ObjectQuery
    1.GetResults(Nullable1
    forMergeOption) +48

    System.Data.Objects.ObjectQuery
    1.System.Collections.Generic.IEnumerable.GetEnumerator()
    +40 System.Linq.Enumerable.First(IEnumerable`1 source) +212




    Your urgent help is required to solve this issue.










    share|improve this question



























      0












      0








      0








      I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.




      1. I cannot connect through UDL file, and also not through my asp.net mvc web application.


      Windows EC2 Instnace ID: i-0fe6390a77605e7f2
      Availaibility Zone: us-east-2c



      RDS SQL Server Instnace ID: tandt-201901-2
      RDS SQL Server Zone: us-east-2c



      I am able to connect to this RDS SQL Server through following on port 1433 :
      1. SQL Server Management Studio from my development laptop
      2. UDL File from my development laptop
      3. Asp.NET MVC 4 Entity framework Web App from my development laptop.



      Detailed Error Message from asp.net mvc web application is pasted below:




      [Win32Exception (0x80004005): The wait operation timed out]

      [SqlException (0x80131904): 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: TCP Provider, error: 0 - The wait operation
      timed out.)]

      System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
      owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean
      allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions
      userOptions, DbConnectionInternal& connection) +345

      System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
      owningObject, TaskCompletionSource1 retry, DbConnectionOptions
      userOptions, DbConnectionInternal& connection) +156

      System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
      owningConnection, TaskCompletionSource
      1 retry, DbConnectionOptions
      userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
      connection) +258

      System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
      outerConnection, DbConnectionFactory connectionFactory,
      TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312

      System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
      1
      retry) +202

      System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
      retry) +413 System.Data.SqlClient.SqlConnection.Open() +128

      System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
      openCondition, DbConnection storeConnectionToOpen, DbConnection
      originalConnection, String exceptionCode, String attemptedOperation,
      Boolean& closeStoreConnectionOnFailure) +40 [EntityException: The
      underlying provider failed on Open.]

      System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
      openCondition, DbConnection storeConnectionToOpen, DbConnection
      originalConnection, String exceptionCode, String attemptedOperation,
      Boolean& closeStoreConnectionOnFailure) +208

      System.Data.EntityClient.EntityConnection.Open() +128

      System.Data.Objects.ObjectContext.EnsureConnection() +83

      System.Data.Objects.ObjectQuery
      1.GetResults(Nullable1
      forMergeOption) +48

      System.Data.Objects.ObjectQuery
      1.System.Collections.Generic.IEnumerable.GetEnumerator()
      +40 System.Linq.Enumerable.First(IEnumerable`1 source) +212




      Your urgent help is required to solve this issue.










      share|improve this question
















      I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.




      1. I cannot connect through UDL file, and also not through my asp.net mvc web application.


      Windows EC2 Instnace ID: i-0fe6390a77605e7f2
      Availaibility Zone: us-east-2c



      RDS SQL Server Instnace ID: tandt-201901-2
      RDS SQL Server Zone: us-east-2c



      I am able to connect to this RDS SQL Server through following on port 1433 :
      1. SQL Server Management Studio from my development laptop
      2. UDL File from my development laptop
      3. Asp.NET MVC 4 Entity framework Web App from my development laptop.



      Detailed Error Message from asp.net mvc web application is pasted below:




      [Win32Exception (0x80004005): The wait operation timed out]

      [SqlException (0x80131904): 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: TCP Provider, error: 0 - The wait operation
      timed out.)]

      System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
      owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean
      allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions
      userOptions, DbConnectionInternal& connection) +345

      System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
      owningObject, TaskCompletionSource1 retry, DbConnectionOptions
      userOptions, DbConnectionInternal& connection) +156

      System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
      owningConnection, TaskCompletionSource
      1 retry, DbConnectionOptions
      userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
      connection) +258

      System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
      outerConnection, DbConnectionFactory connectionFactory,
      TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312

      System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
      1
      retry) +202

      System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
      retry) +413 System.Data.SqlClient.SqlConnection.Open() +128

      System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
      openCondition, DbConnection storeConnectionToOpen, DbConnection
      originalConnection, String exceptionCode, String attemptedOperation,
      Boolean& closeStoreConnectionOnFailure) +40 [EntityException: The
      underlying provider failed on Open.]

      System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean
      openCondition, DbConnection storeConnectionToOpen, DbConnection
      originalConnection, String exceptionCode, String attemptedOperation,
      Boolean& closeStoreConnectionOnFailure) +208

      System.Data.EntityClient.EntityConnection.Open() +128

      System.Data.Objects.ObjectContext.EnsureConnection() +83

      System.Data.Objects.ObjectQuery
      1.GetResults(Nullable1
      forMergeOption) +48

      System.Data.Objects.ObjectQuery
      1.System.Collections.Generic.IEnumerable.GetEnumerator()
      +40 System.Linq.Enumerable.First(IEnumerable`1 source) +212




      Your urgent help is required to solve this issue.







      windows-server-2012-r2 amazon-ec2 amazon-rds sql-server-2014






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Feb 13 at 11:57







      Shujaat Kagathra

















      asked Feb 13 at 11:24









      Shujaat KagathraShujaat Kagathra

      12




      12






















          0






          active

          oldest

          votes











          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405233%2fcannot-connect-from-amazon-aws-t2-micro-windows-2012-instance-to-amazon-rds-sql%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1405233%2fcannot-connect-from-amazon-aws-t2-micro-windows-2012-instance-to-amazon-rds-sql%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          flock() on closed filehandle LOCK_FILE at /usr/bin/apt-mirror

          Mangá

          Eduardo VII do Reino Unido