Re: Intermittent connection

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/08/04 

Date: Thu, 8 Jul 2004 18:37:33 +0530

HI,

If you have a Trust relation ship between both domains, then it should not
be a issue at all. 

--
Thanks
Hari
MCDBA
"Tay" <Tay@discussions.microsoft.com> wrote in message
news:90E8545E-343F-4061-8DA6-E5AACB0F385F@microsoft.com...
> Hi, Hari.
>
> I can ping the sql server machine from the client terminal. But the client
and host are in different domain. Is this the problem?
>
> Thanks.
> Tay
>
> "Hari Prasad" wrote:
>
> > Hi,
> >
> > Due the problem situation, can you run a ping comand to the SQL Server
> > machine (Ping <ipaddress of sql server>). If a request time out occurs
> > contact the "Network admin".
> >
> > THis type of errors will come only if there is a slow network.
> >
> >
> > --
> > Thanks
> > Hari
> > MCDBA
> >
> >
> > "Tay" <Tay@discussions.microsoft.com> wrote in message
> > news:FD12B805-602B-447F-BB0F-181E032CA39E@microsoft.com...
> > > I am running SQL2000 on windows2003. I often connect to the database
> > through the SQL Server Enterprise Manager on a client machine to
administer
> > it. The strange thing is sometimes I can connect to this database but
other
> > times cannot. THe error message is "SQL does not exist or not known to
be
> > running". I have checked the server status at the host terminal and it
is
> > running.
> > >
> > > Anyone knows what's the problem for such intermitent connection?
Network
> > prob? SQL registration at the client side? ODBC setting?
> > >
> > > Someone suggests that it may be because the host and the client are
> > sitting on different domain in the network. Is this true?
> >
> >
> >

Relevant Pages

  • RE: MS SQL & Msg 11, Level 16, State 1
    ... General Network Errors are one of the most difficult to troubleshoot, ... Connectivity problems can occur if a firewall times out a connection before ... the client and SQL are done with it. ... Is there very heavy load on the SQL server when this happens? ...
    (microsoft.public.sqlserver.connect)
  • Re: Problem with NetScreen Remote 7.0.3 over DSL connection when accessing SQL....
    ... The trick to this one is making the SQL server think the remote client ... At present the SQL server see's the public NATTed address of your DSL. ... >From Dialup VPN ... > the network it will take about 5-10 minutes just for the login screen ...
    (comp.security.firewalls)
  • RE: SQL and Bandwidth use
    ... Not an area I know much about but if it's not the network card then maybe ... The client has to receive a buffer then tell the ... While monitoring total bandwidth on segment via ... > takes a very long time to transmit the data from the SQL server, ...
    (microsoft.public.sqlserver.server)
  • Re: dts quick to access 97 but slow to access 2003
    ... file is on the sql server or the client computer then its fine. ... is on any other machine on the network then it slows to a crawl. ... > in that time and it's only creating a 50Mb database. ...
    (microsoft.public.sqlserver.dts)
  • Re: high networkio in waitstats
    ... the SQL Server end or the client? ... The client plays a large role is how ... > have seen very high network waits on systems where the subscribers or the ... >> process the packets, especially when there is a VERY large TDS stream. ...
    (microsoft.public.sqlserver.server)
Loading