Home Server help SQL/Tomcat

[DJSKYLINE]

Hi

I am thinking of this setup. Does anyone know if this is physically possible and any ideas on help guides?

I will have a win7 OS machine

I want to install Tomcat and SQL Server Management Studio Express 2005 on it so I can make use of JSP pages than connect to the SQL Database.

This will be on the same machine so its ok if I connect to the database as localhost right?

Then, I want to install Apache Server so I can access this computer and JSP's over the internet to use my applications.

Does that sound possible?

 

[Skidilliplop]

Yes that sounds fine.

Juse be sure you're careful how you set up SQL to avoid any performance issues.

SQL will go off and steal as much RAM as it can get it's hands on, which on a 64bit OS can be a lot. You should set memory usage limits on each DB to prevent that. You want to give SQL plenty of RAM but you'll need a couple of GB left for everything else.