February 12, 2008 at 3:38 am
Hi,
I am trying to install sccm 2007 at the moment and it is comnplaining that it hasn't got sysadmin rights to SQL 2005.
Please can you tell me how I add users/services to the SYSADMIN role/permissions in SQL 2005?
Thanks for your time
Cheers
Jambo
February 15, 2008 at 1:18 am
This is how you do it SSMS. (SQL Server Management Studio)
1.Expand the security folder of the respecting server
2.Right click on the user and get properties
3.Select Server Roles from the left pane
4.Select sysadmin by clicking the check box
Susantha
February 15, 2008 at 1:32 am
Avoid providing sysadmin rights to non sqlserver applications !
Unless off course it is for a central configuration management system that
really needs to set sqlserver instance properties.
There are several other system roles you may want to look at.
Books online has the overview "fixed server roles"
Maybe the application only needs to have some local database rights ?
Swap security view to "least authorized" view ! You'll benefit in the long run.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2008 at 1:45 am
What is sccm 2007, and why does it need full, unrestricted access to your SQL Server?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2008 at 2:24 am
System Center Configuration Manager 2007?
K. Brian Kelley
@kbriankelley
February 18, 2010 at 2:15 am
As a word of caution I will warn you that we have explored SCCM where I work and for the resons of it using full sys admin and the fact the load it places on the writes to the server is very high we have dedicated a server just for this. It is very resource hungry.
Unfortunately being a brilliant product from microsoft that it is the installer checks that the account used has sa permissions and fails if it does not. you can do all the managment from with in the application, the idea being no dba is required to set up backups and maintenence.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply