amazon web services - Unable to connect on AWS - RDS DB : SQL Server 2012 Express -

-

i'm new in aws world. have issue access instance of microsoft sql server 2012 express (11.00.5058) on rds (us-east-1a).

when have created db instance, able access it, create tables, transfer data, etc.. worked fine !

i didn't change , few hours after inactivity, try access sql server instance using microsoft sql server enterprise manager not able connect anymore. got following message:

cannot connect m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com,1433.

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: tcp provider, error: 0 - wait operation timed out.) (microsoft sql server, error: 258)

currently, instance appears available, security group 'rds-launch-wizard (sg-be4afcc6)'.

i have try connect 1433 port on via telnet , no success.

instance name m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com.

do have idea append ?

thank lot help.

updated

telnet command return :

telnet m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com 1433  connecting m3instance.cqbvdcpcgye3.us-east-1.rds.amazonaws.com... not open connection host, on port 1433: connect failed

db settings :

enter image description here

security group :

enter image description here enter image description here

vpc :

enter image description here

i have tried connect using home connection, or coffee shop wifi without success. didn't check ip address @ moment strange thing able connect sql server when have created db instance (create sql table, transfer data, etc...) after few hours (and without change), not able access it.

may if add new rule in security group / inbound rule this,it fix issue : (i didn't try yet because i'm @ work right , have firewall block sql access)

enter image description here

at point, data not sensitive , security not big issue.

thank again guys !!!

this because maybe choose default group , edit security group , in (inbound) add rule , allow connection (anywhere)


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more