06-08-2009 01:30 PM
Not sure if someone else has posted this before but I am trying to install BPS 4.1.4 on a virtual machine hosted by SBS2008. Here are some mor edetails.
Virtual Machine: Server 2003 R2 x86 (all updates are installed)
Database: MS SQL Express 2005 with SQL Server Management Studio Express
Exchange Server 2007
Permissions applied: I have added and rechecked all permissions from here http://www.blackberry.com/btsc/microsites/search.d
The error I am getting when BPS tries to create the database is "An attempt to install the database was unsuccessful. An error occured while executing an SQL statement."
Has anybody else encountered this?
Solved! Go to Solution.
06-08-2009 03:58 PM
Please double check your SQL permissions and make sure you enter your SQL server info correctly (I have made that mistake a few times.)
IIRC it is \\Servername\SQLExpress\BESmngt if you used the createBD.exe tool.
06-08-2009 05:10 PM
BPS or BES can be fun to install, with all the diff permissions it needs.
Let us know how you are progressing.
06-09-2009 08:17 PM
06-09-2009 08:29 PM
Ignore the error.
Make sure you have Microsoft Exchange Server MAPI Client and Collaboration Data Objects 1.2.1 installed and set the appropriate permissions .
If you've done that you're all set ... continue.
06-09-2009 08:42 PM
Yes the version of the MAPI client and CDO is 1.2.1. That's is where I got my copy. However, when I ignore the warnings about MAPI and proceed I get
"An attempt to install the database was unsuccessful. An error occured while executing an SQL statement."
I followed knottrype's post above and also used SQL Management Studio to apply the serveradmin, sysadmin, and dbcreator roles for the domainname\BESAdmin account. Right now I'm thinking of deleting the virtual machine and recreating it.
06-09-2009 08:48 PM
If you look in the install log (which I think defaults to somewhere in the %TEMP% directory) you can see what statement it is failing on. If you have already attempted an installation and it fails the best thing to do is start over from scratch.
1) Delete the BESMgmt database
3) Start the installation again
Has the database been created yet? (any shell at all) ... perhaps SQL is installed in an instance and not the default instance too ...
If you want to post the install log here or send it to me in a PM I'll post back the relevant content here ... just be sure to post a link to this thread in the message you send me . You can also email me at BBAndyDufresne@gmail.com.
06-09-2009 09:32 PM - edited 06-09-2009 09:33 PM
I think you are right. I checked event viewer and I found that this one.
Event Type: Error
Event Source: MSSQL$BESMGMT
Event Category: (2)
Event ID: 5170
Time: 6:16:34 PM
Cannot create file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\BESMgmt.mdf' because it already exists. Change the file path or the file name, and retry the operation.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0000: 32 14 00 00 10 00 00 00 2.......
0008: 15 00 00 00 42 00 4c 00 ....B.L.
0010: 41 00 43 00 4b 00 42 00 A.C.K.B.
0018: 45 00 52 00 52 00 59 00 E.R.R.Y.
0020: 50 00 53 00 5c 00 42 00 P.S.\.B.
0028: 45 00 53 00 4d 00 47 00 E.S.M.G.
0030: 4d 00 54 00 00 00 00 00 M.T.....
0038: 00 00 ..
So what do I do? Just go to that path and delete the entire Data folder or just the BESMgmt.mdf? Sorry, I'm very poor with SQL stuff.
06-09-2009 09:36 PM