Hi,

i have MSDE 2000 installed on my machine and i want to
create a database using access xp.

However, when i create the database in access, the sql server
wizard appears (as it should). i enter the name oof the
server as '(local)', (i have tried the server name as
well). I then enter 'sa' as the user and leave the password
blank. Click next, and i get the following error

Connection failed:
SQL State 28000
SQL Server Error 18456
[microsoft]odbc sqlserver driver[sql server]login failed
for user 'sa' reason not associated with a trusted sql
server connection

Any help from anybody ?

PS. i was following 'beginning visual basic.net databases' chapter 2 (i guess i am not doing very well) - any recommends on books for simpletons to do with SQL server MSDE



Con...

Con, try using your windows logon ID. The error suggests to me that msde is using Windows authentification, and you're attempting to log in using a SQLServer id.

HTH

Chris