I have an account Randy with administrative rights. I am using MSDE, not a full-blown version. I have created databases and accessed using database in earlier chapters. Now, I get the error message:

Login failed for user 'Randy'. Reason: Not associated with a trusted SQL Server connection.

My quick search returned some fixes for the full-blown version, but not mine, unless I am missing something. I ended up dropping that database and re-creating a shell, but same error.

Randy,

Did you specify Mixed Mode authentication when you installed MSDE? Did you use the Randy login to access the other databases? Also check to ensure that the Randy login has been granted access to the database in question and that it has the rights to create tables, views, and stored procedures.

Thearon

I don't recall if I did or not. However, your point about Mixed Mode led me to this:

http://support.microsoft.com/default...n-us;325022#10

Fortunately, I did not have to uninstall and re-install MSDE, but only had to make a registry change.

By the way, fantastic book! I don't use that word often, but this book deserves it. I bought two copies -- one for work and one for home. :)