Hi,

I've done a bit of searching here and on the internets at large, but haven't turned up much as of yet that I fully follow.

I'm on hold with RIMas I type this, but so far it looks like that will take forever (30 min at this point and haven't yet talked to someone that routes me to a tech) so maybe someone can answer a few simple questions faster, this forum seems pretty helpful.

In short I'm trying to install BES 4.1.3 with MDS on an SBS 2003 box that is running SQL Server 2005 ("for workgroups" I believe). We have someone else that deals with SQL for this server to manage multiple retail POS software connections. As such, I don't interact with SQL very often and while I assume what I'm trying to do is not terribly complex per se, it's still a bit of a mystery to me and I'm not sure of what pitfalls to watch out for either. I would ask the DB people, but they tend to be a little hard to get ahold of.

Basically once the BESAdmin account is created, permissions created per documentation, etc., do I need to create a database with SQL Server Management Studio or the BES install will do this for me? If the former, anything special I need to know about it or just create a "BESMgmt" database with the default options provided in SQL SMS? If the latter, will specifying Windows (Trusted) auth be fine or I need to use SQL auth?

Thanks in advance . . .