Mon, Aug 29 2005 18:56
SBA on SBS [the unsupported instructions to get the datafile ON the network]
So you build a Small Business Accounting Program and you call it a multi user version...and then you don't install it on SBS in such a way so that the msde datafile is 'on' the server, but rather on a desktop inside the office.
Okay ....lemme get this straight... why does EVERYONE see the word 'multi-user' and translate that to “Peer to Peer” except for me? I WANT that datafile ON the Server. I mean that's WHY I have a network you know so that data can be better protected over there. I don't see peer to peer networks as being of value to me. I WANT a server. I WANT the active directory goo. I WANT the control. So what's a gal to do?
She gets advice from her fellow geeks who hack up the way to get it on the server.
So here is the unofficial, unsupported instructions to get SBA on SBS 2003.
“What I have done is install Small Business Accounting on SBS2003. This results in an MSDE instance called MICROSOFTSMLBIZ being installed there. The instance can host the BCM database as well. You would install BCM on your workstation, set it up for sharing and add users. Then shut down Outlook and SQL on your workstation, copy the BCM database and log file to the server and use SQL Enterprise Manager to attach them there. Restart SQL and Outlook on the workstation. You should now be able to redirect Outlook to the copy of the database on the server.
Unfortunately this method is not supported by Microsoft as I mentioned in the meeting. In fact, if you have SBS Premium you can upgrade the MSDE instance to full SQL to remove any database size or number of user limitations.”
Remind me to email Dennis Clark and give him feedback to take back that they DO start supporting SBA on SBS. I mean... it just makes sense, you know?
Filed under: SBS "Hacks", Needed Patches/Tweaks