Cannot Connect From Amazon aws t2.micro windows 2012 instance to Amazon RDS SQL Express 2014
I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.
- 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
1 retry, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +156
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +258
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312
1
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
retry) +202
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
1.GetResults(Nullable
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.ObjectQuery1
1.System.Collections.Generic.IEnumerable.GetEnumerator()
forMergeOption) +48
System.Data.Objects.ObjectQuery
+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
add a comment |
I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.
- 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
1 retry, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +156
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +258
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312
1
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
retry) +202
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
1.GetResults(Nullable
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.ObjectQuery1
1.System.Collections.Generic.IEnumerable.GetEnumerator()
forMergeOption) +48
System.Data.Objects.ObjectQuery
+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
add a comment |
I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.
- 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
1 retry, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +156
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +258
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312
1
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
retry) +202
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
1.GetResults(Nullable
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.ObjectQuery1
1.System.Collections.Generic.IEnumerable.GetEnumerator()
forMergeOption) +48
System.Data.Objects.ObjectQuery
+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
I cannot connect to RDS SQL Server 2014 Express instance from EC2 Windows 2012 server instance.
- 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
1 retry, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +156
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
owningConnection, TaskCompletionSource
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +258
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource1 retry, DbConnectionOptions userOptions) +312
1
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
retry) +202
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
1.GetResults(Nullable
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.ObjectQuery1
1.System.Collections.Generic.IEnumerable.GetEnumerator()
forMergeOption) +48
System.Data.Objects.ObjectQuery
+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
windows-server-2012-r2 amazon-ec2 amazon-rds sql-server-2014
edited Feb 13 at 11:57
Shujaat Kagathra
asked Feb 13 at 11:24
Shujaat KagathraShujaat Kagathra
12
12
add a comment |
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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