Thursday, September 17, 2009
NIC Intermittent Connectivity
I quickly found in the eventvwr that the tcp/ip connection was going up and down every few minutes. After changing the patch cable and testing the desktop on a new network drop I found the answer. Changing the speed of the NIC from "auto detect" to "100 Mbps Full Duplex" resolved the issue. Apparently in it's old age something started causing it to fail to negotiate the speed. As such it was constantly trying to re-negotiate the speed which caused the up / down connections.
Thursday, September 10, 2009
Install SharePoint to share port 80
I did the following on Windows 2008 IIS.
- Install SharePoint to port 80 (in my case as the non-default website)
- Open Manage network connections (ncpa.cpl from run)
- For your network connection go into properties
- Go into IPv4 properties
- Assumtion is that you already have it set to Static IP address
- Click Advanced
- Click add and add in another unused IP address (ex: 192.168.1.100 for main and add in 192.168.1.101)
- Ok out
- In IIS click the default website
- On the right side click Bindings
- Edit and change the IP address from * to the main IP address (192.168.1.100 in our example)
- Okay out
- Click the new Sharepoint site (Default name is SharePoint - 80)
- Click Bindings and change IP address to the secondary IP (ex 192.168.1.101)
From here you can access the original website normally and the Sharepoint site via the new IP address. This brings up some new issues though...
DNS Entry to make the site "friendly"
- Open your domain DNS and add a new Host (A). Make the Name what you want your users to type in to reach the site, then enter the second ip address (SharePoint site address)
- Try to ping the name you just entered. It should pingback as the ip address you just set.
- Try to navigate to the site (ex: http://example/)
Next issue... Authentication loopback check doesn't like this setup much. At this point you'll find that credentials fail. After a lot of searching I found the solution here: http://blogs.bluethreadinc.com/thellebuyck/archive/2008/10/30/401.1-error-when-accessing-sharepoint-from-server.aspx
- Click Start, click Run, type regedit, and then click OK
- Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
- Right-click Lsa, point to New, and then click DWORD Value
- Type DisableLoopbackCheck, and then press ENTER
- Right-click DisableLoopbackCheck, and then click Modify
- In the Value data box, type 1, and then click OK
- Exit Registry Editor
- Restart the computer.
Note that the auther includes the following: "The security is reduced when you disable the authentication loopback check, and you open the Windows Server 2003 server for man-in-the-middle (MITM) attacks on NTLM."
Tuesday, September 8, 2009
Virtual Iron > XenServer Convert Data Disks
- Use XenConvert 2.0 on the machine with the disk attached (ensure that any services such as SQL etc have been disabled so that the files on the disk are not in use)
- From: This Machine (machinename)
- To: Xen Virtual Appliance
- Choose disk (D: in this case)
- Choose location
- Once it's finished go to XenServer and select import VM
- Setup the import like a normal VM, but at the end deselect the "Start automatically" option
- Once finished importing you can delete the VM but choose to leave the SR intact
- Go to the server that needs the disk attached (or import if you haven't already) and attach the disk that's needed
Saturday, September 5, 2009
Restore XenServer with HP Lefthand Networks SAN
I had created a Wiki site for internal admin use on a W2K8 server on IIS. I decided that I didn't want to build another W2K8 server and use another license for the SharePoint site so instead I decided to have it run on the wiki site as well. During the install I made the mistake of creating the SharePoint site as the default site which was very effective for killing my Wiki site.
Luckily I had created a Snapshot on my LH Networks SAN prior to the SharePoint install. Here's the steps I used to restore.
- First I gave my test XenServer pool access to the Snapshot in the Lefthand Console.
- Turned off the Production server
- Detached the SR for the Production Server in question
- Created a new SR in the test pool
- Target IQN of the Snapshot name
- When you click finish it will see the disk and warns not to attach if other pools are using the SR. (thus the reason we turned of and detached the production server / SR). Click Yes
- Create a new vm with correct properties.
- Select any install media, it won't matter as you won't be installing
- You won't be able to select the Virtual Disk you want since it won't have free space. So just select any disk and we'll fix later
- Give it a nic
- UNcheck the Start VM automatically
- Go into the properties of your new VM
- Change boot order so HD is first
- Go to Storage and Attach the correct Virtual Disk
- Delete the Virtual Disk from when you created the VM (if you selected one)
- Ensure RAM / CPU are set correctly and boot.
- Check over the server to ensure it's what you want to restore
Once I verified that this was the server snapshot that I wanted I went to pull this into production
- Turn off the test server you just created
- Forget the Virtual Disk (this doesn't destroy data)
- Go into the HP Lefthand console and and right click the Snapshot you want and choose "Rollback".
- All Snapshots and changes created after that snapshot will be lost! Make sure this is what you want first.
- Go back to XenServer Console and click the Production SR and click Attach.
- Fill in the IP info and Discover LUN etc. Click yes to the warning about other VM's on it again.
- Start server
- Glance around the office to see if anyone noticed that the wiki was down ;)
Thursday, September 3, 2009
View Network Connections when Control Panel icons hidden
I've found a couple of times now where the Network Connections icon is hidden, but this can be useful for finding out of a computer is getting an IP address correctly or not. Sure the command prompt ipconfig works too, but if the admin has the Control Panel locked down then surely they have the command prompt locked down ;)
Click Start
Click Run
Type ncpa.cpl
You'll see the friendly network connections your used to seeing (Windows XP).
Right Click the connection and select status, support tab, details.
Tuesday, September 1, 2009
SQL Server 2000 to 2005 upgrade
Upgrade process from SQL2000 Standard to SQL20005 Standard
First check versions of SQL Server. You can do this by running SELECT @@VERSION on the master DB. For Analysis Services you can check by opening and clicking Help - About. 8.0.2039 = SP4
- Make backup of all DB's
- Apply SQL2000 SP4 if needed
- Apply SQL2000 Analysis Services SP4 if needed
- Install SQL2005
- Select the following
- SQL Server Database Services
- Analysis Services
- Workstation components, Books Online and development tools
- Others if needed
- Click Advanced
- Ensure pathing for each component
- Default Instance
- Select the following
- SQL Server Database Services 8.00.2039
- Analysis Services 8.0.2039.0
- SQL Server Authentication Mode
- Analysis will run
- Use the built-in System account (Local System)
- Latin1_General
- Accent - sensitive
- Dictionary order, case-insensitive, for use with 1252 Character Set.
- Install
- Install latest SP's / updates