Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to install yet another forum on my local machine, but I have the error

Failed to connect:

CREATE DATABASE permission denied in database 'master'. Cannot attach the file 'C:\inetpub\wwwroot\forum2\App_Data\Database.mdf' as database 'yaf'.

I really need to solve this problem as soon as possible

Thanks in Advance

share|improve this question
How are you trying to create the database? Is it through the forum's installer? – squillman Jun 13 '11 at 13:24
Are you connected to the SQL server as sa? – joeqwerty Jun 13 '11 at 14:02
up vote 0 down vote accepted

If I see the error message, it seems that you havent given the permission to the user. Please tick db_owner. Good luck

share|improve this answer

Your SQL Server login (or your Window login if Windows Authentication is used) has to be associated with dbcreator (or better, e.g. sysadmin) Server Role in order to perform CREATE DATABASE ... commands.

Members of the dbcreator fixed server role can create, alter, drop, and restore any database.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.