Issue
Andover97 would not create, but the database did create
Environment
Continuum
Windows Server 2008 R2
Windows SQL 2008 R2
Cause
Permissions were somehow restricting the Andover97 user from being created
Resolution
The dbo was set to sa as seen in Enterprise Management Studio under the database > Security > users
There may be a number of ways to correct this:
- Fix the reason why the dbo cannot be created and recreate the db.
- Run a query to change the dbowner
New Query> sp_changedbowner 'Andover97'