Re: Newbie: SQL Server connection, help needed
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/13/05
- Next message: Peter Yang [MSFT]: "Re: Login failed for Server\Guest"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL 2000 with SQL 7 tools"
- In reply to: rick: "Newbie: SQL Server connection, help needed"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 13 Feb 2005 20:53:36 +0100
Hi
"Not associated with a trusted SQL Server connection" means that your
credentials passed do not match those with rights in the databases.
You need an NT Domain to use trusted security (except on the local machine).
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"rick" <rmsingh@rogers.com> wrote in message
news:eHqmDTdEFHA.392@TK2MSFTNGP14.phx.gbl...
> Needs some help, I recently recieved an evaluation copy of SQL Server2000
> and I have installed it on a WindowsXPsp2 machine. I have updated to SQL
> Server to
> service pack3 and installed .net as well. I am still having connection
> problems. I am
> trying to setup an ODBC connection from another XP and win2000 machines.
>
> Connection failed:
> SQLState: '28000'
> SQL Server Error 18452
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> 'rick'. Reason: Not associated with a trusted SQL Server connection.
>
> I have already checked for Windows Authentication being enabled on the
> server.
> Of course the ODBC connection works locally.
>
> 'preciate any help
> thanks
>
>
- Next message: Peter Yang [MSFT]: "Re: Login failed for Server\Guest"
- Previous message: Mike Epprecht \(SQL MVP\): "Re: SQL 2000 with SQL 7 tools"
- In reply to: rick: "Newbie: SQL Server connection, help needed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
