error-"not associated with a trusted ..."

From: James King (jking@iprimus.ca)
Date: 03/26/03 

From: "James King" <jking@iprimus.ca>
Date: Wed, 26 Mar 2003 13:16:03 -0800

Hi, I'm new to SQL Server. I have SQL Server 2000 running
on WinNT, and have set it up with SQL authentication. I
can connect fine locally, but I also want to be able to
connect remotely from my laptop (Win2000). On the laptop I
can see the SQL Server in Enterprise Manager(also set up
to use SQL authentication), but when I try to connect I
get the error:
"A connection could not be established to .... Reason:
Login failed for user jking. Not associated with a
trusted SQL Server connection."
What's wrong?
Thanks for your help.

Relevant Pages

  • Re: Connect to Desktop SQL Server 2000 from Pocket PC
    ... SSPI is in fact supported, but you have to provide user ID and password ... This might be useful if SQL authentication is disabled on a server. ... > Xref: cpmsftngxa10.phx.gbl ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... Are you sure SQL Server is set up to use both SQL Authentication and Windows ... "John Beschler" wrote in message ... > I don't think it's a problem with the IUSR account because ASP runs fine. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Windows Service Login Failed when accessing SQL.
    ... SQL Authentication should work since you specify the login ID and password ... connect to the SQL Server DB successfully. ... > Windows Service Login Failed when accessing SQL. ...
    (microsoft.public.dotnet.distributed_apps)
  • Problem Connecting to another SQL DB using SQL Security
    ... I am attempting to create a Data Source connection to a SQL Server DB using ... SQL Authentication so that I can create DataViews and cannot (I get "Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Linked Server Connection Problem
    ... Use SQL authentication to connect to the SQL server from the client, ... set the domain account used to start SQL Server to have permissions in the ... Establish a SPN for your domain account which will enable Kerberos ... Load the Active Directory Users and Computers MMC snap-in. ...
    (microsoft.public.sqlserver.connect)