MSDE and access
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
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
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