Port 25: The Open Source Community at Microsoft : Technical Analysis, Web

Technical Analysis: Installing Apache on Windows

jcannon — Tue, 12 Feb 2008 13:21:00 GMT

Abstract: By many estimates, Apache is the world's most popular web server software, hosting more than half of active domains according to Netcraft. Typically, Apache is run on Linux or UNIX, but it runs quite well on Windows. This paper provides an introduction to running this software on Windows and provides a framework for understanding how Apache on Windows is fundamentally different from Apache on Linux.

Download Installing Apache on Windows

Note:This paper represents testing and documentation in a lab environment. User Account Control (UAC) is an essential security component to Windows and Microsoft does not recommend turning off UAC in production environments.

MySQL on Windows: Configuration & Install

jcannon — Fri, 16 Mar 2007 19:02:00 GMT

This week, the lab looks at configuring and installing MySQL - an open source relational database management system which is typically used for web applications.

This paper will provide an overview of configuring & installing this software on Windows. MySQL does not have as many features as PostgreSQL, however, and one would expect it to perform substantially better than PostgreSQL on Windows because of its thread-based architecture (PostgreSQL uses a process-based architecture instead).

Note: This paper represents testing and documentation in a lab environment. User Account Control (UAC) is an essential security component to Windows and Microsoft does not recommend turning off UAC in production environments.

PostgreSQL on Windows: A Primer

MichaelF — Thu, 22 Feb 2007 21:06:00 GMT

This paper will cover the installation and initial configuration of PostgreSQL 8.2 on Windows up to a point where a database is created and plpgsql is installed in it. We assume an ability to walk through the install wizard in general, though screens that do require additional information will be covered (with screenshots). Important options in the postgresql.conf and pg_hba.conf will be covered, as will database creation in PgAdmin III.

HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

admin — Wed, 14 Jun 2006 19:46:00 GMT

HOW-TO: CONNECTING SQL SERVER 2005 JDBC to JBOSS

We have been working in the labs regarding testing and integration of jBoss talking to a SQL server 2005 backend.

We have seen some questions on how to connect a SQL Server in the Windows environment to jBoss. So I wrote a little how-to that describes just that.

It turns out that it is actually very simple.

Essentially, all that’s involved with installing the driver is:

Download the jdbc driver from here; http://www.microsoft.com/downloads/details.aspx?familyid=e22bc83b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en#filelist (Scroll to the bottom of the screen)
You can either download the Windows or Unix version. It does not really matter which one you use. For this example I use the Windows version.
Run the downloaded exe file; this will create a directory called Microsoft SQL Server 2005 JDBC Driver in the directory you downloaded the file to.
Copy the file Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu\sqljdbc.jar to your $JBOSS_HOME/server/default/lib
Set your data source of your application to use the driver;

<local-tx-datasource>

<jndi-name>DATASOURCENAME</jndi-name>

<connection-url>jdbc:sqlserver://DATABASE URL;databaseName=jboss;</connection-url>

<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>

<user-name>DATABASE USERNAME</user-name>

<password>DATABASE PASSWORD</password>

</local-tx-datasource>

NOTE: Substitute DATASOURCE NAME, DATABASE-URL, DATABASE USERNAME and DATABASE PASSWORD for your local values.

And that is all there is to it. jBoss now should be able to connect to the SQL Server.

Special thanks to Dan Simonton one of our penguins who did a bunch of the testing on this.