Networks

Ask something
Discussion Locked

SQL & IIS Services

0 helpful
6 replies

by wcoyote1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This is one for all you SQL and IIS specialists out there.

Lately, we've been getting many requests for installed SQL servers with a link to an IIS server for a web interface. At first it was only a couple so separate servers for the SQL instances and the IIS instances wasn't a problem. But now as it grows, it's going to become impractical to maintain single servers dedicated to that single function.

So, as I'm not an expert on SQL or IIS I'm hoping for some advice on how to manage this growing monstrosity.

First I'd like to know the "best practices" from experience, what worked, what didn't and why if possible.

Second, can you put multiple IIS sites on a single server and have them pointing to their specific databases on separate SQL servers?

Third, can you put multiple IIS sites on a single server and multiple SQL databases on a single server and have them communicate properly to each other?

6 replies

by cmiller5400

2. yes - Assign additional IP's to the server and make the IIS sites only respond to those IP's

3. yes -

Just requires a little configuration on your part. I am currently building a SQL server that runs 3 separate named instances of MS SQL server 2000. Google "SQL 2000 named instances"

by jmgarvin

You may want to add this when you repost:
1) Do you plan to cluster IIS and your SQL servers or this more for load balancing?

2) So you have multiple sites with multiple wsdls? (probably yes, unless I'm unclear on what you are asking) This may help answer your question though:
http://www.iis.net/extensions/DatabaseManager

3) So you are wanting clustering????

I'm confused by your post, so this is a pretty limited reply...

I'd make sure to repost this in questions.

by robo_dev

You can mix and match client-server technology many different ways, and if you add VMWare into the mix, then you can do even more.

To answer your questions: multiple sites on a server pointing to databases on other hosts? You bet.

Multiple sites and DBs on one server? Yup

There are a lot of 'gotchas' though that range from the 'eggs-in-one-basket' issue to performance issues.

In order to do some consolidation, you need a good feel for how much utilization and network traffic is expected for the application. You also need to know the requirements for uptime, disaster recovery, etc, of course.

Hosting multiple sites on one server:
http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/e5bc9d3c-0043-43c9-a5cc-ac390d74849b.mspx?mfr=true

VMware
http://www.vmware.com/

Server Consolidation
http://searchdatacenter.techtarget.com/generic/0,295582,sid80_gci1175762,00.html

A good 'baby step' is to put your QA/Test/Staging environment on VMware, then go from there.

by tony hopkinson

How you manage it. Well that's why they pay us the big bucks.

Personally I'd get an expert in if these are business critical. An early mistake could cost way too much.

Unless you just keep buying boxes, bulking up either through multiple apps on one box or cluster. You need to get some sort of SLA set up. Not as cya, but to make them think about what they need and what they can afford.

If you do an upgrade to something that doesn't really matter and take out something that does...

Or put all your critical apps on one machine and then 'lose' that....

by shellbot

Your question has been covered by now..so I've not much to add.

Sit down and do some planning and it can be done.
I've mutiple sites running on 1 web server, with mutiple databases running on my database servers..the web server conencts to mutiple database servers.

Such fun :)

by wcoyote1

For your insights and answers.

From what you've said and some of the links it seems quite possible and relatively easy to do. Now it's just a matter of figuring out how we really want to do things.

Thanks again for everyone's help.

This discussion is closed to new replies.