I hate databases!

time to read 1 min | 172 words

[Rant]

I hate them because they are complicate beast that make me work too hard to get what I want from them. The current frustration is Sql Server Express, which is probably a good DB, but I just can get it to work!

The main problem is that I want to allow access for the asp.net account, but it just won't work! Express Manager shows no way to do it, and for some reason, SQL Server Computer Manager throws the following message:

Snap-in failed to initialize.
    Name:SQL Computer Manager
    CLSID:{6BB32802-92E6-11D2-9967-0080C7DCB3DC}

I can log in via osql.exe if I'm admin, but I don't know how to allow an account to log in. I think it's something on the lines of sp_allow(), but it's just stupid that I've to get to this level to make something so simple work!

[/Rant]