Re: Connectivity to SQL Server 2000 in Different Domain using SQL Login Failing

From: Mike (tigger@poetic.com)
Date: 06/11/02 

From: tigger@poetic.com (Mike)
Date: 11 Jun 2002 06:14:11 -0700

Lourdes:
Good thought, but I failed to mention that I already have TCP/IP and
Named Pipes enabled...
Mike

"Lourdes" <lourdes@nomail.com> wrote in message news:<cf4f01c210c9$3747f9d0$b1e62ecf@tkmsftngxa04>...
> Check using Client Network Utility. You might need to
> enable TCP/IP aside from named pipes.
>
> >-----Original Message-----
> >Hello.
> >
> >I'm trying to connect to a remote office's SQL Server
> 2000 database.
> >I've had someone at the local office create a SQL Login
> as a SysAdmin
> >and he's logged into Query Analyzer using my SQL Login to
> verify that
> >it is working. However, when I VPN into the network, I
> can't connect.
> > The error I'm getting is "Login failed for user 'xyz'.
> Reason: Not
> >associated with a trusted SQL Server Connection". I am
> able to ping
> >by IP, ping by name, and I can run some software that
> shows me that
> >SQL Server is running on the correct port, etc. I just
> can't seem to
> >connect! I had the local office use query analyzer to
> make sure that
> >SQL was running in Mixed Mode (not Windows Only). If I
> can see the
> >computer, I can see the port, and know the user/pass,
> what else could
> >be causing me to not be able to login? Any ideas?
> >
> >Thanks.
> >Mike
> >.
> >

Relevant Pages

  • Re: Umstieg von Access auf SQL-Server
    ... > Bei Port 1433 sabber ich dann immer gleich Named Pipes. ... Nein, TCP/IP. ... How To Change SQL Server Default Network Library Without ... How To Set the SQL Server Network Library in an ADO Connection String ...
    (microsoft.public.de.vb.datenbank)
  • Re: I set: Local and remote connections/Using both TCP/IP and Named Pipes
    ... Using both TCP/IP and Named Pipes ... Go to configuration manager right click on SQL Server Express ... Local and remote connections/Using both TCP/IP and Named Pipes ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2008 vs 2005 performance issue
    ... Named Pipes is third in the order of network protocols. ... The SQL Server 2005 machine is using TCP/IP. ... The SQL Server 2008 machine is using Named Pipes. ... I installed SQL Server 2008 Enterprise Eval on my new Toshiba Centrino Duo ...
    (microsoft.public.sqlserver.setup)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... >> Ijust wanted to know how to configure the SQL Server to use Named Pipes ... In order to use TCP/IP protocols you need to ... > There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
  • Re: Connect to SQL Sererv thru Named Pipes
    ... to acced SQL Server via Named Pipes from VB 6. ... The DBMSSOCN tell the OLEDB driver to use TCP/IP instead of the default ... There are pros and cons as normal for which protocol to use however IMO ...
    (microsoft.public.vb.general.discussion)
Quantcast