Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot connect to a remote server


Cannot connect to a remote server

Author
Message
Ed Salyer
Ed Salyer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36238 Visits: 18751
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
My Blog: www.voiceofthedba.com
chrismiller
chrismiller
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
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.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36238 Visits: 18751
Smile, 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 Smile

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
chrismiller
chrismiller
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
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.
Ed Salyer
Ed Salyer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
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.
chrismiller
chrismiller
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
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
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36238 Visits: 18751
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
My Blog: www.voiceofthedba.com
chrismiller
chrismiller
Grasshopper
Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)Grasshopper (23 reputation)

Group: General Forum Members
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
Matt Miller (#4)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7645 Visits: 18084
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search