Category Archives: Databases

SQL Server SSPI handshake failed with error code 0x8009030c

Ran into this issue during a new SP 2010 install this week:

“SQL Server SSPI handshake failed with error code 0x8009030c”

Took awhile to figure out but I was able to solve it by making a Local Security Policy change on the SQL box:

Go to Local policies | User rights assignment | Access this computer from the network and add the account(s) that are trying to login to SQL.

Credit to link for the info.

Database design – Primary Keys

This is an interesting article on the selection of a primary key during database design:

I’ve always wondered what the best primary key was and while there are pros and cons for both natural and surrogate keys, it seems that surrogate keys are the way to go.

Switch to our mobile site