Hi, I just install SBS 2003 with SQL 2000 on my server, but when I try to
use another PC (OS is WinXP) connect the SQL server throgh ODBC, it pop up a
error msg:

connection failed
SQL state '28000'
SQL server Error: 18452
Login fail for user 'XXX', reason : Not associated with a trusted SQL server
connection.

Can you tell mm how should I do to fix this problem??

Thanks!

Danny

[quoted text, click to view]


Looks like:
(a) The SQL Server is configured to use Integrated Authentication
(b) The XP machine is not logged on with a domain account,
(c) or more likely, you've not configured the Domain Account in the SQL
Server to give it permissions to a specific database.

In case of (c), you need to create a LOGIN account in SQL Server for the
Domain Account being used on that XP PC, then you need to grant that LOGIN
account access to the desired database, by adding a USER account in that
database heirarchy.


--
Lawrence Garvin, M.S., MVP-Software Distribution
Everything you need for WSUS is at
http://technet2.microsoft.com/windowsserver/en/technologies/featured/wsus/default.mspx
And, eveything else is at
http://wsusinfo.onsitechsolutions.com
....