Why does my texture look fine in preview but not when rendered?
You are using a normal map texture only. You need 2 textures: the bump map, and the diffuse. The following image show the steps for setting up the two textures: