How to create a trusted connection

From: JimT (Jim_Taylor_at_ieee.org)
Date: 07/10/03 

Date: Thu, 10 Jul 2003 08:09:32 -0700

I have just installed SQL Server for the first time and
created a test database using a script I was given. I
have created a Windows login and an SQL login for the
person who originally created the data base and sent it to
me.

No matter what I do, or how I log in, the login code
crashes with the error message "Login failed for
user 'xxx'. Reason: Not associated with a trusted SQL
Server connection."

What is the secret to convincing SQL Server that the
connection is trusted.

I have searched the SQL Server 2000 Books On Line and
chased down many blind alleys. So far my conclusion is
that the books are useless. Of course, it's possible that
I don't know how to use the books, but then I would expect
the books to offer a little more help in that regard, too.

Thanx for your help.

JimT

Relevant Pages

  • RE: How to create a trusted connection
    ... You need to grant access for the Windows login by referring to the books ... is set to use Windows authentication to be able to do trusted connection. ... There are two modes of authentication in SQL Server: ...
    (microsoft.public.sqlserver.security)
  • RE: How to create a trusted connection
    ... What do you mean by "creating a Windows login"? ... To login SQL Server 2000 using trusted connection, grant the Windows ... Group" in SQL Server Books Online to get the concept, ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)