Macola SQL and SBS 2000 1

[Zbob]

Can Macola SQL be installed on A Small Business server 2000

I belive the SQL needs to be installed on a Sever with local accounts.

Is this true?

Anyone used SBS and Macola SQL(micrsoft)

Thanks.

 

[vbajock]

I haven't set this up for Macola, but I have set up SQL Server 2000 on a separate server on a SBS 2000 network, so I don't see why it wouldn't work for Macola. Macola probably has docs for this on their Website.

I believe on disk 3 (or 2?) of the SBS setup disks, you will find the set up folder for SQL 2000. Before you install, be aware of these of warnings:

1) The database size on the version of SQL Server included with SBS is limited to 2 gigabytes. If you have multiple companies, thats not much. If you think you are going to need a bigger database, buy the full version of SQL 2000, which you can get at an upgrade price if you own SBS.

2) if the satellite server is Win NT4, make sure you have installed DSCLIENT on the NT 4 server and upgraded to Service pack 6 and have properly joined the SBS domain before you install SQL2000, or SQL2000 will not connect to Active directory on the SBS server, causing you a world of headaches.

3) Use the SBS Admin console to join the satellite server to the SBS domain before you attempt the SQL 2000 install.
This process will generate any errors that need to be handled.

4) Using a Win 2000 satellite server is real straight forward. Just join it to the domain, and install SQL2000 from disk 3 to the server you desire.

5) I will tell you one thing - if you run Macola, SQL server and SBS Exchange/Web services all one server, your life will suck, unless by chance, you have a network of 2 or 3 workstations and a quad-processor Itanium server. All Macola server installs should be done on a dedicated server.

 

[Zbob]

Thanks for the info, but there is no DB limitation on SBS2000. It uses SQL Standard Edition. There is a Terrabyte on db's, 2GB Ram max and 4 processors.

Here's the MS link.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8ynn.asp

Thanks again, we are working on it now.

 

[vbajock]

I stand corrected on the size limit, which was 1 gig on 4.o, 10 gig on 4.5 and is now apparently unlimited!

 

[MacolaHelp]

FYI: sbs is officially not supported as the os for the macola application server. Rationale: it is very resource intensive & will slow the performance of macola. If you have low transaction volume, maybe you can get by. I am reluctanct, however, to recommend that clients use an OS unsupported by the OEM. If you have something really wierd happen, you are often on your own to figure it out.

 

[stravis]

As stated by MacolaHelp Macola is not well suited for SBS. To minimize problems stick to installing only the services and server applications you need. If you have a copy of SBS, install with only SQL Server and maybe a small service or two, and forget about the rest of the applications; especially Exchange. This is the only way that I could morally suggest that Macola will even begin to operate. Beware that this is not supported by Macola and that means that your support and maintenance dollars are all for not if you have a problem related to your network, server, etc...

Scott Travis
infoSpring, LLC.

 

[dgillz]

We have several people running SBS, as long as it is a fairly small Macola installation - 25 users or less - we have had no problems.

I am unsure what you mean by "unsupported" but we make tech support calls in this environment and get help. Then again we have never had a large issue with this that I am aware of.

The point about Exchange getting in the way is well taken. If you have a small number of Macola users, but a lot of Exchange volume, it might be best to have a separate Exchange server.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[stravis]

When Macola states that a product is "unsupported", it means that they do not test their software to insure that current and future versions work in this environment and that if their is a specific problem related the "unsupported" product, you are up the creek without a paddle.

Scott Travis
infoSpring, LLC.

 

[MacolaHelp]

Found this entry in the supported platforms doc today:

July 8, 2003
Added limited support for Windows 2000 Small Business Server Edition

Prior to this, the doc specifically said that sbs was not tested & was not recommended. Yes, Macola will try to help you out if you call, but the provision is that they are doing it as an above & beyond the call of duty. Exchange, in particular, seems to be the main sbs app that fights w/macola. Also, I know of sites that send/receive a lot of faxes & the system gets really clogged up & they start losing both incoming & outgoing faxes.

 

[stravis]

I stand corrected. Thanks MacolaHelp.

Scott Travis
infoSpring, LLC.