Re: connecting to sql svr express over internet

"Sylvain Lafontaine" <sylvainlafontaine2009@xxxxxxxx> wrote in
news:#qNZVIAKKHA.3708@xxxxxxxxxxxxxxxxxxxx:

Beside removing the http:// as mentionned by Aaron, for the port
number, it must often be separated by a comma at the end of the
server's address when you when to specify it:

mydomainname.com\sqlexpress,1433

This is not always the case and it depends on the program used. You
can also add the prefix tcp: to specify the TCP protocol (or np: for
named pipe):

tcp:mydomainname.com\sqlexpress,1433

For ODBC, there are also situations where you must specify the correct
network library to be sure to use the TCP protocol. The best way of
dealing with these problem is to define in Alias - where you can
specify the address of the server and the protocol and the port (in
the case of TCP) to be used. See SQL Server Configuration Manager |
SQL Native Client Configuration | Aliases to create an alias.

As the port 1433 is not the regular port to be used with a named
instance, you should first verify on your LAN that you can indeed
connect to the server using this port.

Finally, you should check the configuration on the remote server,
especially the readdressing of the ports through the route: does the
router know that incoming connection on ports 1433 (and 1434?) must go
to right machine (the one hosting the SQL-Server)? For most
router/modem where you can connect more than a single machine, this
configuration must usually be done even when there is a single machine
connected to the router.

comma instead of colon? Interesting.

removing the http worked. See my reply to Aaron.

thanks
.

Relevant Pages

  • Re: Do I need to reinstall SBS2k3?
    ... conflicting with other things that want the same port. ... This is not a recommended security configuration. ... line "netsh dhcp server set dnscredentials" or via the DHCP ... Here is how I ran CEICW. ...
    (microsoft.public.windows.server.sbs)
  • Re: Cisco 501 Configuration help.
    ... :I am new to the CISCO IOS, need help configuring a 501 pix firewall. ... :On the lan segment I have 6 machines that need to connect to a server ... :service running on port 6666. ... in the second configuration, the PIX will PAT ...
    (comp.dcom.sys.cisco)
  • FC7 Samba
    ... I want to share a directory (see end of configuration file) called ... Samba has a huge number of configurable options (perhaps too ... server string = Samba Server Version %v ... # Log File let you specify where to put logs and how to split them up. ...
    (Fedora)
  • RE: Cant telnet port 25 from server but can from other client
    ... So that's why I don't think the firewall is turned on. ... network configuration in the CEICW has always failed from day one, ... Ethernet adapter Server Local Area Connection: ... telnet to it either on port 25 but it can ping it. ...
    (microsoft.public.windows.server.sbs)
  • Re: Protein folding (prion) home computer assistance
    ... priviliges and if port UDP port 8080 has to be opened to Internet ... I use an Eztrust firewall which is the same as ZoneAlarm. ... Your comment regarding configuration advice reminds me of advice that I ... and he was uncertain whether your pc was a server. ...
    (soc.retirement)
Quantcast