Re: [Bes-admins] Bes database move to sql 2000
Ran another cfg and it worked, thanks Hdawg for all your support. One other
note: the bes management was not working until I changed under tools
options database changed the name to new sql server and the
Bes management started to work again.
Mike
From: bes-admins-boun...@dataoutages.com
[mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Callahan, Mike
Sent: Tuesday, June 08, 2010 12:27 PM
To: A list for BES Admin's to discuss issues,etc.
Subject: Re: [Bes-admins] Bes database move to sql 2000
Getting this error running the cfg – any suggestions from here?
2] (06/08 12:21:20.774):{0x1D30} COM Error 0x80040E4D in
ConnectionItem::ConnectToDB() - Login failed for user 'sa'. - IDispatch
error #3149 (connection string -
Provider=SQLOLEDB;Server=CORP-SQL-01;Database=BESMgmt;uid=besadmin;pwd=)
[2] (06/08 12:21:20.774):{0x1D30} ConnectionPool::InitializePool: Failed
to create connection
[2] (06/08 12:21:20.774):{0x1D30} [CBESDBInstaller::Connect] : Pool
failed to initialize
From: bes-admins-boun...@dataoutages.com
[mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg
Sent: Friday, June 04, 2010 9:12 AM
To: bes-admins@dataoutages.com
Subject: Re: [Bes-admins] Bes database move to sql 2000
Delete the besmgmt database
Run the created statement again (leaving besmgmt.cfg as the default … or
change the database name if yours is not BESMgmt … don’t change anything
else in there)
Restore your database on top of the newly created one with created
Restart dispatcher service.
Or … the transaction log is full … is it?
Please don’t email me directly but rather the list so everyone can see the
problems / success.
From: Callahan, Mike [mailto:mcalla...@servicepointusa.com]
Sent: Friday, June 04, 2010 9:02 AM
To: hd...@port3101.org
Subject: RE: [Bes-admins] Bes database move to sql 2000
Hello , we did everything by the book. As far as instructions goes, changing
the database to new sql server, but the only service that would not start up
is the BB dispatcher,
and the new sql server name did not change in the blackberry manager. Our
exchange server is hosted in Canada and we use mapi services to sync email,
not sure is this has
anything to do with it but figured I would let you know.
We received this eror The BlackBerry Dispatcher service terminated with
service-specific error 5608. We did the following resolution but did not
fix the error, wondering if any one has any other possible solutions.
Environment
* BlackBerry® Enterprise Server software version 4.0 and 4.1
Problem
When trying to start the BlackBerry Dispatcher, after moving the BlackBerry
Configuration Database to a remote Microsoft® SQL Server™, you receive error
code 5608.
Cause
This issue may be caused by one of the following:
1. The Microsoft SQL Server does not have the error codes in the master
table database for the BlackBerry Dispatcher service to start.
2. The BlackBerry Configuration Database transaction logs are full.
Resolution
Complete the appropriate resolution.
Cause 1
The Microsoft SQL Server does not have the error codes in the master table
database for the BlackBerry Dispatcher service to start .
Resolution
1. Extract the service pack for the BlackBerry Enterprise Server
software version that you are using to a folder location.
2. Copy the Database folder from the extracted folder location to the
remote Microsoft SQL Server.
3. Open the BESMgmt.cfg file in a text editing application (e.g.
Microsoft Notepad).
4. Type cmd=Migrate.
5. Make sure the Microsoft SQL Server and BlackBerry Configuration
Database names are correct.
6. Save and close the BESMgmt.cfg file.
7. Open a command prompt and navigate to the database folder.
8. From the command prompt, type createdb besmgmt.cfg.
9. Confirm the account with which you are logged into the Microsoft SQL
Server has access to the BlackBerry Configuration Database.
10. Start the BlackBerry Dispatcher service.
Cause 2
The BlackBerry Configuration Database transaction logs are full.
Resolution
Back up the transaction logs on the database server for the BlackBerry
Configuration Database.
From: bes-admins-boun...@dataoutages.com
[mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg
Sent: Tuesday, May 25, 2010 12:43 PM
To: bes-admins@dataoutages.com
Subject: Re: [Bes-admins] Bes database move to sql 2000
Review
http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msd
e-database-microsoft-sql-server-database.html
and
http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-bl
ackberry-mdss-databases-new-microsoft-sql-server.html
it isn’t as simple as just a backup and restore.
_
From: bes-admins-boun...@dataoutages.com
bes-admins-boun...@dataoutages.com
To: bes-admins@dataoutages.com bes-admins@dataoutages.com
Sent: Mon May 24 15:29:20 2010
Subject
Re: [Bes-admins] Bes database move to sql 2000
Review http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msde-database-microsoft-sql-server-database.html and http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-blackberry-mdss-databases-new-microsoft-sql-server.html it isn’t as simple as just a backup and restore. _ From: bes-admins-boun...@dataoutages.com bes-admins-boun...@dataoutages.com To: bes-admins@dataoutages.com bes-admins@dataoutages.com Sent: Mon May 24 15:29:20 2010 Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
Re: [Bes-admins] Bes database move to sql 2000
That is exactly what I was looking for, thank you for sending me the links. Mike From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg Sent: Tuesday, May 25, 2010 12:43 PM To: bes-admins@dataoutages.com Subject: Re: [Bes-admins] Bes database move to sql 2000 Review http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msd e-database-microsoft-sql-server-database.html and http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-bl ackberry-mdss-databases-new-microsoft-sql-server.html it isn’t as simple as just a backup and restore. _ From: bes-admins-boun...@dataoutages.com bes-admins-boun...@dataoutages.com To: bes-admins@dataoutages.com bes-admins@dataoutages.com Sent: Mon May 24 15:29:20 2010 Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
Re: [Bes-admins] Bes database move to sql 2000
This article is How to move from a Microsoft SQL Server Desktop Engine (MSDE) database to a Microsoft SQL Server database I am moving a Microsoft sql to Microsoft sql. So doing a restore of the database and mdss database and then changing the sql server name on the configuration tab wizard will not work ? From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg Sent: Tuesday, May 25, 2010 12:43 PM To: bes-admins@dataoutages.com Subject: Re: [Bes-admins] Bes database move to sql 2000 Review http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msd e-database-microsoft-sql-server-database.html and http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-bl ackberry-mdss-databases-new-microsoft-sql-server.html it isn’t as simple as just a backup and restore. _ From: bes-admins-boun...@dataoutages.com bes-admins-boun...@dataoutages.com To: bes-admins@dataoutages.com bes-admins@dataoutages.com Sent: Mon May 24 15:29:20 2010 Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
Re: [Bes-admins] Bes database move to sql 2000
Very much the same process … http://www.port3101.org/featured-blackberry-kb-articles/133-kb03112-how-move-besmgmt-database-new-sql-server-instance.html http://blog.port3101.org/hdawg http://blog.port3101.org/hdawg From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Callahan, Mike Sent: Tuesday, May 25, 2010 4:29 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Bes database move to sql 2000 This article is How to move from a Microsoft SQL Server Desktop Engine (MSDE) database to a Microsoft SQL Server database I am moving a Microsoft sql to Microsoft sql. So doing a restore of the database and mdss database and then changing the sql server name on the configuration tab wizard will not work ? From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg Sent: Tuesday, May 25, 2010 12:43 PM To: bes-admins@dataoutages.com Subject: Re: [Bes-admins] Bes database move to sql 2000 Review http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msde-database-microsoft-sql-server-database.html and http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-blackberry-mdss-databases-new-microsoft-sql-server.html it isn’t as simple as just a backup and restore. _ From: bes-admins-boun...@dataoutages.com bes-admins-boun...@dataoutages.com To: bes-admins@dataoutages.com bes-admins@dataoutages.com Sent: Mon May 24 15:29:20 2010 Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
Re: [Bes-admins] Bes database move to sql 2000
Great thanks again - Mike From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg Sent: Tuesday, May 25, 2010 5:00 PM To: A list for BES Admin's to discuss issues,etc. Subject: Re: [Bes-admins] Bes database move to sql 2000 Very much the same process … http://www.port3101.org/featured-blackberry-kb-articles/133-kb03112-how-move -besmgmt-database-new-sql-server-instance.html http://blog.port3101.org/hdawg From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Callahan, Mike Sent: Tuesday, May 25, 2010 4:29 PM To: A list for BES Admin's to discuss issues, etc. Subject: Re: [Bes-admins] Bes database move to sql 2000 This article is How to move from a Microsoft SQL Server Desktop Engine (MSDE) database to a Microsoft SQL Server database I am moving a Microsoft sql to Microsoft sql. So doing a restore of the database and mdss database and then changing the sql server name on the configuration tab wizard will not work ? From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of hdawg Sent: Tuesday, May 25, 2010 12:43 PM To: bes-admins@dataoutages.com Subject: Re: [Bes-admins] Bes database move to sql 2000 Review http://www.port3101.org/featured-blackberry-kb-articles/902-kb12247-move-msd e-database-microsoft-sql-server-database.html and http://www.port3101.org/featured-blackberry-kb-articles/1425-kb12714-move-bl ackberry-mdss-databases-new-microsoft-sql-server.html it isn’t as simple as just a backup and restore. _ From: bes-admins-boun...@dataoutages.com bes-admins-boun...@dataoutages.com To: bes-admins@dataoutages.com bes-admins@dataoutages.com Sent: Mon May 24 15:29:20 2010 Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
Re: [Bes-admins] Bes database move to sql 2000
Pretty much that is the procedure, but you also need to make sure that account mapping on the new server is done properly. From: bes-admins-boun...@dataoutages.com [mailto:bes-admins-boun...@dataoutages.com] On Behalf Of Callahan, Mike Sent: Monday, May 24, 2010 3:29 PM To: bes-admins@dataoutages.com Subject: [Bes-admins] Bes database move to sql 2000 Hello All, Moving the bes data base to a new Sql server. Going to keep the current sql data base in place for a contingency plan. Ran a restore from backup server of the besmgmt and mdss database to the new Sql 2000. Have the Blackberry manager and Blackberry configuration running on a different server. So when ready I select change database on the blackberry server configuration panel ? Then follow wizard prompts ? Thank you, Michael Callahan Telecommunications Phone - (781)-935-6020 x599 Fax - (781)-207-8013 Email - mcalla...@servicepointusa.com Service Point USA Document, Print, and Information Management www.servicepointusa.com P - Please consider the environment - do you really need to print this email? This communication is confidential and may contain privileged information intended solely for the named addressee. It may not be used or disclosed except for the purpose for which it has been sent. If you are not the intended recipient, you may not copy or distribute this communication. Unless expressly stated, opinions in this message are those of the individual sender and not of Service Point USA. If you have received this communication in error, please notify Service Point USA by emailing postmas...@servicepointusa.com quoting the sender and delete the message and any attached documents. Service Point USA | 5 Commonwealth Ave Unit 5 | Woburn, MA 01801 | 781.935.6020 smime.p7s Description: S/MIME cryptographic signature ___ Bes-Admins mailing list Bes-Admins@dataoutages.com http://www.dataoutages.com/mailman/listinfo/bes-admins http://www.dataoutages.com http://www.dataoutagenews.com RSS Feed: http://feeds.feedburner.com/Bes-admins - Bes-Admins mailing list is sponsored by Dataoutagenews.com. http://www.dataoutagenews.com
