Re: Connect to SQL Server over the internet

If you have removed the firewall (must be removed from both machines), then
you shouldn't have any problem connecting to the SQL-Server using the
connection dialog window that you will find on the main menu: File ->
Connection.

Select the server from the drop down list or other its name or its TCP/IP
number and give the proper login and password.

Of course, instead of removing the firewalls, you can also open them for the
port 1433; which is the port used by SQL-Server in its basic configuration.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Jose Perdigao" <perdijc@xxxxxxxxxxx> wrote in message
news:%239p7tlhYGHA.4684@xxxxxxxxxxxxxxxxxxxxxxx
I don't have this problem because I'm testing with my computers (computer A
& B). I can remove the firewall.
I'm working with SQL Server 2000 and MS Access 2003.
So, how can I do?
Thanks.


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:%23WBWTTZYGHA.4684@xxxxxxxxxxxxxxxxxxxxxxx
You shouldn't have any problem if there are no blocking firewall.
However, many hosting services will protect their SQL-Server behind a
firewall (in this case, there are no solution), so I suspect that this
might be your problem.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Jose Perdigao" <perdijc@xxxxxxxxxxx> wrote in message
news:uvHa4qUYGHA.4620@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

Computer A is where is installed SQL server 2000 and the BE. Computer B,
I have the FE (ADP in access 2003). The both computers are connected the
internet.



So, how can I connect to SQL Server over the internet? I mean, I want
connect my FE Computer B) to BE (computer A).



I listen something, we can do this connection trough IP address, but I
don't have idea how can I do.



Any Ideas?

Thanks,

José Perdigão








.

Relevant Pages

  • Re: Connectivity Issues - Bizzare
    ... Sounds like firewall to me. ... >I am trying to connect to a default instance of SQL Server 2000 Enterprise ... I create a SqlDataAdapter on the web form, ... I take the same connection string from the web app, ...
    (microsoft.public.sqlserver.connect)
  • Re: data acces page connect to sql server
    ... the connection even if the parameters are OK; like a firewall for example. ... Using an Alias (see SQL-Server Client Network Utility or something like ... my data access page to the sql server. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: data acces page connect to sql server
    ... the connection even if the parameters are OK; like a firewall for example. ... Using an Alias (see SQL-Server Client Network Utility or something like ... often solve some of these connection problems. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: connecting to SQL Server 2000 from a VB.net app using ADO.net
    ... In terms of connectivity issues over the Internet, firewall ... TCP Ports Needed for Communication to SQL Server ... I can't create a remote connection in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)
  • Re: Named pipe error 53
    ... Did you try disabling the firewall on the Windows XP machine to see if it is dedicted to the settings of the firewall? ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... (provider: Named Pipes Provider, error: 40 - Could not open a connection to ...
    (microsoft.public.sqlserver.connect)
Quantcast