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


NEW FACTORY SEALED AB 1747-L541 SER B SLC 500 SLC 5/04 CPU PROCESSOR UNIT MODULE picture

NEW FACTORY SEALED AB 1747-L541 SER B SLC 500 SLC 5/04 CPU PROCESSOR UNIT MODULE

$311.33



New Factory Sealed AB 1747-L532 SER E SLC 500 5/03 CPU Processor Unit 1747L532 picture

New Factory Sealed AB 1747-L532 SER E SLC 500 5/03 CPU Processor Unit 1747L532

$320.76



OLYMPUS OTV-SI Digital Video Processor Camera Light Source WARRANTY REFURBISHED picture

OLYMPUS OTV-SI Digital Video Processor Camera Light Source WARRANTY REFURBISHED

$177.99



Performance Technologies VME64 picture

Performance Technologies VME64

$82.50



NEW Omron CQM1-CPU21 PLC Programmable Controller picture

NEW Omron CQM1-CPU21 PLC Programmable Controller

$143.48



New Factory Sealed Allen Bradley 1764-LRP SER C 1500 Processor PLC 1764LRP picture

New Factory Sealed Allen Bradley 1764-LRP SER C 1500 Processor PLC 1764LRP

$340.47







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