DB Creator and Security Admin rights in SQL.

Question

Hi,
As an administrator i installed SQL SERVER 2008 On my SharePoint development box .
When i am trying to create or extend new web application from central administration , i am getting access denied ,i googled for it and found that it is because of SQL permission issue (http://www.eggheadcafe.com/software/aspnet/33722821/help-cannot-create.aspx).I learned  that the account should have DBCreator and Security Admin rights in SQL.

When i am trying to assign the server roles(DBCreater, Security Admin) to my account , i am getting a prompt  as shown below .


TITLE: Microsoft SQL Server Management Studio
------------------------------

Add member failed for ServerRole 'dbcreator'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+member+ServerRole&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=15247&LinkId=20476

please , assist me how to assign server roles(DBCreater, Security Admin) to my account.

Thank you,
Deepak.

Answer 1

Make sure the account with which you are trying to add new roles are sysadmin accounts at the SQL server 2008.
Login to your SQL server manually and try adding your account under sysadmin role or dbcreator and securityadmin - you may do this with sa account or anyother sysadmin account.

---

Thanks, Leks

Answer 2

sysadmin is excessive. What you need is set it up as securityadmin and dbcreator role and obviously need to be setup as a sql service login on the Server instance.

---

Joseph Saad - SharePoint 2010 MCITP, MCSE, CCIE RS 20243