A few weeks ago I had someone ask me about restoring a single Excel spreadsheet in Microsoft Office SharePoint Server 2007 (MOSS). The spreadsheet had been overwritten by uploading another one in its place with the same file name. Versioning was not turned on in this document library. The spreadsheet that needed to be restored was not in the user's or admin's recycle bin. I guess that's because it wasn't actually deleted. I decided that if the data is saved in the SharePoint content database Read more [...]
The Windows 8 Developer Preview was publicly released this past Tuesday evening via the new Windows Dev Center. I actually thought I was going to miss out on the opportunity to try out this preview version since I’m not currently a MSDN subscriber. I was happy to learn that it was made available for anyone to download.
Since this is a preview version, I decided to load it as a virtual machine on a Hyper-V server. This kept me from tying up any of my machines that I need to work properly on a Read more [...]
PDF’s that have been uploaded to your SharePoint 2010 document libraries do not show the correct icon and only give you the option of saving instead of opening them:
The following PowerShell script downloads a 17x17 GIF image from Adobe.com named pdficon_small.gif, places it in the images folder under the 14 hive, associates it in the DOCICON.XML file, sets Browser File Handling to Permissive, and then runs IISReset:
The first part of the script downloads Read more [...]
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | $14 = "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14" $src = "http://www.adobe.com/images/pdficon_small.gif" $dst = $14 + "\TEMPLATE\IMAGES\pdficon_small.gif" $webClient = New-Object System.Net.WebClient $webClient.DownloadFile($src, $dst) $xml = New-Object XML $xml.Load($14 + "\TEMPLATE\XML\DOCICON.XML") $icoAsn = $xml.CreateElement('Mapping') $icoAsn.SetAttribute('Key','pdf') $icoAsn.SetAttribute("Value","pdficon_small.gif") $xml.DocIcons.ByExtension.AppendChild($icoAsn) $xml.save($14 + "\TEMPLATE\XML\DOCICON.XML") Add-PSSnapin Microsoft.SharePoint.PowerShell Get-SPWebApplication | ForEach-Object {$_.BrowserFileHandling = “Permissive”; $_.update()} iisreset |
Download the EqualLogic Host Integration Toolkit (HIT Kit) for Microsoft from the EqualLogic support site. Install the PowerShell Tools portion of the HIT Kit on the computer you want to manage the SAN from. For a PS4000, this computer doesn't need access to the iSCSI network as long as it has connectivity to the management network.
The following PowerShell script creates a 36GB thin provisioned volume named mikefrobbins with a snapshot reserve of 100%, sets a description for the volume, allows Read more [...]
I recently loaded Windows 7 on my netbook computer and ran across a tool named "Windows 7 USB/DVD Download Tool" which makes creating a Windows 7 bootable USB flash drive much easier. Download and install this tool.
Open the program and select the ISO you want to copy to your USB flash drive.
Select "USB device":
Select the USB flash drive you want to copy the Windows 7 installation media to. Warning: This process erases all data that currently exists on the USB flash drive you Read more [...]
This blog article is a scenario that I sent a coworker a while back about recovering a SQL Server database up to the point in time where a catastrophic hard disk drive failure occurs for the hard drive containing a SQL Server database. The transaction log for this database is on a separate physical disk and is still accessible.
I added the Northwind database to SQL Express on my machine, changed the recovery model to full, and then backed up the database and transaction log:
Processed Read more [...]
1 2 3 4 5 6 | BACKUP DATABASE Northwind TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\Northwind.bak' WITH DESCRIPTION = 'Northwind Full Backup', NAME = 'Full Backup' GO BACKUP LOG Northwind TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\Northwind1.trn' WITH DESCRIPTION = 'Northwind Log Backup', NAME = 'Log Backup' GO |
Configure the outgoing email settings in a SharePoint 2010 Farm with PowerShell.
Launch the PowerShell ISE. Import the SharePoint PowerShell Snap-in, modify the script below using your specific email server settings and then run the script.
The outgoing email settings are now configured.
µ Read more [...]
1 2 3 4 5 6 7 8 9 | Add-PSSnapin Microsoft.SharePoint.PowerShell $SMTPSvr = 'mail.mikefrobbins.com' $FromAddr = 'noreply@mikefrobbins.com' $ReplyAddr = 'noreply@mikefrobbins.com' $Charset = 65001 $CAWebApp = Get-SPWebApplication -IncludeCentralAdministration | Where { $_.IsAdministrationWebApplication } $CAWebApp.UpdateMailSettings($SMTPSvr, $FromAddr, $ReplyAddr, $Charset) |
This blog article will guide you through the process of slipstreaming SP1 into Microsoft SharePoint Foundation 2010. The process for the non-foundation edition is identical with the exception of the file names and the actual service pack file.
You’ve downloaded SharePoint Foundation 2010 and SP1 for that specific version to D:tmp. You've created a folder (D:\sp2010) to house the installation files once they're slipstreamed.
Extract the SharePoint installation files into the D:\sp2010 folder::
Extract Read more [...]
1 | SharePointFoundation.exe /extract:D:\sp2010 /quiet |
This blog is a continuation from last weeks blog (Part 2). We’ll jump right in where we left off. Verify you are logged into the server that you want to install SharePoint on as the spNameInstall account. Right click the PowerShell ISE and select "Run as administrator":
Load the SharePoint PowerShell Snap-in:
You will receive "The local farm is not accessible. Cmdlets with FeatureDependencyId are not registered." This is normal since we have not configured Read more [...]
1 | Add-PSSnapin Microsoft.SharePoint.PowerShell |
This blog is a continuation from last weeks blog (Part 1). We'll jump right in where we left off. Verify you are logged into the server that you want to install SharePoint on as the spNameInstall account. Run the SharePoint executable (SharePointFoundation.exe) that you previously downloaded. Select "Install software prerequisites":
With SharePoint 2010, there's no need to manually install any of the prerequisites as in previous versions of SharePoint. It installs all of them for you:
The SharePoint Read more [...]
You're ready to introduce SharePoint 2010 into your SMB and you've chosen to install the "free with Windows Server" version called "Foundation". Details about this version can be found on the SharePoint Foundation 2010 Production Information webpage. You'll need a minimum of two servers, virtual or physical with the specifications listed below to get started. While it is possible to run SharePoint 2010 on a single server, it's definitely not recommended for a production environment. Depending on Read more [...]
I’m in the process of installing SQL Denali and need a couple of users accounts created.
If you are creating the Active Directory user on a machine other than a domain controller, you’ll need to install the Active Directory module for Windows PowerShell. Then import the Active Directory module.
To see the syntax and available options for creating an Active Directory user using PowerShell, type "Get-Help New-ADUser" inside the PowerShell console.
Store Read more [...]
1 2 3 | Import-Module ServerManager Add-WindowsFeature RSAT-AD-PowerShell Import-Module ActiveDirectory |
PowerShell 2.0 is installed by default on Windows 7 and Windows Server 2008 R2. The PowerShell ISE (Integrated Scripting Environment) is installed by default on Windows 7, but not Windows Server 2008 R2. You can use the following information to install the ISE on your 2008 R2 server (as long as it’s running the full GUI and not the Core installation).
Launch PowerShell and execute the following:
If you attempted to run this on the Core (no GUI) installation Read more [...]
1 2 | Import-Module ServerManager Add-WindowsFeature PowerShell-ISE |
Problem:
You're unable to login to your EqualLogic PS Series Storage Area Network (SAN) to perform
administrative functions. When you attempt to login, you receive a login exception message stating "Invalid username or password".
Solution:
The grpadmin account password can be reset by connecting a computer to the serial port of the active controller on your EqualLogic SAN. You’ll need one of the serial cables that shipped with your SAN which is a standard 9 pin female to female serial cable. Read more [...]
You've loaded SP1 on your Windows Server 2008 R2 Hyper-V virtualization host server and you're ready to begin using Dynamic Memory for your virtualization guest machines (VM's). Listed below is the minimum amount of changes required for your virtualization guest machines (VM’s) to be able to use dynamic memory:
Set the VM to use Dynamic Memory by specifying a minimum and maximum amount of memory. The VM will need to be shutdown in order to change this setting and the settings will only Read more [...]
Question:
How many virtual processors (virtual CPU's) are officially supported by Microsoft for a guest virtual machine (VM) running on Hyper-V?
Answer:
You may be thinking the answer to this question is four since that is the number you can assign to any guest VM, but the answer like many others in IT is that it depends. It depends on what guest operating system you're running. Windows Server 2003, Windows Vista, and Windows XP SP3 all officially support a maximum of two virtualized processors Read more [...]