BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-08-2008, 02:44 PM   #1 (permalink)
New Member
 
Join Date: Aug 2008
Model: 8310
PIN: N/A
Carrier: AT&T
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SERVERADMIN role on SQL Server?

Please Login to Remove!

We're a 'not quite huge' company that is too large to use MSDE for the BES database, but not big enough to warrant a dedicated SQL Server for the BES server. So we're putting a our new BES server DB on a remote SQL 2005 server that is shared by other applications.

One of the requirements is that the service account accessing the SQL server has the serveradmin role (not just for the install... ongoing as well). I get beat up every time we get audited that I have service accounts that have the serveradmin role.

Anybody know the impact of NOT giving the serveradmin role? What do I lose? And what do i break, if anything?
Offline  
Old 08-08-2008, 03:19 PM   #2 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: PRIV
OS: 5.1.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 7,209
Post Thanks: 369
Thanked 374 Times in 344 Posts
Default

So how many users do you have?
__________________
unlock your phone here http://freemyblackberry.com/
I am on http://supportforums.blackberry.com
BES 12 running sweet for my DTEK60
Offline  
Old 08-08-2008, 03:58 PM   #3 (permalink)
New Member
 
Join Date: Aug 2008
Model: 8310
PIN: N/A
Carrier: AT&T
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

120+ users
Offline  
Old 08-08-2008, 05:37 PM   #4 (permalink)
CrackBerry Addict
 
Join Date: Jan 2008
Model: 9700
PIN: N/A
Carrier: Rogers
Posts: 709
Post Thanks: 0
Thanked 8 Times in 8 Posts
Default

I use SQL2005 Express on the same machine as the BES - and it's on a Pentium III server with half those users and it keeps up quiet nicely.
Offline  




Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.