Having received no formal instruction on
VB programming, I have been using Thearon's excellent book in my retirement, with considerable success, to try to learn something about programming with databases. However, although I can understand enough to use MS Access, I am having a lot of difficulty understanding the MS SQL Server 2005 database. (On investigation, I find that I am still using the Express Edition!).
After many attempts, I thought I had finally got it sorted when I got to Chapter 10 and everything was working smoothly. However, in Chapter 11, I got as far as typing all the code to cope with Roles and Users and, as instructed, I entered a new Role - 'User' - with its Description - 'Time Tracker User' - and Ranking - '1' - and successfully added it to the database.
At this point I checked that it had indeed been added to the database by opening the Server Explorer window and examining the Roles Table. Everything appeared OK.
Then the problems started: -
Thereafter, I found that I could no longer access the database through the program, which had been set up to use SQL Server authentication. The strange thing is that when I use the same User ID and Password in SQL Server Management Studio Express, I have no problem accessing the database but the program still will not allow me to connect to the database.
I have checked that the program's connection string was decrypting the Registry entries correctly, and found that there was no corruption there.
I then tried connecting through the Server Explorer window using SQL Server authentication and it wouldn't work either.
I can't figure out where the problem might be but obviously it is associated with my lack of understanding of MS SQL Server rather than the Time Tracker program. It is driving me insane since I can't continue without solving it . Information which is within my limited understanding is difficult to come by so I hope someone can point me in the right direction again so that I can continue my belated education.