Newbie questions about 'trusted connections'

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: B. Chernick (BChernick_at_discussions.microsoft.com)
Date: 10/03/04 

Date: Sun, 3 Oct 2004 11:29:01 -0700

I'm trying to do chapter 10 in the 70-228 book and I'm totally confused. I'm
on Lesson 3, Chapter 10, Creating a login, and I keep getting msg 18452 (Not
associated with a trusted SQL Server connection) at step 19. I've looked at
every reference I have and this is just not making sense to me. First of
all, could someone please explain to me in their own words what a trusted
connection is and how do I create it?

(I should mention that I've installed SQL Server 2000 Developer over a
pre-existing MSDE2000 installation. This is all on one laptop, no network
currently connected. The original MSDE server is in Windows Authentication
mode. The new server, on which I'm trying to do the exercise, is in mixed
mode. I did stop and restart the server before trying to login as 'Joe'.)

Relevant Pages

  • Re: accessing data mining model via web/PDA
    ... Is your OPENROWSET clause connecting to a SQL Server 2000 database? ... Is your SQL Server instance running on the same machine as your Analysis ... i need some> help for the connection string, let say to access the> mining model in the AS. ...
    (microsoft.public.sqlserver.datamining)
  • Re: VB Express SQL Express Remote Connection
    ... Yes I can connect using the SQL Server Management Studio Express Tool. ... I changed my connection to exactly what you specified and it connected. ... I can connect and create databases on the Remote Server ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Direct connect with ActiveSync
    ... That won't work because you have a connection string that can't be correct. ... You're saying that the database is, but it's not; ... Server 2000, Visual Studio 2008. ... Again sorry if this should be in another form but you say that SQL Server ...
    (microsoft.public.sqlserver.ce)
  • .Net Scalability problem
    ... I finished a Great project using .Net and SQL Server and .Net Mobile ... Million concurrent users ... So I think that the MTC generate concurrent connection and per ...
    (microsoft.public.sqlserver.connect)
  • Re: Communication Link Failure Error
    ... On disconnection from the network, in my code I changed the connection ... string to use SQLOLEDB and sent a SQL query to SQL server which failed as ... unplug the network cable from the client machine and put the cable ...
    (microsoft.public.data.ado)