BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-02-2011, 09:46 PM   #1 (permalink)
Thumbs Must Hurt
 
mvalpreda's Avatar
 
Join Date: Apr 2006
Model: 9900
Carrier: TMobile
Posts: 77
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default Using BET to move BESX 4.1.4 to BESX 5.0.3

Please Login to Remove!

Doing an SBS 2003 to SBS 2011 migration and I'm working on moving BESX. I have downloaded and installed BET on the new server. When I try to configure the source database I get an error that BET could not open a connection to the source database. I am just using the built in SQL Express on both machines. Both machines are on the same AD domain

I think I need to allow remote connections for the source, but I'm not sure how. I'm also not 100% sure I am using the right database names. I see a service called "SQLAgent$BESMGMT" on the source server and "SQL Server (BLACKBERRY)" on the destination server.

When I put the SQL server as SOURCESERVER\BESMGMT and the database as BESMGMT using NT authentication for the besadmin user I get an error
A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL Server us configured to allow remote connections. (provider:named pipes provider, error:40-Could not open a connection to SQL server)

When I put the SQL server as DESTINATIONSERVER\BLACKBERRY and the database as BLACKBERRY using NT authentication for my besadmin user I get a login failed. I get the same thing for the domain admin and SQL authentication using the sa account.

What am I missing?

Last edited by mvalpreda : 06-02-2011 at 09:53 PM.
Offline  
Old 06-03-2011, 02:58 AM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

The source server name should be SOURCESERVER.
The destination server name should be DESTINATIONSERVER.

Don't add the database name to the server name.

Also check the Transporter compatibility matrix first:

Installation considerations - BlackBerry Enterprise Transporter - Installation and Administration Guide - BlackBerry Enterprise Server Resource Kit - 5.0.3
Offline  
Old 06-03-2011, 08:08 AM   #3 (permalink)
Thumbs Must Hurt
 
mvalpreda's Avatar
 
Join Date: Apr 2006
Model: 9900
Carrier: TMobile
Posts: 77
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

I have the free version of 4.1.4.12 on my source server. I have BESX 5.0.3 on my destination server. According to the matrix I am supported. I think I am missing a few steps on both machines. I can't make a connection to the source server and I get a password error on the destination server.
Offline  
Old 06-03-2011, 08:14 AM   #4 (permalink)
Thumbs Must Hurt
 
mvalpreda's Avatar
 
Join Date: Apr 2006
Model: 9900
Carrier: TMobile
Posts: 77
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

On the source server under BlackBerry Server Configuration I see the SQL Information showing
SOURCE
SQL Server: SOURCESERVER\BESMGMT
Database: BESMgmt
Authentication: Windows (Trusted)

DESTINATION
SQL Server: DESTINATIONSERVER\BLACKBERRY
Database: BESMgmt
Authentication: Windows (Trusted)
Offline  
Old 06-03-2011, 08:15 AM   #5 (permalink)
Thumbs Must Hurt
 
mvalpreda's Avatar
 
Join Date: Apr 2006
Model: 9900
Carrier: TMobile
Posts: 77
Post Thanks: 0
Thanked 2 Times in 2 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

I was able to get connected to the DESTINATION database. Now I need to get connected to the SOURCE! I really think there is something I need to do on the source server to allow connections in.

Last edited by mvalpreda : 06-03-2011 at 08:17 AM.
Offline  
Old 06-03-2011, 08:34 AM   #6 (permalink)
BlackBerry Extraordinaire
 
Join Date: Aug 2008
Location: Basel
Model: 9780
PIN: N/A
Carrier: Swisscom
Posts: 1,579
Post Thanks: 5
Thanked 119 Times in 116 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

Please look at those docs on how to enable remote access to MSDE and SQL Express:

How to enable remote access to MSDE durdle.com

How to Enable Remote Connections in SQL Express | eHow.com
Offline  
Old 06-03-2011, 09:50 AM   #7 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Passp
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,757
Post Thanks: 274
Thanked 296 Times in 280 Posts
Default Re: Using BET to move BESX 4.1.4 to BESX 5.0.3

Quote:
Originally Posted by freakinvibe View Post
Please look at those docs on how to enable remote access to MSDE and SQL Express:

How to enable remote access to MSDE durdle.com

How to Enable Remote Connections in SQL Express | eHow.com

Agreed

I suggested that too here

Using BET to move BESX 4.1.4 to BESX 5.0.3 - BlackBerry Support Community Forums
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Passport, Z30, Z10 and Q10
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

Similar Threads for: Using BET to move BESX 4.1.4 to BESX 5.0.3
Thread Thread Starter Forum Replies Last Post
Move BPS 4.1.4 MSDE database to new server HDClown BES Admin Corner 3 05-12-2009 04:50 PM
Verizon to launch Blackberry Cyclone World Phone trevor1189 Rumor Mill 112 05-10-2007 09:14 PM
8703e guide techman1 BlackBerry Guides 3 09-28-2006 09:24 AM
8703e guide and all other series of bb techman1 BlackBerry Guides 1 09-21-2006 09:12 PM





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