BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-26-2007, 06: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, 07: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, 10: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, 09: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





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