Share via

Why (dbcreator) SQL Rights are Required for MOSS 2007!

  • Article

 

Within a day of making a post on SQL rights, I was contacted by Chris Gideon of our support arm and he quickly pointed out some big reasons why you do NOT want to remove dbcreator, even after the databases are created. I will be modifying my SQL Rights post in addition to this new post to reflect this guidance. Thanks very much for this information Chris!!

 

  • It’s not supported to remove that right.
  • If you try to repartition your site collections into multiple content dbs this right is needed.
  • The right is there to ensure the objects in the DB are properly named. DBO. Etc.
  • Backup needs this right.
  • Service Packs often delete or drop the stored procedures from the database.
  • See a list of articles. These are SPS2003 and WSS v2 but they apply as well when it comes to SQL permissions.

823282 You receive an SQL access error message when you change the configuration database administrator account in SharePoint Portal Server 2003

https://support.microsoft.com/default.aspx?scid=kb;EN-US;823282

823287 You receive a "Cannot connect to the configuration database" error message when you connect to your Windows SharePoint Services Web site

https://support.microsoft.com/default.aspx?scid=kb;EN-US;823287

828815 You receive a "Database <Database_Name> already exists" error message when you manage your Windows SharePoint Services content database

https://support.microsoft.com/default.aspx?scid=kb;EN-US;828815

841216 "0x80040E14" or "HTTP 500" error message when you connect to your Windows SharePoint Services Web site after you install a Windows SharePoint Services service pack or a security update

https://support.microsoft.com/default.aspx?scid=kb;EN-US;841216

889646 "Error 18456" error message when you specify configuration database settings on the Set Configuration Database Server page of SharePoint Central Administration

https://support.microsoft.com/default.aspx?scid=kb;EN-US;889646

896148 You receive error messages when you try to use the Stsadm.exe command-line tool to perform certain administrative operations in Windows SharePoint Services

https://support.microsoft.com/default.aspx?scid=kb;EN-US;896148

906950 A backup operation is not successful when you use the SharePoint Portal Server Data Backup and Restore program to back up portal site content in SharePoint Portal Server 2003

https://support.microsoft.com/default.aspx?scid=kb;EN-US;906950

Comments

  • Anonymous
    January 17, 2007
    Are there any best practises for gradual upgrading when it comes to configuring the databases? During the upgrade proces at a customer I constantly get SQL Server timeouts, therefore I changed the recovery models for the temp databases to simple and sometimes even bulk-logged instead of full.

  • Anonymous
    January 18, 2007
    Rights for installation and operation are documented here: http://technet2.microsoft.com/Office/f/?en-us/library/89e4c579-5720-45e0-917e-abeb95266c3e1033.mspx

  • Anonymous
    January 19, 2007
    The comment has been removed

  • Anonymous
    January 19, 2007
    VIA Johnwe A great list of technet articles that describe how to manage SQL rights for MOSS 2007....