BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 04-02-2008, 04:32 AM   #1 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default Migration to new hardware

Please Login to Remove!

Brief history:

We installed a BES on a spare PC with a view to testing it all out, three users. To this end very little, if I remember correctly nothing, was changed from the install defaults, so the SQL is on the same box as the BES. The time has finally arrived to move it to a more permanent home and I want to run the plan of action past those more learned than myself here and see if I am missing anything important. I am trying to do this with as little impact on the end user as possible.
  1. Move the SQL database to a more permanent home on the file server, which is already running SQL Express 2005. Using the instructions here:

    http://www.blackberry.com/btsc/search.....

  2. Install BES on its new home with a spare SRP key I have.

  3. Use the Blackberry Manager to move users from one BES to the other.

  4. Decommission the old box.
It seems too easy when spelt out like that, what have i missed?
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 04-07-2008, 06:48 AM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

I am guessing by the lack of repsonse that my plan of attack is the right way to go.

Will give it a try this week and report back.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 04-08-2008, 08:04 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 you've specified is a phased migration approach. I prefer a knife edge where you cut everything over at once and you use the same license, but both work well.

Do whichever you're comfortable with. It is easy enough as long as you don't skip any steps.
Offline  
Old 04-21-2008, 07:44 AM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Finally got a chance to attempt this but have now walked into what I hope is the first and only issue.

After I move the SQL onto a central SQL Express 2005 box I am seeing the following on the Domino console:

Quote:
Unable to open BESMgmt database: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.0x80040E4D NativeError=18456
The BES Server Management Utility successfully logs into the remote SQL using SQL authentication. If it is relevant the SQL is being hosted on a Domain Controller but the BES is on a standalone server.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 04-21-2008, 07:54 AM   #5 (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

Quote:
Originally Posted by DavidAdams View Post
Finally got a chance to attempt this but have now walked into what I hope is the first and only issue.

After I move the SQL onto a central SQL Express 2005 box I am seeing the following on the Domino console:



The BES Server Management Utility successfully logs into the remote SQL using SQL authentication. If it is relevant the SQL is being hosted on a Domain Controller but the BES is on a standalone server.
Check these out ...

KB03543 - Unable to open BESMgmt database
Problem with BES connecting to SQL server
Offline  
Old 04-21-2008, 09:48 AM   #6 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

The instruction talk about the SQL Server Enterprise Manager, I am using SQL Express and dont have the options they are mentioning. Am downloading the full SQL install in the hope it contains the manager as well, unless there is another way. I have tried the regedit way mentioned to no avail.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 04-21-2008, 09:54 AM   #7 (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

Microsoft SQL Server Management Studio Express
Offline  
Old 04-21-2008, 09:57 AM   #8 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Thanks, that I have, just need to dig through it for the necessary bits. Will persevere and report back tomorrow.
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 04-24-2008, 06:39 AM   #9 (permalink)
Talking BlackBerry Encyclopedia
 
DavidAdams's Avatar
 
Join Date: Sep 2007
Location: Belfast
Model: NotYe
PIN: N/A
Carrier: O2
Posts: 470
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Looks like we are going to knife edge onto the new hardware and move the SQL express as well.

Are there any gotchas given that the new server has a different system name?

Also it is a different Domino server ID file, is this going to cause problems?
__________________
BES, 4.1.7, was SBE now full BES
Domino v7.0.2
Windows Server 2003, standalone
Offline  
Old 05-14-2008, 08:38 AM   #10 (permalink)
New Member
 
Join Date: May 2008
Model: 8120
PIN: N/A
Carrier: MTN
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi guys

Been battling with the problem all day. Found the solution on blackberry support.

2 x Server
1 with Microsoft SQL Server Running
1 with Lotus Domino 8.0 and BES Software on it

The support page highlighted the need to set the Startup Account for Domino to a domain account with privledges to the MSQL Box. By default it starts up under a local system account.

I set the startup account for Lotus Notes Domino Server to Domain\BESService (Account i created in AD) and made sure this account had dbo access to the BESMgmt database in SQL.

Sorted the issue out. Hope this helps.
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.