BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-08-2009, 09:32 AM   #1 (permalink)
New Member
 
Join Date: May 2009
Model: 9530
PIN: N/A
Carrier: VZW
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving Configuration DB to SQL

Please Login to Remove!

Hi all. Last night I tried moving our configuration db from the local BES server (single server install) to our remote SQL 2005 x64 server.

I followed the instructions on the following page.

w w w. blackberryforums.com /bes-admin-corner/10406-howto-migrate-msde2k-sql2k-database-new-server.html

(can't post links yet)

BES 4.1.6 on Server 2003 R2. SQL 2005 x64 is installed on Server 2003 x64.

The backup of my MSDE went fine. I copied the file over, created the new db from the BB Server Configuration, restored over the top of the db with my .BAK file and pointed the BES to the db on the SQL server. It connects, connection is fine, sees my SRP and all that and starts the services.

After that is where I expirienced problems. No users would update. I would let the BES sit, and none of my users would communicate with the server. Restarted services, the entire server, and both the server and the SQL server.

Once I pointed the BES back to the local MSDE instance, users would start connecting immediately.

I tried 3 different backups of the local MSDE, and imported into a few different times.

My BESAdmin account has dbcreator, public, sysadmin and serveradmin roles. BESAdmin is also a local admin on the sql server. I believe that to be correct, right?

Any help is appreciated.

Last edited by mdoyle : 05-08-2009 at 10:18 AM.
Offline  
Old 05-08-2009, 10:26 AM   #2 (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

Did ou open of the TCP/IP pipe on the remote SQL Server? Try accessing via a remote system manager.
Offline  
Old 05-08-2009, 10:32 AM   #3 (permalink)
New Member
 
Join Date: May 2009
Model: 9530
PIN: N/A
Carrier: VZW
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes TCP/IP pipe is enabled on the remote SQL Server. Been accessing it by System Manager remotely for months.
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.