Unable to connect to remote SQL Server


hi,

i have 2 machines here on lan. both used connect , log on remote (internet) sql server 2012 successfully. client using ssms.

as of yesterday, 1 machine can still connect server, , other cannot. before attach error dump let me have 'repaired' sql server files, , have 'restored' os point 4 days ago - no avail. have scanned viruses - norton did not find any. running out of ideas. short of re-installing - have ideas??

the 'bad' machine running windows 7 pro of latest updates. running ssms off of sql server 2012 developer edition.

here error dump. feedback welcome.

thanks,

pb

title: connect server
------------------------------

cannot connect <server name>.

------------------------------
additional information:

a connection established server, error occurred during pre-login handshake. (provider: ssl provider, error: 0 - wait operation timed out.) (microsoft sql server, error: 258)

for help, click: http://go.microsoft.com/fwlink?prodname=microsoft%20sql%20server&evtsrc=mssqlserver&evtid=258&linkid=20476

------------------------------

the wait operation timed out

------------------------------
buttons:

ok
------------------------------

server name: <server name>
error number: 258
severity: 20
state: 0


------------------------------
program location:

   @ 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.createnonpooledconnection(dbconnection owningconnection, dbconnectionpoolgroup poolgroup, dbconnectionoptions useroptions)
   @ 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()
   @ microsoft.sqlserver.management.sqlstudio.explorer.objectexplorerservice.validateconnection(uiconnectioninfo ci, iservertype server)
   @ microsoft.sqlserver.management.ui.connectiondlg.connector.connectionthreaduser()

===================================

the wait operation timed out

 

pmbt

please have @ these links:

sql server 2012 .net 4.5 sql connection pre-login handshake error: 258

connecting smms or vs gives 258 error

visual studio 11 beta installation disabled abillity connect remote ms sql server not local databases

sqldevelop.wordpress.com



SQL Server  >  Getting started with SQL Server



Comments

Post a Comment

Popular posts from this blog

SQL server replication error Cannot find the dbo or user defined function........

hi there, i ran problem while deploying sql 2008 transactional replication between 2 servers lets assume server , b. actually created  both distributor , publisher on server , after created subscriber pointed server b, launch replication monitor , found big red cross. when click on tab "distributor subscriber history" error says "cannot find either column "dbo" or user defined-function or aggregate "dbo.ufnleadingzeros", or name ambiguous". can body regarding issue. regards, ishuv hi, you need compare data , others reseved, index size, unused should not compared. differs. here server - data - 87896 kb server b - data - 78152 kb server data size includes publication tables, can't compare directly. need check article article know exact data size. SQL Server  >  ...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

Admin Permissions

hi need create new 'role' following permissions, 1. access sql server logs. 2. access maintenance plans ( can avoid access) 3. access activity monitor 4. normal access product databases , not system db´s need guidance on how it, can point me in right direction please? thanks 1.grant  execute on xp_readerrorlog [domainname\ad user or group]; 2. http://technet.microsoft.com/en-us/library/ms191002.aspx 3.view server state permission 4. make user member of dbo_owner database role. best regards,uri dimant sql server mvp, http://sqlblog.com/blogs/uri_dimant/ ms sql optimization: ms sql development , optimization ms sql consulting: large scale of database , data cleansing remote dba services: improves ms sql database performance sql server integration services: business intelligence SQL Server  >  ...
Read more