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 ««123»»

Cannot connect to a remote server Expand / Collapse
Author
Message
Posted Monday, March 24, 2008 8:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 24, 2012 5:23 AM
Points: 3, Visits: 107
I was not speaking of a firewall on the PC you are using when trying to connect to the remote db. My firewall exceptions needed to be set on the Windows Server 2003 PC that I connect to that houses my SQL 2000 and SQL Server 2005 database servers. You would need to have the hosting server folks verify they have the firewall exceptions added that are needed, unless they have their firewall disabled, which I wouldn't think would be a great idea.
Post #473487
Posted Monday, March 24, 2008 8:35 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:53 PM
Points: 33,063, Visits: 15,179
Ed has a good point. I'd also ask the hosting company if they allow direct, 1433 connections from your local PC to the remote SQL Server. They might not.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #473491
Posted Monday, March 24, 2008 8:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 16, 2009 8:18 AM
Points: 23, Visits: 141
Thats what they told me that i am allowed to connect through 1433. Its getting to the point where i think i may need to get a new hosting company, because in all respect its not supposed to be this difficult. This has been going on since friday.
Post #473493
Posted Monday, March 24, 2008 8:41 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:53 PM
Points: 33,063, Visits: 15,179
:), It certainly shouldn't be.

Willing to do a test if you like. If I mess it up, feel free to post a complaint here where everyone can see it :)







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #473497
Posted Monday, March 24, 2008 8:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 16, 2009 8:18 AM
Points: 23, Visits: 141
lol..Thanks Steve,
I sent you an email about 10 minutes with all the info you will need.

Again thanks for all the help. It seems as though the hosting company is stumped altogether on this..lol

I sent them 3 tracert's already and it times out outside their server.
Post #473501
Posted Monday, March 24, 2008 8:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 24, 2012 5:23 AM
Points: 3, Visits: 107
Tracert timing out doesn't surprise me at all. When I didn't have my firewall exceptions set properly, although I had enabled exceptions as identified in MS KB Article 914277 (sqlserver.exe & sqlbrowser.exe), I also could not ping my "hosting" server. It would continually show request timed out, which is what led me down the path of the firewall to being with. Then when I could ping and connect using SSMSE from the XP machine when I disabled the firewall, it took no time to determine what was not identified in the article, File and Printer Sharing needed to be enabled.
Post #473507
Posted Monday, March 24, 2008 9:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 16, 2009 8:18 AM
Points: 23, Visits: 141
The funny thing is, is that I can ping the server that my db is residing on. I had afriend of mine try connecting from his workplace and he can't get connected either, and he works at a development company. So if he can't even connect and I am not sure if steve will be able to but if he can't connect either then it definetly has to an issue at the hostibg company.

They had asked me a couple days ago to ask my isp if they were blocking port 1433, and they said no the only port in which they block is 25.

I will give the hosting company another day or so before i end up pulling the plug. because like i have said its not supposed to be this difficult. I even have my router wide open, no security settings at all. Its there for people to piggy back which sucks for me.
They were making me believe that it was from my end...I even unistalled sqlexpress 2 times and set it up again with all defualts i changed the settings after words in the config and surface config to enable tcpip and pipes local and remote connections everything is enabled for it to be a go but it doesn't work.

When i was developing at a compnay i was previously at i had no issues connecting to my db's or internal dbs on the intranet. This is getting to the point of beyond ridiculous.

maybe their servers don't like canadian connections..lmao
Post #473525
Posted Monday, March 24, 2008 9:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:53 PM
Points: 33,063, Visits: 15,179
The connection worked fine for me with credentials Chris supplied, so I'm guessing there's some firewall or limiting factor either on his network or elsewhere. I sent some screen shots to Chris of what I have for SSMS and asked if he has the Express edition or Developer SSMS.

Chris, one more thought, have you used this laptop elsewhere to connect to SQL Servers? Can you try from another network as a test, even a Starbucks/hotspot?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #473533
Posted Monday, March 24, 2008 9:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 16, 2009 8:18 AM
Points: 23, Visits: 141
Hi Steve,
No i am not using a laptop..its my own pc, with a wireless card on it.
I am using express edition 2005
Post #473538
Posted Monday, March 24, 2008 1:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 7,118, Visits: 15,000
The bigger question is - why is it set up this way? The fact that the hosting company has your database server set up "in the open" would be a HUGE red flag. That's like leaving the keys in your car AND putting up the neon sign pointing that out to everyone coming by.

All due respect - there's no way you should be able to connect remotely to the database via SSMS over the internet. That's a HUGE security flaw, and (IMO) whichever hosting company set this up ought go back and review their security setup. Of course - that involves pulling their head out of wherever it's stuck right now.....


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #473685
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse