CREATE DATABASE permission denied in database 'master'.
I am attempting to create a new sharepoint web application using central administration running as local administrator. This computer is not in a domain. I have selected: "Create a new IIS Website" a default random port has automatically been assigned authentication provider is ntlm use ssl no Create a new application pool using the Network Service The database server is set to the machine name The database name is WSS_Content_<a bunch of random numbers> database authentication is windows authentication When I activate the "ok" button, the operation fails and I get the following error in the application event log: CREATE DATABASE permission denied in database 'master'. any help is appreciated
October 9th, 2009 6:54pm

Hi,You have to give the right permission in SQL Server to the account of central admin's application pool.If the account of the application pool is "NT AUTHORITY\NETWORK SERVICE", it should have the following role in SQL : dbcreator and securityadminTake a look at this article for more information : http://technet.microsoft.com/en-us/library/cc721638.aspxHope that help,MarioMy blog (en franais) : http://spcontext.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
October 9th, 2009 7:43pm

hello, am having the same error but when executing commands from powershell, do i have to make the same solution, or should i give the user am accessing the server with the required permission? do i give central admin account the permission or my user?
September 20th, 2012 10:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics