I'm relatively new to VB.NET and Database programming, so I don't know a WHOLE lot about both, but I've recently purchased Wrox's "Beginning Visual Basic .NET Databases" and I've run into a snag on page 48.

The text says to fill in the Login ID and Password ("sa" and blank), but when I do, it gives me the message:

Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

The book says to use "sa" and blank "unless you changed them earlier." But I can't find where the book says this is to be changed. Where do I set privileges for 'sa'? If I try to Use Trusted Connection I get an Overflow error.

I'm running the SQL Desktop Engine 2000. Anyone know how to help me?

Please!!! Help me!!!