Troubleshooting Hints

SQL Server is a complex and versatile program, and it would be foolish to think we could explain all of its intricacies in one chapter. However, the authors have noticed some common issues people run into when getting started. In this section we will attempt to give you some hints if you are having trouble connecting to or using your SQL server.

Understanding Login Options

As you may recallfrom Figure 20.12, when you connect to a database, you have the option of using integrated security or entering a user name and password defined in the database. Integrated security means that your Windows login account has the authority defined on the database server. For example, my Windows user id is bsiler so I could allow access ...

Get Special Edition Using Microsoft® Visual Basic® .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.