Re: When to install ColdFusion 7 and SQL Server?

shawn gibson <shawngibson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
You are indeed, my hero right now.

<scuffs foot, blushes>

Please let me try to get this all
done in one post, because you've probably saved my ***, if you'll
please allow a few more potentially stupid questions:


Some might say so - I'm not a web person, so I can't really do
anything besides spread gossip.

I've had ZERO problems with Apache over at least 5 years, on
completely un-professionally set up systems (I've done it all myself
and am no expert) - I TRUST Apache.

Cool.

If I set the PUBLIC sites to Apache,

.....I presume you mean, on entirely different hardware which you
are putitng in a DMZ - you won't want to allow TCP 80 traffic into
your internal network.

Now I'm lost, I don't know what DMZ is.

Not a student of military history, eh? It means, "demilitarized zone" ...and
for networks, it means a network segment that isn't on the WAN or the LAN,
but in between - with limited access between 'em. You wouldn't let the
webserverbound traffic into your internal network at all. A lot of
routers/firewalls have a true DMZ port (it's an entirely different subnet)
or you can create your own with switches & routers.

Do I help myself by asking the
question "should I use vmware/MS Virtual to separate out Apache, and
maybe even use XP Pro to that end, UNDER (i.e. in vmware) SBS?" In
other words, use SBS as my main OS, and use Exchange/intranet with
that, but use vmware and an XP Pro OS to run Apache>ColdFusion>MySql?

Sure, you could, but with XP Pro you're limited to 10 connections, which
doesn't make it a great webserver. Honestly, for your web stuff, why use
Windows at all?

I realize that is not a separate box, but it's the best I can do for
now.

If you can put a virtual server in a DMZ, well and good.

What if all the Exchange/intranet(SharePoint) stuff was routed to say
port 81 through SBS? and all the web-accessible (Apache/ColdFusion)
was the generic port 80 on a vmware XP Pro setup?

They shouldn't touch at all, seriously.

does that still give me an
intranet and the ability to use Exchange for my main domain,

Yep.

Frakin' A, as they might say on BattleStar...oh nevermind:)

I used to watch the old show, but I don't remember much about it.


and the
ability to use MS SQL

Yes, if you bought Premium

(or should I stick with MySQL 5?)?

If you didn't buy Premium, you didn't get SQL, but you've got MSDE.
You can install 2005 Express if you wish.

I want to learn MS SQL 2005 as it's what my day-job IT guys use,
might help me move from a lowly Compliance Administrator to an IT
job...

I don't think it's Premium. But I know it does have a couple of SQL
services running, and SharePoint, so I'll have to double-check that
(and at one point, before one of the RMAs, SharePoint DID work).

Yes, because it comes with MSDE.

But you can't strip out Exchange or SQL onto their own boxes, as I
wrote. SBS is an all-in-one thing.

I'll cross that bridge when I come to it - I don't have the $ to buy
new boxes yet, but will certainly do it if I get the traffic to
warrant the performance increase.

Sure. But just to be clear..... you will absolutely not be able to put
Exchange/SQL on their own servers. Anything that comes with SBS has to stay
on that single server.

I could use a spleen. Mine seems to be overly vented these days.
:-)

I think I gave that away...will a pineal gland work? You will be the
life of the party at academic gatherings in a room full of
Cartesians:)

CCOM (= "cleans coffee off monitor")

Bottom line - if you don't need active directory and Exchange, SBS
is not the right tool for this job. You can't run SBS as a regular
Windows server.

Definitely want to use Exchange - I like it, and other options
(XMail) don't seem to work well for me (that'd be my own ignorance ,
no doubt).

I love Exchange.

If you want to use SBS for your own internal network, and a separate
webserver (on a truly isolated network segment!) for your public
websites, that's just fine. However, you have to set it up
correctly - using all its myriad wizards, and it's often recommended
that you set it up several times for practice before officially
deploying it.

It sounds like, with enough learning, proper configuration (both with
SBS and vmware), and some good luck, I will be OK, if the questions
above make it doable (vmware etc.). I don't care if it takes me 4-5
installs and another month - I am a religious Ghoster - I Ghost each
step that appears to have worked so I can revert when I invariably
make some next step go kablooey - it works, I can do an
XP>Apache>MySQL>ColdFusion install in my sleep first run-though
because of that work ethic - I learned the hard way, but was always
smart enought to make sure each thing that did work, didn't fall
apart, I love Ghost.

I'm more of an Acronis fan, but sure, yes, agreed overall.

I owe you, big time - you have given me a path, thanks VERY much:)

You're most welcome. I suggest you get out your vendor-reaming tools and go
to town on the guy who sold you stuff.

Shawn



.

Loading