Newbie: SQL Server connection, help needed

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
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
>