Re: Connect to Client SQL
From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 12/12/03
- Next message: Mark A. Sam: "SQL Server Activity"
- Previous message: Kevin Wan: "Cannot use TCP of SQL Server Client."
- In reply to: Andrew Prior: "Connect to Client SQL"
- Next in thread: Andrew Prior: "Re: Connect to Client SQL"
- Reply: Andrew Prior: "Re: Connect to Client SQL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 11 Dec 2003 20:57:26 -0800
If it's a default instance, listening on the default port, yes it should
work. Are you sure name resolution is working? In other words, you might
try to connect to his IP Address, i.e. "131.107.x.x,1433" as the
servername...
-- Richard Waymire, MCSE, MCDBA This posting is provided "AS IS" with no warranties, and confers no rights. "Andrew Prior" <andrew@not-accede.com.au> wrote in message news:u1QOcCFwDHA.1760@TK2MSFTNGP10.phx.gbl... > We happily connect to a couple of SQL databases on ISP servers using our > Enterprise Manager. We now have a client who wants us to connect to his > local SQL server in the same manner and I can't make it work. > > I have 1433 open all the way through the various firewalls etc. Is there > any other port concerned that I might have to open up on his router as I try > and come in? > > Many thanks > > Andrew > >
- Next message: Mark A. Sam: "SQL Server Activity"
- Previous message: Kevin Wan: "Cannot use TCP of SQL Server Client."
- In reply to: Andrew Prior: "Connect to Client SQL"
- Next in thread: Andrew Prior: "Re: Connect to Client SQL"
- Reply: Andrew Prior: "Re: Connect to Client SQL"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|