Setup SQL Server Schema

After you’ve installed Microsoft SQL Server 2012 and created a database schema, you still need to setup or configure the database schema. That means you must grant permissions to a user to work in the database schema, otherwise you get the following type of error message.

You receive an error message when trying to create a table in a database schema that hasn’t been assigned a user or role. This typically occurs after you create a new database schema, which has a owner. The following example occurs when you try to create a table in a studentdb database schema.