|
|
01-21-2011, 03:56 PM
|
#1
|
New Member
Join Date: Jun 2006
Model: 8700
Carrier: Vodafone
Posts: 7
|
Changing configuration Database in BES5 Express
Please Login to Remove!
Hi Folks,
we have got a BES5 Express MR1 Blackberry Server and i have to change the configuration Database to our new SQL2008 Database Server. Actually the BES Database is located on a SQL2005 Server.
The Problem is, it is not possible to change the configuration database in the database configuration application on the BES Server. Does anyone know how i can change the Database?
Thanks a lot for your help.
regards, Jens
|
Offline
|
|
01-21-2011, 04:58 PM
|
#2
|
Appleinator
Join Date: Nov 2005
Location: New Hampshire
Model: App6+
OS: AJBR549
PIN: Ask
Carrier: ATT & Verizon
Posts: 20,038
|
Re: Changing configuration Database in BES5 Express
Moved to the proper section.
|
Offline
|
|
01-22-2011, 12:58 AM
|
#3
|
BlackBerry Extraordinaire
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
|
Re: Changing configuration Database in BES5 Express
Re-run the setup.exe.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
|
Offline
|
|
01-27-2011, 07:33 AM
|
#4
|
New Member
Join Date: Jun 2006
Model: 8700
Carrier: Vodafone
Posts: 7
|
Re: Changing configuration Database in BES5 Express
Hi,
thanks for your help, but it is not possible to connect to the SQL2008 Server. The Installation wizard refers to the installation log:
25137] (01/27 07:48:58.459):{0xCE0} {ConnectionItem::ConnectToDB} Failed to connect. Connection string is Provider=SQLOLEDB.1;Server=SQL1\SQLSERVER;Database =BES5Mgmt;Network=dbmssocn;Trusted_Connection=Yes
[25000] (01/27 07:48:58.459):{0xCE0} ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unbekannter Fehler - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot open database "BES5Mgmt" requested by the login. The login failed." - Command "ConnectionItem::ConnectToDB"
[25105] (01/27 07:48:58.459):{0xCE0} Failed to authenticate connection - local machine time may be out of sync with domain controller time. Please restart Windows Time Service.
[20000] (01/27 07:48:58.474):{0xCE0} ConnectDB: Cannot open database "BES5Mgmt" requested by the login. The login failed.0x80004005 NativeError=4060.
Has someboday any hint to solve this Problem?
regards, Jens
|
Offline
|
|
01-27-2011, 12:27 PM
|
#5
|
BlackBerry Extraordinaire
Join Date: Aug 2008
Location: Basel
Model: Class
PIN: N/A
Carrier: Swisscom
Posts: 1,616
|
Re: Changing configuration Database in BES5 Express
Something is wrong with your connection to the SQL2008 server. Check for ports and protocols on the SQL server. Also does your BES service user have enough rights to the SQL2008 server?
|
Offline
|
|
01-29-2011, 12:27 PM
|
#6
|
New Member
Join Date: Jun 2006
Model: 8700
Carrier: Vodafone
Posts: 7
|
Re: Changing configuration Database in BES5 Express
Hi,
thanks for your support. the BESAdmin User has got the following server roles on the Sql 2008 Server, dbcreator, public and serveradmin
Also is named pipes and TCP/IP enabled on the sql configuration.
this is very wired, thank you so much for your help, folks.
regards,fjoerdman
|
Offline
|
|
01-29-2011, 03:47 PM
|
#7
|
BlackBerry Extraordinaire
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,381
|
Re: Changing configuration Database in BES5 Express
you have checked the possible problem with the time sychronisation ?
"[25105] (01/27 07:48:58.459):{0xCE0} Failed to authenticate connection - local machine time may be out of sync with domain controller time. Please restart Windows Time Service."
|
Offline
|
|
01-30-2011, 06:03 AM
|
#8
|
New Member
Join Date: Jun 2006
Model: 8700
Carrier: Vodafone
Posts: 7
|
Re: Changing configuration Database in BES5 Express
yes, the time is in sync, i ran the following .reg file to be sure:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\W32Time\Parameters]
"Type"="NTP"
"NtpServer"="0.de.pool.ntp.org,0x1 1.de.pool.ntp.org,0x1 2.de.pool.ntp.org,0x1 3.de.pool.ntp.org"
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\W32Time\Config]
"AnnounceFlags"=dword:00000005
"MaxNegPhaseCorrection"=dword:00000e10
"MaxPosPhaseCorrection"=dword:00000e10
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\W32Time\TimeProviders\NtpServer]
"Enabled"=dword:00000001
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\W32Time\TimeProviders\NtpClient]
"SpecialPollInterval"=dword:00000384
Regards, fjoermdan
|
Offline
|
|
01-30-2011, 06:14 AM
|
#9
|
BlackBerry Extraordinaire
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,381
|
Re: Changing configuration Database in BES5 Express
I dont think, that this is the problem, but:
you should check the time not only on one machine.
check your domain controller(s) time, and the time of the BES and the time of the Server hosting the database.
Authentication Errors are Caused by Unsynchronized Clocks: Logon and Authentication
|
Offline
|
|
01-30-2011, 07:20 AM
|
#10
|
New Member
Join Date: Jun 2006
Model: 8700
Carrier: Vodafone
Posts: 7
|
Re: Changing configuration Database in BES5 Express
I just checked the time on the W2k8 R2 DC, the BES System and the Sql2008 Server - every system got the same time.
|
Offline
|
|
01-30-2011, 07:26 AM
|
#11
|
BlackBerry Extraordinaire
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,381
|
Re: Changing configuration Database in BES5 Express
Have your tried to install the SQL express management tools on the BES Server, and then try using these to make a connection to the database server ?
|
Offline
|
|
01-31-2011, 08:59 AM
|
#12
|
BlackBerry Extraordinaire
Join Date: Mar 2007
Model: Z10
OS: 10.1.0.19
Carrier: Fido
Posts: 1,068
|
Re: Changing configuration Database in BES5 Express
Firewall maybe?
If you don't use default instance (default port 1433) you need to make sure you type port when you created instance and db.
|
Offline
|
|
01-31-2011, 11:35 AM
|
#13
|
Knows Where the Search Button Is
Join Date: Apr 2005
Model: 7290
Carrier: vodafone
Posts: 22
|
Re: Changing configuration Database in BES5 Express
I would try telneting to the sql server on the port you are using.
i.e telnet "name of sql server" 1433
if you get a responce of "Could not open connection to the host, on port" then its likely that your having a firewall issue.
|
Offline
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
MSA Altair 10178557 4XR Multigas (LEL, O2, Co, H2S) Detector $475.00
MSA ALTAIR 4XR $600.00
MSA altair 4X multi gas meter Monitor detector, O2,H2S,CO,LEL Charger calibrated $340.00
MSA Altair 5X Gas Detector Meter *Recently Calibrated and 30 Day Warranty* $795.00
MSA 24 Month Altair Hydrogen Sulfide Gas Monitor/Detector (H2S) Activate By 5/23 $73.26
MSA altair 4X multi gas meter Monitor detector, O2,H2S,CO,LEL Charger calibrated $450.00
|
|