Deploying a SQL Database to a Remote Hosting Enviroment
I have developed many sites locally in SQL Express edition and when it comes time to deploy to my hosting provider I run into difficulties. I found this blog by Scott Guthrie which explains the whole process and provides a tool to use for deployment which solved everything for me.
You still have to work on an account having permissions to perform the tasks on the database which your application requires but if you get the NT Authority Service blah blah blah error that's what it's talking about.
Click here for a link to Scott's blog post.

Reader Comments