BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/index.php)
-   BES Admin Corner (http://www.blackberryforums.com/forumdisplay.php?f=21)
-   -   Changing configuration Database in BES5 Express (http://www.blackberryforums.com/showthread.php?t=243856)

fjoerdman 01-21-2011 03:56 PM

Changing configuration Database in BES5 Express
 
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

Dubdub 01-21-2011 04:58 PM

Re: Changing configuration Database in BES5 Express
 
Moved to the proper section.

noname 01-22-2011 12:58 AM

Re: Changing configuration Database in BES5 Express
 
Re-run the setup.exe.

fjoerdman 01-27-2011 07:33 AM

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

freakinvibe 01-27-2011 12:27 PM

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?

fjoerdman 01-29-2011 12:27 PM

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

nobody7290 01-29-2011 03:47 PM

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."

fjoerdman 01-30-2011 06:03 AM

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

nobody7290 01-30-2011 06:14 AM

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

fjoerdman 01-30-2011 07:20 AM

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.

nobody7290 01-30-2011 07:26 AM

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 ?

fadmin 01-31-2011 08:59 AM

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.

pauuu 01-31-2011 11:35 AM

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.


All times are GMT -5. The time now is 07:51 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.