Search
  You are here: Tech Blog Register   Login  
Most recent blog entries
Virtually Reorganizing
All Things Tech By host on 1/1/2007 7:32 AM

The Purchase

This week, I really took a hard look at my existing server that runs all of my support systems (Active Directory, Exchange 2003, SQL, and IIS) and found it was struggling to handle the load.  On Thursday I went ahead and purchased a new box complete with Core 2 Duo 6400, Gigabyte 965DS-G motherboard, 4GB of DDR2 800mhz memory, a 300GB SATA 3 drive, and an ultra quiet case from Antec.  Construction took place on Thursday and Friday evenings.

My original plans to go down and work on my sailboat, Endless Summer, were scrapped for a full weekend of reworking my environment.  I decided early on that using VMWare GSX Server with core systems seperated into their own Virtual Machines (aka VMs) would be prime.  This would give me easier upgrade paths down the road.  I would have preferred VMWare ESX but it only runs on SCSI drives – SATA is not supported.

Virtual Machines

The VMs were broken down into Active Directory/Exchange 2007, SQL Server 2005, and IIS 6 for web and ftp traffic.  To run Exchange 2007, I needed a 64 bit operating system and opted for Windows 2003 Server Standard 64 bit.  Exchange 2007 installed without trouble and but did require some research and additional work to integrate it into my existing Exchange 2003 environment.  Next I created a Longhorn 32 bit VM with SQL Server 2005 Standard Edition.  Finally, a VM with Windows 2003 Standard 32 bit was created to take care of my front line web traffic. 

So on a single server that cost around $1200, I'm running the equivalent of 3 physical servers -- each having their own CPU and memory allocation.  Even more important is the fact that each VM can be moved to new hardware should the load become too much.  This move can be done by simply copying files to a new server with VMWare Server running.  Sweet!

Exchange 2007

After Exchange 2007 was installed, I moved all the mailboxes and the Offline Address Book from my Exchange 2003 box using the 2007 Management Console.  Then I started testing and found that outbound and inbound mail was not flowing.  After reading a bit I discovered that by default Exchange 2007 wants to have an Edge Transport server to handle the Internet based SMTP traffic.  Further research showed that you can make a few changes to your installation and turn a Hub Transport server into a fully functional Hub/Edge server.  For small business this will be advantageous. 

To modify the Receive Connector so that Internet traffic can send you mail, use the following command from the Exchange Management Shell:

Set-ReceiveConnector -Identity "Default " -PermissionGroups "AnonymousUsers"

Next you will need to add a Send Connector from the Management Console.
1. Expand Organization Configuration
2. Under the Actions menu on the right hand side of the window, click “New Send Connector”.
3. Give the connector a name (e.g. “Internet”) and choose Internet for its intended use and click the Next button.
4. On the Address Space page, click the Add button and put in the Domain value ‘*’ and click the Ok button followed by the Next button. 
5. On the Network Settings page, click Next.
6. On the Source Server page, click Next.
7. On the New Connector page, click New.

Now you should test your configuration using an external webmail source like Gmail.  Make sure you can send and receive externally.

Next you should test your configuration just to make sure you don’t have an open relay.  I used the Abuse.net page at < ...

Comments (0) More...

Creating Text Files with My.Computer.FileSystem.WriteAllText
All Things Tech By host on 12/29/2006 5:50 PM
UTF-8 encoding on my text fileToday I was having trouble with a simple text file receiving 3 characters at the beginning of the file.  After checking to make sure none of my output strings contained the characters, I started checking the methods use to write the file.  Sure enough, I had forgotten to change the default encoding (Encoding.UTF8) to Encoding.ASCII.  After changing my method parameters, the file came out clean and ready to use.

Example code:
My.Computer.FileSystem.WriteAllText("c:\myfile.csv", content.ToString, False, System.Text.Encoding.ASCII)
Comments (0)

Saving time during development
All Things Tech By host on 12/28/2006 9:54 AM

In September, I knew I had to do something about my development environment.  The systems I had in place were causing too much "lag" in my build/test cycles. 

During my parts selection for the new development workstation, I chose the Western Digital Raptor 10K RPM drive.  Although you pay more for less space, you gain up to 30% in read/write speed.  This directly translates into faster build/test cycles. 

Here is a chart showing some testing done with the drive:
http://www.barefeats.com/hard38.html

So when considering new systems and their associated cost, also consider the time saved during the project and what that is really worth.

Comments (0)

SQL Server - User already exists in current database
All Things Tech By host on 12/20/2006 5:42 PM

This is repost from Hugh Mc Gauran's blog that I found useful:

Error 15023: User already exists in current database - Easy Fix

After doing a restore from a SQL Server backup, the users login rights are removed from the database yet the user itself still remains in the roles of the database. This means that when you try and add the user again you get the error "Error 15023: User "albert" already exists in current database" and the addition fails.(where albert is the user you wish to add)

The quickest way to get this working is using query analyser and running the following command when working on the actual database.

EXEC sp_dropuser 'albert'

This will drop the user from the database and you can then re-add the user through the GUI or through a SQL query!

Comments (0)

Trillian Profile Copy
All Things Tech By host on 12/20/2006 5:42 PM
This one couldn't be easier.

1. Install Trillian and fire it up the first time.
2. Shut down Trillian.
3. Copy the \Program Files\Trillian\users\default folder to the same spont on the new workstation.
4. Start up Trillian and test.
Comments (0)

Dell UltraSharp 2007FP
All Things Tech By host on 10/14/2006 4:43 PM
I've been using the Dell 1801FP 18" flat panel (1280x1024) for several years now and have been completely happy with it.  After using the 2007FP 20" flat panel (1600x1200) in a dual monitor configuration for a day now I have to say WOW! 

I had read a few reviews in which the panels did not receive glowing ratings.  Thus, I did some looking around to see what options were available.  In the end, I found these flat panels head and shoulders above the others I looked at in this category: Viewsonic VP2030B, Samsung 204B, and NEC MultiSync 20WMGX2.

Overall, the panels are very bright and without any aberations around the edges.  With Clear Type enabled, the fonts are smooth and clean - nice!

Another great feature is the very thin square edge outside the viewable area.  When dual monitors are butted up to one another, you have only 3cm between visible desktops.  So the illusion of a seemless 3200x1200 desktop almost becomes reality.  Sweet!

Each panel comes with a height adjustable stand as well as the ability to pivot right and left.  Compared to the other adjustable stand panels I looked at, these are rock solid.  Even when I'm pounding out code on the keyboard, the panels do not move or vibrate. 

For US$450 each, I feel that I received a great product at a fair price.

Bottom line, for multi-monitor configurations, I just don't think these panels can be beat.
Comments (2)

Microsoft Access 2007 - Workgroup Security
All Things Tech By host on 10/12/2006 4:40 PM
I've been developing a large application in Access for a number of years. Today I attempted to open it up in Access 2007 for the first time and got the security warning that I was not a member of the proper workgroup. In the past, you simply selected a menu option and joined the proper workgroup by pointing to your .MDW file. This feature appears to have been removed in '07.

But all is not lost. You can fire up regedit and update the following registry key:

HKCU\Software\Microsoft\Office\12.0\Access\Access Connectivity Engine\Engines\SystemDB

I copied my custom MDW file to the following folder in my profile:
"C:\Documents and Settings\%username%\application data\microsoft\Access"

and changed the registry key to "Application Data\Microsoft\Access\custom.mdw"

Simply restart '07 and open your MDB and you are in business!
Comments (0)

Installing SQL Server 2005 Express Edition on Windows 2003 Small Business Server
All Things Tech By host on 10/11/2006 10:11 AM
I recently needed to put an instance of SQL Server 2005 Express Edition on a customers Windows 2003 Small Business Server in order to support a website I had developed for them.  I was very concerned that it might interfeer with the existing SQL 2000 MSDE that was installed.

So, I took the time and built an identical SBS server using VMWare Workstation.  From there I was able to install SQL 2005 Express and test the results.  It used the default settings and let it create its own instance. 

After the install and required restart of the virtual machine, I tested the systems and all were working normally.  I proceeded to do the installation on the production server and once again had a successful install with no impact to existing services. 

As of today, all services are running perfect and the website is up and running.
Comments (1)

 

Other things you might like...
 

All Things Tech... Mostly
 

Blog Search
 

All Things Tech... Mostly
 

Copyright 2007 by SummerWorks.us Terms Of Use Privacy Statement