Getting this error running the cfg – any suggestions from here?
20000] (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=)
[20000] (06/08 12:21:20.774):{0x1D30} ConnectionPool::InitializePool: Failed
to create connection
[20000] (06/08 12:21:20.774):{0x1D30} [CBESDBInstaller::Connect] : Pool
failed to initialize
From: [email protected]
[mailto:[email protected]] On Behalf Of hdawg
Sent: Friday, June 04, 2010 9:12 AM
To: [email protected]
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:[email protected]]
Sent: Friday, June 04, 2010 9:02 AM
To: [email protected]
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: [email protected]
[mailto:[email protected]] On Behalf Of hdawg
Sent: Tuesday, May 25, 2010 12:43 PM
To: [email protected]
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: [email protected]
<[email protected]>
To: [email protected] <[email protected]>
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 - [email protected]
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
[email protected] 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
[email protected]
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
