RE: DMZ to SQL Server 2nd instance connection issue

From: Steven Collier [MVP] (StevenCollierMVP_at_discussions.microsoft.com)
Date: 06/26/04 

Date: Sat, 26 Jun 2004 02:41:01 -0700

Bob, to connect to instances of SQL there are more ports required, 1434 from memory, you'll find info on this on TechNet if you search under SQL. 

-- 
Steven Collier
SharePoint Portal Server MVP
http://mvp.support.microsoft.com
"Bob Robert" wrote:
> I found some thing interesting. After opening all the ports, I could able to connect named instance even though named instance was using port 1434.
> 
> "Bob Robert" wrote:
> 
> > Any update from Guru's. I am still having problem
> > 
> > "Bob Robert" wrote:
> > 
> > > Hi,
> > > 
> > > We are implementing ShaprePoint Application. 
> > > SharePoint installation is completed and the server is in the DMZ (behind the firewall). Name it as SERVER1
> > > Also, we installed SQL Server database (SHAREPOINTSQL) on a server as second instance (we already had one database). Name it as SERVER2. 
> > > 
> > > I could connect SHAREPOINTSQL from any client within the domain (not from DMZ).
> > > When I try to connect same database from SERVER1 (in DMZ), I don't see SHAREPOINTSQL listing when I am in SQL Enterprise Manager. I was hoping to see two entries (one for default database as SERVER2 and second one as SERVER2\SHAREPOINTSQL). I could see default database and connection fine.
> > > 
> > > Do I need to do any special setup to connect from SERVER1 to SERVER2\SHAREPOINTSQL ?
> > > 
> > > Hope I explained clearly
> > > 
> > > Thanks

Relevant Pages

  • Re: Tcl cant access serial port
    ... running on ttyv* ports. ... > I think you should have a look also at the .lock device - any flags set ... > too (until you clear them on the lock device). ... bob prohaska ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Open Ports on Cisco Router
    ... bob bob wrote: ... > I have a Cisco 1720 router that showed telnet open ... > ports appear open when scanning at different times. ... > deny icmp any timestamp-request ...
    (Security-Basics)
  • Re: Blocking Ports
    ... Bob wrote: ... ports except 80. ... This is something you really need to do in your firewall/router. ... disregard the replies and advice from anyone you choose, ...
    (microsoft.public.windows.server.general)
  • Re: open command failing on serial port
    ... PCI card, the ports and irqs may be assigned dynamically at ... PCI slot the card is plugged into. ...
    (comp.unix.sco.misc)
  • Re: Fraud Number Null:
    ... SQL Logical Table are multidimensional ... I used premise and axiom synonymously as a statement ... If Bob is credible and wrong, ... BB has no credibility ...
    (comp.databases.theory)
Loading