| Author |
Topic |
|
kanirip
Starting Member
12 Posts |
 Posted - 2008-09-02 : 06:57:28
|
| Hello there,I am having a serious problem connecting to a remote SQL Server on the Internet(from my Webhost).I am having an issue connecting to my Web Host SQL Server. I have listed all the symptoms of the failure and having worked on this problem for the best part of 3 months and I have finally come to the conclusion that I might have to ask for help.Please I really need help on this issue, I will be very gratefulSo here are the symptoms as recommended : 1. What is the connection string in your app or DSN? Don't know, I am using Enterprise Manager 2. If client fails to connect, what is the client error messages? SQL Server does not exist or Access Denied 3. Is the client remote or local to the SQL server machine? Remote 4. Can you ping your server? Yes 5. Can you telnet to your SQL Server? No6. What is your client database provider? what is your client application? Enterprise Manager/Query Analyzer 7. Is your client computer in the same domain as the Server computer? Different Domains across Internet 8. What protocol the client enabled? TCP/IP 9. Do you have aliases configured that match the server name portion of your connection string?I have created an Alias to match the name and IP address. 10. Do you select force encryption on server and/or client? Don't know how this is done 8.[2a] Tool Used to Connect What tool or Application are you using to connect to SQL Server? SQL Server 2000 Enterprise Edition SP4 without MSDE SP4 patch installed. [3] Platform: 1. What is the OS version? Windows 2003 Enterprise Edition 2. Do you have third party antivirus, anti-spareware software installed? Symantec Corporate Edition v 10When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-02 : 09:46:37
|
| Thanks 4 the advice afrika!I tried the instructions on the page you sent and I am still getting the error.The issue is that I want to ultimately want to replicate between my in house Server and the Web host SQL Server so I don't ideally want to connect via MS Express or any web-based admin tool.My thing is that my nslookup seems to be pointing to a different IP address than the IP address of the webserver but ping and pathping resolve the name to the correct IP address. Are you aware of any possible reprecursions this sort of thing could have?Thanks for all the assistance!When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-02 : 12:42:45
|
| Most probably the db is on another "SHARED" Server which is most of the time the case.As your web host for the connection details. |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-02 : 14:45:09
|
| Thanks for the help Afrika,Will mail the ISP and get back to you on this probably tomorrow.Thanks again.When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-02 : 17:55:36
|
Glad to help  |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-03 : 04:33:44
|
| Good Morning ,Do you know of any peculiarities involved with connecting to 'Shared' SQL Servers?I have contacted the Webhosts and they say that they have not blocked any IP addresses on their firewall.So right now I am in Limbo with regards my next line of action.Is it possible the Databse they created for me is actually an instance of SQL Server? I'm willing to try anything at the moment.Any suggestions?When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-03 : 05:00:49
|
| You have to be specific about the problem u are having. And what u are trying to do ? |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-03 : 07:22:11
|
| Thanks again afrika,All I am simply trying to do is connect to a remote SQL Server which is located at my webhosts in the US.The Webhosts are acting quite difficult. They don't seem to know much about their servers.In the long run I might want to replicate between the in-house servers and the Webhost ISP SQL Server.But right now I just want to connect to their servers. I have done some port scanning using ZenMap and found that their Server actually DOES have the SQL Server port open but it seems to be filtered! I am truly baffled.My configuration basically is a couple of in-house servers connected via a VSAT connection to the internet with an iDirect router in between.I have telnetted into the router just to see if I can monitor what packets are sent and received and I have not been lucky on that end as well.Do you think that cos I am within a corporate Network I might have to do additional work just to set it up. I am with an AD-based domain internally and maybe I am getting this error because the remote server is not in the same domain as I am.In fact I think that is the main problem because I have secondary SQL Servers within the organisation which I can connect to without much fuss. Do you know how I can check if RPC is enabled on the SQL Server?Thanks for all the assistance.When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-03 : 07:47:39
|
| best adviceget a new web host. Many options out there with 24x7x365 support and friendly support staff. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-03 : 07:55:43
|
| I would first try to see if you can connect with Enterprise manager or management studio. Based on the configuration there are giving you.Ask them for the settings, if u cant. Try to connect to another SQL instance on your network. Thats key |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-03 : 09:36:56
|
| I have tried all that afrika to no avail whatsoever.I have 1 more plan but I will need your help.Do you have access to a machine with SQL Server and the Internet? If you do can I have your email addy or something in some coded format?Thanks afrikaWhen you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-03 : 09:46:27
|
| Well, am using MS SQL Express and developer editions and use virgin media broadband 8gb of data transfer at home.Will prefer to keep things within this forum |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-03 : 11:42:45
|
| No problem.Can you connect to remote SQL Servers over the internet?The only reason why I requested your email was because I wanted to at least give you my credentials so that you could determine if you could login into the servers and then I would know that it's definitely a problem on my side.No offense taken at not wanting to put your details online. I normally wouldn't but desperate times call for desperate measures.Is there any PM(Private Message) facility on this site?Thanks again.When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-03 : 12:17:48
|
quote:
Originally posted by kanirip
Can you connect to remote SQL Servers over the internet?
YesHave been doing so before i joined sqlteam. Which was in 2004 |
|
|
|
kanirip
Starting Member
12 Posts |
Posted - 2008-09-03 : 13:06:13
|
| OK Lemme rephrase:Can you help me connect to MY Database via the internet. I need to do this to determine where the problems reside.If you can connect then the problem lies between my ISP and my webhost.Please I would be very grateful if you could do this.And just inform me however you want me to get my credentials to you. As I said I would be grateful. Thanks.When you looks into an abyss, the abyss looks also into you-- Friedrich Nietsczhe |
|
|
|
|
SQL Connectivity Issues