BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 09-23-2004, 09:14 AM   #1
pzkzm9
Knows Where the Search Button Is
 
Join Date: Sep 2004
Model: 8700
Carrier: Cingular
Posts: 16
Default Dedicated SQL 2000 SP3 box

Please Login to Remove!

I currently support several BlackBerry 3.6 sp3 servers that all run their own indivdual MSDE database. I am going to be migrating to a dedicated SQL 2000 box that will host a shared BESMgmt database for all of my BES servers.

RIM's documentation is pretty weak on the configuration and specific permissions needed on the database. I have created the database on the SQL server using the creatdb.exe utility "I was also logged onto the SQL box with the BES service account, which is part of the admintrators group on the SQL box".

My question is do I need to do any further permmisoning via the SQL MMC management snap in, or will the database have all the correct permissions required based on the fact that I was logged as the BES service account when I created the database.

Also ... do I need to increase the size of the database, it would appear that it created the database with a default size of 2.5 meg, only leaving me with another .6 meg of available space. What is the recommended size for the database. I will laos leverage this database when I migrate to BES 4.0, which I understand to use the database significantly more than 3.6.

Thanks
Offline  
Old 10-01-2004, 10:16 PM   #2
gsx95
New Member
 
Join Date: Sep 2004
Posts: 11
Default

the bes service account needs to be local admin on the box.
Offline  
Closed Thread



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Mainboard #CZ picture

1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Mainboard #CZ

$228.00



1PC USED A54MA55B BC186A413G52 Mitsubishi A500/F540 Series 55KW Drive Board #CZ picture

1PC USED A54MA55B BC186A413G52 Mitsubishi A500/F540 Series 55KW Drive Board #CZ

$317.00



Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP  picture

Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP

$649.99



NSK TiMAX NL95M/ A500/ A500L/ AK500L/ AS500L /AW500L CERAMIC BEARINGS  picture

NSK TiMAX NL95M/ A500/ A500L/ AK500L/ AS500L /AW500L CERAMIC BEARINGS

$80.75



1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Drive Main Board #CZ picture

1PC USED A54MA30B Mitsubishi F500/A500/A540 Series 30-37KW Drive Main Board #CZ

$255.00



Dentistry Replacement NSK TiMAX NL95M/ A500/ A500L/ AK500L/ AS500L /AW500L NEW picture

Dentistry Replacement NSK TiMAX NL95M/ A500/ A500L/ AK500L/ AS500L /AW500L NEW

$79.95







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