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

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

From: "James King" <jking@iprimus.ca>
Date: Thu, 27 Mar 2003 05:56:46 -0800

Yes, I stopped and started the SQL Server service. Maybe a
reboot would be needed?

Also, there is no choice in the dialog box for "both
Windows and SQL authentication". I can choose Windows,or
I can choose SQL Server. Is this a problem?

Thanks,

James

>-----Original Message-----
>It really sounds like your server is not running with
both Windows and SQL
>Auth. (sounds like Windows Only). Have you stopped and
restarted SQL Server
>after this change?
>
>hth,
>kt
>
>**** Please reply only on the newsgroups! Include
dml/ddl, when possible.
>Thanks ****
>Kimberly L. Tripp
>President, SYSolutions, Inc. www.SQLSkills.com
>Principal Mentor, Solid Quality Learning
www.SolidQualityLearning.com
>
>
>"James King" <jking@iprimus.ca> wrote in message
>news:4ddd01c2f3dc$e80d5de0$3301280a@phx.gbl...
>> 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: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • Re: SBS Client Connection Problem
    ... The application that is connecting to SQL server gives "object doesn't ... In Windows Explorer I get "an error ... What's the exact problem symptom of the problematic workstation cannot ... Click the Services tab, click to check the "Hide All Microsoft ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... Only creating Logins is not the complete solution of course, then you'll need to map those users to the appropriate databases and assign them roles and grant them permissons. ...
    (microsoft.public.sqlserver.clients)