More than a few clicks…

It’s common that you create a database on your local development machine. Afterwards, you move the database to a production server.

Well, I thought you could just backup the database with the SQL Management Studio from one machine and restore it to another. The Backup/Restore process wasn’t the problem. When I tried to logon with the associated User/Password account, that I created on both machines and which was owner of the development database, I didn’t have any permissions to my database.

continue reading…