BlackBerry® Enterprise Solution

[davecason]

Hi,

I'm installing a new copy of BES on a server and it says it can't see the exsiting SQL 2005 that's installed on the server.

Any ideas ... the walk thru and the install guide don't address this.  I don't know much about SQL but the tool is called,

Microsoft SQL Server Management Studio Express.

Cheers'

Dave

[knottyrope]

Log into the SQL server and add account besadmin with dbcreator, server admin and sysadmin roles

create a DB called besmgmt

make besadmin owner of it

Log onto sql with besadmin account

Set up the data base with the createdb file(hopfully you copied the datbase folder from the install files to the sql server first)

Then when done have the BES connect to SQL and continue with the install.

[AndyDufresne]

If you've installed SQL 2005 Express edition, the sql server name is not simply SERVERNAME or LOCALHOST or IP ADDRESS, but rather:

SERVERNAME\SQLEXPRESS

By default SQL Express 2005 installs as an instance and not as the default instance.  Specify WHATEVER\SQLEXPRESS and you should be able to connect happily.

[knottyrope]

SQL 2005 or express is also locked down a bit during install

IIRC You have to enable protocols TCP/IP,Nammed pipes in order for BES to connect to it.

Message Edited by knottyrope on 08-21-2008 05:06 PM

[AndyDufresne]

You don't need to change protocol settings if you install it locally.

[davecason]

DOH !

OK, so now I'm lost ! (grin)  I just got back from a road trip and want to try to get the BES going this week.

I logged on to my server and opened the tool in the SQL called: MS SQL Server Mgmt Studio Express - the exe.

It opened a login to: SERVER\BKUPEXEC using my servers admin account .... so now what ?

Cheers'

Dave

[AndyDufresne]

create a new connection to SERVERNAME\SQLEXPRESS

[davecason]

Hi Everyone,

OK, so I made a new database in this SQL Server Management Studio Express program called: BESMGMT and the owner of it is the user on the server called VAUNTCOM \ BESAdmin ....... there is a bunch of folders under it called:

- Database Diagrams

- Tables

- Views

- Synonyms

- Programability

- Security

Can anyone clarify with this create db file or program is?

Cheers'

Dave

[AndyDufresne]

createdb.exe is an executable that reads a configuration file (by default named BESMgmt.cfg; but you can rename the cfg if you want).  It creates a skeleton / shell BlackBerry configuration database (also makes the appropriate entries in the master table and creates sql jobs).

[davecason]

OK, so do I need to add this to that database file I made or does the install program do that?

Cheers'

Dave