SQL Server Express CREATE DATABASE permission denied in database 'master'.

Question

After I change the option as UserInstance="False", then the error starts to happen.

Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to make it work again?

I'm running Application Pool as Network Service with full control.

Answer 1

What login are you connecting to SQL Server as? You need to connect with a login that has sufficient privileges to create a database. Network Service is probably not good enough, unless you go into SQL Server and add them as a login with sufficient rights.

Answer 2

A solution is presented here not exactly for your problem but exactly for the given error.

1. Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Surface Area Configuration

2. Add New Administrator

3. Select 'Member of SQL Server SysAdmin role on SQLEXPRESS' and add it to right box.

4. Click Ok.