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: 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: [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