| Author |
Topic |
|
amjad171
Starting Member
15 Posts |
 Posted - 2008-09-17 : 10:36:37
|
| Hello,I'm new to SQL Server, migrating from MS Access. I have SQL Server 2005 Standard edition installed and the tables are all created and populated, the problem is connecting to the SQL Server database on our hosting provider, the error i get is along the lines of connection settings are not correct, SQL Server error 53. I have done a few things like started the Browser service, enabled TCP/IP and Named pipe connections, opened ports 1433 and 1434.All the above have not sorted out the problem and I still cannot connect to our hosting provider.Can anyone here help who may have come across something similar?Many thanks |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 10:49:46
|
| When you try to login. use the following:IPAddress,port numberusernamepassworduse port 1433, unless your hosting provider has changed it to something else. Use TCP/IP and not namepipes |
 |
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-17 : 11:02:12
|
| Hi afrika,Thanks for your help, I have tried the way you said;IPAddress,1433the usernamethe password.This does not let me connect however the error has changed to SQL Server error 10060, any ideas how to overcome this?thanks again |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 11:05:06
|
| seems to me either1. firewall restrictions or 2. You have not enabled remote connections on the remote server3. Also confirm with your provider if they are using the default 1433 sql port or it has been changed for security reasons |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-17 : 11:10:44
|
| Hi,I have followed online instructions to add ports 1433 as SQL Server with TCP enabled, 1434 as SQL Server Browser with UDP enabled. I have gone through the steps in SQL Server Surface Area Configuration, enabling the Browser service and the remote connections, this is still causing problems in connecting |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 11:30:23
|
| what error message ?can you ping and telnet the server ?do you have a firewall ? |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-17 : 11:38:33
|
Hi, this is the errorAn 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 connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060) I have trine pinging the IP address through our network and get a timed out error, there is something in our network that must be blocking the connection. I work in a large organisation and the computers are provided by a separate section. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-17 : 11:39:31
|
| 1. Did you enable remote connections ?2. Do you have a firewall ? |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-18 : 03:56:15
|
| Hi,I have enabled the remote connections and we do have a firewall, which I have follwed online help on to open ports 1433 and 1434 and set them as exceptions. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-18 : 04:25:15
|
| so ???What error message are you getting now ? Did you try to connect using the login options above ?Also, are you migrating from access to sql ? or sqlserver2005 to sqlserver2005 ? |
|
|
|
amjad171
Starting Member
15 Posts |
Posted - 2008-09-18 : 05:48:03
|
| Hi Afrika,I have had to get our central network team who manage the network. They have opened up port 1433 for me and this has sorted it out, I can now connect to the server. Many thanks for all your help. |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-18 : 05:54:20
|
Glad2help  |
|
|
|
|
Error connecting to database