BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 10-26-2007, 05:35 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Oct 2007
Model: 7100T
PIN: N/A
Carrier: Blackberry
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Important and Urgent - Access level to upgrade Config db

Please Login to Remove!

We are going to upgrade our blackberry server. SQL is in remote location and what login credentials is needed to upgrade the config db which is in remote location.

SQL server authentication is happening based on the sql username and password not with windows login id.

In simple, I would be logging into blackberry server using that particular system's local administrative account to upgrade the blackberry server.

When the SQL configuration page comes during the upgrade process i will be providing the sqlserver username/password. Will that id be having necessary access to update the config db in sql server which is in remote location.

Or

The blackberry server admin userid should have "Serveradmin" role in SQL server.
Or

The SQL Username should have "Serveradmin" role in SQL server.

Please someone explain this.


Regards
Offline  
Old 10-26-2007, 06:41 AM   #2 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Normally the upgrade program will use the existing SQL credential to upgrade the database. If you want to use a different credential you will have to change it using BlackBerry Server Configuration tool.

The easiest method would be to give the existing account Server Admin access on the SQL server, perform the upgrade, then remove the access.
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 10-26-2007, 09:36 AM   #3 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

What version are you upgrading from and to what version? Will you be using MDS Services?
Offline  
Old 10-26-2007, 08:41 PM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Oct 2007
Model: 7100T
PIN: N/A
Carrier: Blackberry
Posts: 15
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We are upgrading from 4.0.6 to 4.1.4. We are using only SQL

Regards
TK
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

OEM Dell Dimension E310 E3100 Motherboard Intel P4 2.8GHz 1G Ram
$21.78
OEM Dell Dimension E310 E3100 Motherboard Intel P4 2.8GHz 1G Ram pictureDell CW796 Cover Top 1720 OEM Genuine NIB OEM
$39.95
Dell CW796 Cover Top 1720 OEM Genuine NIB OEM  pictureDELL 725-10263 / 331-1310 / KT74N Lamp manufactured by DELL
$195.86
DELL 725-10263 / 331-1310 / KT74N Lamp manufactured by DELL pictureOEM Dell 0PH344 375W PSU N375P-00 NPS-375AB A Power Supply for Precision 380 390
$22.98
OEM Dell 0PH344 375W PSU N375P-00 NPS-375AB A Power Supply for Precision 380 390 pictureNew Dell Genuine OEM Cyan Toner Cartridge H625 H825 S2825 P3HJK
$75.98
New Dell Genuine OEM Cyan Toner Cartridge H625 H825 S2825 P3HJK  picture






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