Publishing a webmatrix site on my own PC, is it possible?
Last post Oct 10, 2011 03:58 PM by HCamper
Oct 07, 2011 03:14 PM|ZonerZ|LINK
Just stumbled upon WebMatrix, and I have to say it is one of the easiest web development tool by far (not that I'm doing that much web development, mind you). I've been using our own VB6-based app and SQLServer 2008 Express for my stores in different cities,
but for some reason the bandwidth used when transferring data is very small (of the available bandwidth), causing queries to take forever, and so on and so forth. So I'm thinking of switching to some sort of a web interface, and hopefully it will solve this
whole bandwidth problem.
Anyway... I'm not really looking to publish the site for all the world to see & access, or for it to be available 24/7, and all that. I just want it to be accessible from my other stores (and maybe my sales team using tablets/smartphones) during the HQ's
business hours, so they can create purchase invoices, look up inventory, and all that. There are not going to be a gazillion transactions per second and all that; the stores are quite small and they mainly handle wholesale transactions, so I estimate the number
of transactions to be around 200-300 per minute from all stores (including queries). So I'm thinking of running it in my own server, instead of using a web-hosting service.
The server is running Win7 Ultimate 64bit on an Intel Xeon CPU with 8GB RAM, and I'm using SQLServer 2008 Express for the DB. I can setup port forwarding and the likes myself. For now, I use LogMeIn Hamachi for the tunnel between stores and the main HQ (obviously,
my sales team won't be able to use Hamachi for tablets/smartphones, maybe a regular VPN over SSH).
What I really need to know is/are:
1. Is it possible to do what I want to do using my server?
2. Do I HAVE to switch to a more server-oriented OS like Windows Server?
3. How do I setup the server to be a web server (if possible using current OS)? What software do I need to install? If possible please suggest the free version (like the SQLServer Express).
I have absolutely NO knowledge in web hosting/publishing. My latest contact with web development was in my college years, coding in HTML using Notepad for my CS class. So please speak in Layman's terms, if possible.
Thanks in advance.
And again, thanks for a great app!
Oct 07, 2011 03:38 PM|HCamper|LINK
You should take a very hard look at "I'm thinking of running it in my own server, instead of using a web-hosting service."
this can be very time consuming and requires more time than the cost of Hosting Services from others.
Yes, You can use your server you need to consider Security for the Windows system and the IIS server.
You should look Hosting through
http://forums.iis.net/p/1181819/1996834.aspx#1996834 thread instead.
You do not need to switch to Windows Server if the total users are 10 < or less performance maybe a problem
for both the Users and Your Use of the System.
Yes you have to set-up the system as a Web Server and the IIS Express is for Test Development only.
The other Web Platform Products SQL Server Express Visual Studio Web Developer can be used for your Web Server & Tasks.
I hope I did not miss something,
Feel free to ask more questions,
Oct 07, 2011 04:15 PM|ZonerZ|LINK
Hmm... I guess I wasn't being clear, I apologize for that. Thanks for answering tho.
Anyhoo... Reason I'm asking this is because although I can access
http://localhost:1234 from the server, I can't seem to access
http://server:1234 from other machines in the LAN (or the VPN). So I guess I just need to be able to access that
http://server:1234 from machines other than the server, not "REAL" web hosting. Would that count as hosting though? An intranet thing, maybe?
Anyway, to respond to your answers:
** Yes, You can use your server you need to consider Security for the Windows system and the IIS server.
Everything will (should) be done through VPN tunnels (hamachi or VNC), no one else should be able to access it. As for security, I do have NIS running full time on the server, and it's updated daily.
** You do not need to switch to Windows Server if the total users are 10 < or less performance maybe a problem for both the Users and Your Use of the System.
The machine is only used for server, so nothing else is running on the machine (besides NIS). And besides, I won't have that many user accessing the DB at the same time, at least for now.
** Yes you have to set-up the system as a Web Server and the IIS Express is for Test Development only. The other Web Platform Products SQL Server Express Visual Studio Web Developer can be used for your Web Server & Tasks.
So, which one do I need to install? Like I said, I have close to zero knowledge of this thingamajig called "Web Server". From what I read, VS Web Developer looks a lot like WebMatrix. Like I mentioned above, what I really need is just the program that will
allow other machine on the LAN/VPN access http://server:1234, nothing fancy. By the way, the IIS -IS- a web server, right? And WebMatrix includes IIS Express, right? So why can't I connect to server that's using the IIS express included in webmatrix? Getting
very confused here. More explanations, please.
Oct 09, 2011 04:10 AM|HCamper|LINK
Hi @ ZonerZ,
I suggest you read http://forums.iis.net/t/1179046.aspx thread
and information for number of users and Windows 7 using IIS Server.
Oct 10, 2011 12:46 AM|HCamper|LINK
Please look at Web Matrix http://forums.iis.net/t/1181022.aspx thread
and http://forums.iis.net/t/1179215.aspx which address the limits of IIS Express.
You need to use Windows 7 IIS Server as the "thingamajig" for Web Sites.
The reason you can not connect is not having a registered "Domain Name" which needs to be purchased.
Two local stores in the TLD DNS Mall a story form of Web Sites:D.
A) Store Bob has an unlisted Phone Number XXXX with Special ID and finds that Customers / Employees can not
call to check if the Store Fred is even open for Business.
Store Bob has spent lots of time on a list of hours and sales items.
Store Bob is thinking about having a SQL Server Email List for Customers / Employees but has no information to get started.
B) Store Alice has an number listed Phone Book XXXX with Special ID and finds the Customers / Employees can
call to check if the Store Alice is open Business and while on the Phone XXXX they use the Special ID they
also get a list of Store Hours and Sales items.
Store Alice has spent lots of time on lists for Hours and Sales Items.
Store Alice has grown also maintains a SQL Server Email list for Customers / Employess with information on number of Sales and Money.
Your choice is Store Bob or Store Alice.
There is not Store Ted Store Carol yet for those who might ask.
Edit: IIS Express performance http://forums.iis.net/t/1175052.aspx .
Feel free to ask questions,
Oct 10, 2011 09:46 AM|ZonerZ|LINK
Oct 10, 2011 03:17 PM|HCamper|LINK
Nothing to feel dumb about. :)
Since you had CS classes the teachers always say there is never a Dumb question.
Computers on the other hand are Dumb don't ask them a question and expect a good answer :(
You can create Web Sites using ( Razor Style ) with ( Web Matrix ) to be used on IIS 7 Servers.
AFAIK UtilDev Web Server Pro aka Cassini may still has some limitations like IIS Express.
I used the UtilDev Web Server in the past on Windows XP for custom applications only ( Calendar Memo Pad)
and had IIS 5.1 server for Web Sites.
I hope Store Bob Store Alice can survive the learning curve and stay in business :D.
You might check out the ASP.NET Videos and guided
Tutorials http://www.asp.net/webmatrix/content-guide from Microsoft.
Oct 10, 2011 03:52 PM|Vegan Fanatic|LINK
I use my own server but keep in mind I have been at it for eons.
I used Linux for years before IIS finally figured out that vhosts were only the tip of the iceburg
Today I have migrated to Server 208 R2 and I have dragged PHP along with me. PHP is the defacto server side language on Linux and its also widely used with IIS.
Conveniently I used the webplatform3 to upgrade PHP to 5.3.8 and the tool also fixed mime types and other spurious errors.
You can get that from the IIS.net home page now. I should point out I fingered a problem, but at least its fixed now. I am a MVP so Microsoft trusts me to find errors.
Now running a server at home is going to eat up time like no tomorrow. Nothing can make up for a lack of experience.
PHP powered by IIS 7.5 on Server 2008 R2
Oct 10, 2011 03:58 PM|HCamper|LINK
To add to Vegan's reply nothing like "Patch Tuesday" and taking the IIS Server off-line
while doing Updates and Patches.