Friday, February 24, 2012

Microsoft SQL Server, Error: 10053

O get this error when trying to connect to my database. About 5 minutes ago it was working fine...seems to go in and out. We have native client installed in this server as well so not sure why I keep having connection issues. I tried both Windows Authentification and local sql account, both are very choppy, sometimes works sometimes doesn't.

TITLE: Connect to Server

Cannot connect to BG-SQL2005.


ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An established connection was aborted by the software in your host machine.) (Microsoft SQL Server, Error: 10053)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10053&LinkId=20476


BUTTONS:

OK

I am also getting this error when trying to ALTER one of my stored procs :

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Mostlikely the server is closing the connections for some reason, possibly the client does not have permission to access some sqlserver resources, e.g. database, sp, xp. We might get more hint as to why if you could share out the sql server ERRORLOG.|||Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
aprint screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc|||I can't see your error log. Please also enable sql server traceflag -T4029 when you do the repro. Update the errorlog with latest repro.|||

issue resolved, reinstalled SQL Server 2005 completely

thanks for the inputs!

No comments:

Post a Comment