Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server doesn't accept remote connections. Expand / Collapse
Author
Message
Posted Sunday, March 3, 2013 2:50 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 12, 2013 11:15 AM
Points: 5, Visits: 25
Hello,

I am trying to use my SQL Server in my Perl application. I am hosting my Perl code on an external hosting server.

When I was developing my code I was running it on a computer on the same network as the server and everything worked fine. But, when I uploaded the code to the hosting service (replacing the local IP with the public IP of the server), it started failing in the part where it connects to the database saying that the server wasn't found.

Maxwell.

P.S. I did forward port 1433 and I even put the server as DMZ Host (which puts that computer in front of the firewall).
Post #1426018
Posted Sunday, March 3, 2013 11:16 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:38 PM
Points: 3,931, Visits: 7,160
I would check 2 things:
1) On your SQL Server, have you allowed remote connections to the server?
2) In your linked server set up, did you set the Data Access to true?


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426093
Posted Monday, March 4, 2013 12:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 3:03 AM
Points: 1,062, Visits: 708
1) Right click on Sql Server in Sql Management Studio (SMS) -> Connections -> Allow remote connections

2) Right click on Sql Server in Sql Management Studio (SMS) -> Security -> Allow remote connections

3) Sql Server Configuration Manager -> Network Configuration -> Protocols -> Enable Shared memory, Named pipes, TCP/IP

Plz check above steps with option Firewall, to allow N/W traffic od SQL Server.
Post #1426099
Posted Monday, March 4, 2013 4:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 7, 2014 9:40 AM
Points: 279, Visits: 91
@MDTech.us_MAN
I am guessing this is a shared hosting solution. In that you would not have any access to the server configuration.
I would suggest that you get in touch with you service provider and confirm the name of the SQLserver instance. once you have that, the ensure you database connnection config points to the correct server.

Makarand
Post #1426182
Posted Monday, March 4, 2013 9:36 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 12, 2013 11:15 AM
Points: 5, Visits: 25
1 This SQL server is fully hosted by ME. Only the Perl is hosted my some other company.
1.1 I can't use a third-party SQL hosting service because, I need the SQL Job Agent, which lets me schedule jobs. (I am planing to make a notification job that sends out emails).

2 I don't see the Data Access option in Perl. So I can't set it to true.

3 I already set the remote access option a long time ago.

Maxwell.
Post #1426324
Posted Monday, March 4, 2013 1:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:38 PM
Points: 3,931, Visits: 7,160

2 I don't see the Data Access option in Perl. So I can't set it to true.

This is an option on the linked server to the Perl Server?


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426447
Posted Monday, March 4, 2013 7:55 PM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 12, 2013 11:15 AM
Points: 5, Visits: 25
Currently, I don't have a linked server. I connect directly to the SQL Server.
Do I need a linked server?

Maxwell.
Post #1426569
Posted Monday, March 4, 2013 8:03 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:38 PM
Points: 3,931, Visits: 7,160
My apologies I believe I misunderstood you from the start
When I was developing my code I was running it on a computer on the same network as the server and everything worked fine. But, when I uploaded the code to the hosting service (replacing the local IP with the public IP of the server), it started failing in the part where it connects to the database saying that the server wasn't found.
You can't get from your hosting service (which is where the Perl application resides) back into your SQL server.

I don't believe the issue is port-forwarding; you're going to need to allow port 1433 (or whatever port you forwarded that to) through the firewall back to your SQL Server. Not sure what firewall you're using or if you even have access to it, but it would be some TCP rule that allows in "*", and is routed to your internal SQL Server IP address and the appropriate port.


______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426571
Posted Monday, March 4, 2013 8:04 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:38 PM
Points: 3,931, Visits: 7,160
As a test, on the external hosted Perl server, can you open a telnet session and connect to the internal IP address of the SQL Server?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1426572
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse