[fjoerdman]

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]

Moved to the proper section.

[noname]

Re-run the setup.exe.

[fjoerdman]

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]

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]

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]

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]

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]

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]

I just checked the time on the W2k8 R2 DC, the BES System and the Sql2008 Server - every system got the same time.

[nobody7290]

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]

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]

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.