"Sean" wrote:

>
> BrianMultiLanguage wrote:
> > Will the error is in the subject line.
> >
> > ust to be sure, you have some machines working and one particular machine
> > > (the laptop) is not working, right?
> > YES
> > Are you using Named Pipes or TCP-IP?
> > TCP-IP
> > Is
> > > the laptop using a trusted connection or SQL Server security mode?
> > trusted.
> > What was
> > > the exact text of the error message?
> > When user starts up database, they get:
> > Connection failed:
> > SQLState: '28000'
> > SQL Server Error: 18452
> > microsoft,odbc sql server driver, sql server, login failed for user '(null)'
> > Reason: not associated with a trusted SQL server connection.
> > What things have you tried that did not
> > > resolve the problem?
> > Make a new connnection.
> > Try pipes.
> > f/w on/off
> > Login as admin, works fine.
> > The other fixes i listed below.
> >
> > "Cindy Winegarden" wrote:
> >
> > > Hi Brian,
> > >
> > > Just to be sure, you have some machines working and one particular machine
> > > (the laptop) is not working, right? Are you using Named Pipes or TCP-IP? Is
> > > the laptop using a trusted connection or SQL Server security mode? What was
> > > the exact text of the error message? What things have you tried that did not
> > > resolve the problem?
> > >
> > > --
> > > Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> > > cindy_winegarden@msn.com www.cindywinegarden.com
> > >
> > >
> > > "BrianMultiLanguage" <BrianMultiLanguage@discussions.microsoft.com> wrote in
> > > message news:3D81F886-58B5-4C09-AA8A-1529B54CE72B@microsoft.com...
> > > > We changed from sql 7 to 2000, crissis mode.
> > > > One use with a laptop keeps getting the error when connecting to the sql
> > > > server.
> > > > SQL 2000 latest, mixed mode.
> > > > Laptop xp pro latest, mdac is latest.
> > > >
> > > > I looked up sql server 26000 and 18452. I was not able to resolve the
> > > > problem. Still an untrusted connection.
> > > >
> > > > I do know it is in the user profile but what?
> > >
> > >
> > >You should specify the to login otherwise it should not allow you to login in.
>