September 21, 2010 at 4:38 am
Hi Experts,
iam connecting to SQL Server 2005 with "sa" account. when i opening the SQL Event logs the following error is getting.
"A connection was successfully established with server, but then an error occured during the login process (provider: TCP provider,
error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)"
i verified all server & client protocals, its fine....
& there is No information in Error Logs...
plz Help me!
September 21, 2010 at 4:43 am
is sql enabled for mixed mode authentication or only windows authentication?
----------
Ashish
September 21, 2010 at 4:56 am
Mixed mode Authentication....
September 21, 2010 at 5:04 am
ok, is your TCP/IP protocol enabled?
Check in configuration manager--sqlserver network configuration--protocol for mssqlserver.
it might be disabled. Enable it and try to connect.
----------
Ashish
September 21, 2010 at 5:16 am
TCP/IP is Enabled Status.
September 21, 2010 at 5:24 am
ok, are you able to connect using sqlcmd...
try with sqlcmd and let us know if you have same error ..
At the command prompt, type the following command, and then press ENTER.
sqlcmd.exe -E -S servername
----------
Ashish
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply