asp.net - Cant connect to sqlserver -

asp.net - Cant connect to sqlserver -

im trying install asp.net membership scheme on remote sql server error shows up:

setup failed.

exception: unable connect sql server database.

details of failure system.web.httpexception (0x80004005): unable connect sql server database. ---> system.data.sqlclient.sqlexception (0x80131904): connection established server, error occurred during pre-login handshake. (provider: ssl provider, error: 0 - wait operation timed out.) ---> system.componentmodel.win32exception (0x80004005): wait operation timed out @ system.data.sqlclient.sqlinternalconnection.onerror(sqlexception exception, boolean breakconnection, action`1 wrapcloseinaction) @ system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj, boolean callerhasconnectionlock, boolean asyncclose) @ system.data.sqlclient.tdsparser.consumepreloginhandshake(boolean encrypt, boolean trustservercert, boolean integratedsecurity, boolean& marscapable) @ system.data.sqlclient.tdsparser.connect(serverinfo serverinfo, sqlinternalconnectiontds connhandler, boolean ignoresniopentimeout, int64 timerexpire, boolean encrypt, boolean trustservercert, boolean integratedsecurity, boolean withfailover) @ system.data.sqlclient.sqlinternalconnectiontds.attemptonelogin(serverinfo serverinfo, string newpassword, securestring newsecurepassword, boolean ignoresniopentimeout, timeouttimer timeout, boolean withfailover) @ system.data.sqlclient.sqlinternalconnectiontds.loginnofailover(serverinfo serverinfo, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance, sqlconnectionstring connectionoptions, sqlcredential credential, timeouttimer timeout) @ system.data.sqlclient.sqlinternalconnectiontds.openloginenlist(timeouttimer timeout, sqlconnectionstring connectionoptions, sqlcredential credential, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance) @ system.data.sqlclient.sqlinternalconnectiontds..ctor(dbconnectionpoolidentity identity, sqlconnectionstring connectionoptions, sqlcredential credential, object providerinfo, string newpassword, securestring newsecurepassword, boolean redirecteduserinstance, sqlconnectionstring userconnectionoptions) @ system.data.sqlclient.sqlconnectionfactory.createconnection(dbconnectionoptions options, dbconnectionpoolkey poolkey, object poolgroupproviderinfo, dbconnectionpool pool, dbconnection owningconnection, dbconnectionoptions useroptions) @ system.data.providerbase.dbconnectionfactory.createpooledconnection(dbconnectionpool pool, dbconnectionoptions options, dbconnectionpoolkey poolkey, dbconnectionoptions useroptions) @ system.data.providerbase.dbconnectionpool.createobject(dbconnectionoptions useroptions) @ system.data.providerbase.dbconnectionpool.usercreaterequest(dbconnectionoptions useroptions) @ system.data.providerbase.dbconnectionpool.trygetconnection(dbconnection owningobject, uint32 waitformultipleobjectstimeout, boolean allowcreate, boolean onlyonecheckconnection, dbconnectionoptions useroptions, dbconnectioninternal& connection) @ system.data.providerbase.dbconnectionpool.trygetconnection(dbconnection owningobject, taskcompletionsource`1 retry, dbconnectionoptions useroptions, dbconnectioninternal& connection) @ system.data.providerbase.dbconnectionfactory.trygetconnection(dbconnection owningconnection, taskcompletionsource`1 retry, dbconnectionoptions useroptions, dbconnectioninternal& connection) @ system.data.providerbase.dbconnectionclosed.tryopenconnection(dbconnection outerconnection, dbconnectionfactory connectionfactory, taskcompletionsource`1 retry, dbconnectionoptions useroptions) @ system.data.sqlclient.sqlconnection.tryopen(taskcompletionsource`1 retry) @ system.data.sqlclient.sqlconnection.open() @ system.web.management.sqlservices.getsqlconnection(string server, string user, string password, boolean trusted, string connectionstring) clientconnectionid:24557c63-f9b1-498c-bd1d-0d678f29f795 @ system.web.management.sqlservices.getsqlconnection(string server, string user, string password, boolean trusted, string connectionstring) @ system.web.management.sqlservices.setupapplicationservices(string server, string user, string password, boolean trusted, string connectionstring, string database, string dbfilename, sqlfeatures features, boolean install) @ system.web.management.confirmpanel.execute()

i have same problem connecting remote sql server vs2012

this problem may occur if 1 or more of next conditions true:

sql server not configured take remote connections. the necessary protocols sql server not enabled on either sql server computer or sql server client computer running biztalk server.

following these steps may resolve problem:

the sql server surface area configuration tool not available on sql server 2008. enable remote connections sql server on sql server 2008 computer follow instructions in sql server 2008 online help.

use sql server configuration manager tool enable tcp/ip and/or named pipes protocols on sql server computer.

click start, point all programs, , click sql server configuration manager.

click expand sql server network configuration , click protocols mssqlserver.

right-click tcp/ip protocol , click enable.

right-click named pipes protocol , click enable.

close sql server configuration manager tool.

use sql server configuration manager tool enable tcp/ip and/or named pipes protocols on sql server client computer running biztalk server.

click start, point all programs, , click sql server configuration manager.

click expand sql server network configuration , click clientprotocols.

right-click tcp/ip protocol , click enable.

right-click named pipes protocol , click enable.

close sql server configuration manager tool.

note: ensure @ to the lowest degree 1 of protocols on sql server client computer running biztalk server matches protocols enabled on sql server computer.

asp.net sql-server database-connection