From SharePoint Central Administration, attempting to create a new configuration database results in an error: "Error CREATE DATABASE permission denied in database 'master'. (Error code: 262)."
Solution:
* Start > Programs > Administrative Tools > IIS Manager > SharePoint Central Administration Web Site Properties > Home Directory Tab: Note the Application Pool Name (e.g. StsAdminAppPool).
* Start > Programs > Administrative Tools > IIS Manager > StsAdminAppPool Properties > Identity Tab: Set the user name and password to be the same as the database service account.
* Start > Run > IISRESET
YESSSSSSSSSSSSSSSS - YOU RULE!
ReplyDeleteRIGHT ON!!! THANKS!!!
ReplyDeleteWe tried the same in WSS2 environment. But unfortunately it didn't work. Basically, we had a content database - CD1 being used for Web APP1. Recently, we removed the CD1 and used CD2 in its place for Web App1.
ReplyDeleteBut, now we want to attach the Content DB - CD1 to a new web app created - WEb App2.
But, when we tried to "Extent & Create a content DB" & attach the content db - CD1 .. we are getting this above mentioned : "CREATe db PERMISSION denied in database 'MASTER' (Error Code: 262)
Any urgent help on this is greatly appreciated.
If you are getting the "CREATe db PERMISSION denied in database 'MASTER' (Error Code: 262)" check this:
ReplyDelete- Make sure there is a SQL Server login associated with the
- Make sure that service account has is at least in dbcreator and securityadmin SQL Server roles. Depending on your security requirements, you can elevate the role even higher to one of the other roles.
- If you still have issues with the MASTER, manually map that service accounts SQL login to have excplicit permissions on the MASTER.
Some times you have to elevate the permissions beyond what best practices say for security(e.g. elevate to sysadmin, serveradmin roles) to get something working, then gradually scale it back aftwards to identify exactly where it is falling apart.