up vote 1 down vote favorite
share [g+] share [fb]

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

link|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
1  
Are you connected to the SQL server as sa? – joeqwerty Jun 13 '11 at 14:02
feedback

2 Answers

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

link|improve this answer
feedback
up vote 1 down vote

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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