I was interested on how to host multiple domains on a single server using only one IP address. In my case I’m using IIS 6.0 on Microsoft Windows Server 2003. This can be accomplished using “host headers”. The host header distinguishes between various DNS names sharing a single IP address, allowing name-based virtual hosting.

If you are creating a new website in IIS. The third page in the “Web Site Creation Wizard” has a field titled “Host header for this Web site (Default: None):”.

If the website has already been setup in IIS. Right click on the website and select “Properties”. In the “Web Site” tab, click the “Advanced…” button. Edit the current entry for the website to add a “Host Header value:”.

SQL Server 2000: Northwind & Pubs
Download 1 – Download 2
Instructions:

• Run “SQL2000SampleDb.msi”
• Browse to “C:\SQL Server 2000 Sample Databases”.
• Execute “instnwnd.sql” & “instpubs.sql”

SQL Server 2005: AdventureWorks & AdventureWorksDW
AdventureWorksDB.msi – AdventureWorksBI.msi
Instructions:

• Run “AdventureWorksDB.msi” & “AdventureWorksBI.msi”
• Attach the databases by executing the following script:

exec sp_attach_db @dbname = N'AdventureWorks',
@filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf',
@filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_log.ldf'

exec sp_attach_db @dbname=N'AdventureWorksDW',
@filename1=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorksDW_Data.mdf',
@filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorksDW_log.ldf'

Microsoft Windows 7 is Vista?

Installation was easy

Windows 7 Welcome Screen

Windows 7 Desktop

Windows 7 Control Panel