SQL 2012 Error 53

Question

Post reply

SQL 2012 Error 53

andyc209

Say Hey Kid

Points: 703
More actions
November 30, 2015 at 8:26 am

#309838

Trying to run a BCP command and get the following error:
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti
ons.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
NULL
I have gone through all the possible solutions on Google/ forums but cannot get this fixed. So far I have:
Ticked 'Allow remote connections' to this server
Enabled TCP/IP
Set IP2 to internal IP address of server
IPAll - cleared entry in TCP dynamic ports and put in 1433 into TCP Port
Enabled access to port within Windows Firewall even though the firewall is OFF
cannot think of anything else to try - any help would be really appreciated

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MadAdmin SSChampion Points: 11261 More actions · Answer 1

Show us the query please?

Catch-all queries done right [/url]
Gail Shaw's Performance Blog[/url]

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

andyc209 (11/30/2015)
Trying to run a BCP command and get the following error:
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti
ons.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
NULL
I have gone through all the possible solutions on Google/ forums but cannot get this fixed. So far I have:

Are you connecting to a named instance?

Are you running the query remotely?

This message usually appears when the instance you're trying to connect doesn't exist or is unreachable.

andyc209 (11/30/2015)
Ticked 'Allow remote connections' to this server
Enabled TCP/IP
Set IP2 to internal IP address of server

These are set dynamically, based on the TCP adapters on the server, don't touch them

andyc209 (11/30/2015)
IPAll - cleared entry in TCP dynamic ports and put in 1433 into TCP Port
Enabled access to port within Windows Firewall even though the firewall is OFF
cannot think of anything else to try - any help would be really appreciated

Supply more detail about the connection you're using and don't believe everything you read on google

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

"Ya can't make an omelette without breaking just a few eggs" 😉

andyc209 Say Hey Kid Points: 703 More actions · Answer 3

Thanks for the input - I am running this on a local machine - no accessing remote machines. I have installed an instance on a widows server 2008 machine and am running this command on the same box

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 4

Verify that, the IP Address is set to the computer's IP address on the local subnet and make sure that TCP Dynamic Ports is blank

andyc209 Say Hey Kid Points: 703 More actions · Answer 5

All done - IP address is he same and the ports bit is blank - really stuck on this one