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,173
Post Thanks: 361
Thanked 369 Times in 342 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  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

14 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9507 103617
$21.99
14 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9507 103617 pictureCypress CY7C293AL Memory IC
$3.82
Cypress CY7C293AL Memory IC  pictureMotorola rechargable memory backup battery XTS5000 XTS2500 6003710K08 6071520M01
$5.99
Motorola rechargable memory backup battery XTS5000 XTS2500 6003710K08 6071520M01 picture4 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9432 116719
$7.99
4 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9432 116719 picture3 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9525-112976
$6.99
3 CYPRESS IC Chip DIP 28 Asynchronous SRAM Memory CY7C432-65PC 9525-112976 picture






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