Minneapolis computer support page

This document is designed for Advance users who want to intall SharePoint on Windows Server 2008 R2 test machine. SharePoint server also require that you install MS SQL Server 2008 or SQL Express. In this documentation I will go over MS SQL Server 2008 R2 Express installation and configuration for SharePoint Server. In my opnion I would not suggest you to install sharepoint server with MS exchange server. SharePoint overides exchange settings. You can configure port settings in the IIS, but not sure how reliable exchange would be. Download MS SQL Express 

First, login into Windows Server 2008 R2 as Administrator. It is good idea to get MS updates before you start. 

MS SQL Express installation:
Click New installation
Accept license
Select all features below

Name your instance. Be sure your write it down your instance name. See figure 3

In figure 4, I suggest that you select “NT AUTHORITY\SYSTEM” under SQL Server Database Engine account name.

Select “Windows authentication mode” as shown in figure 5. Make sure you have added current user(Administrator) by clicking “Add Current User”

There are no needs to send SQL Error Reports to Microsoft on test enviornment.

Click Next
Now you should see Installation Progress. This process may take around 7 minutes or more. If you get error during the installation then I suggest that you search on Internet and get it resolve.

Click Close
Close “SQL Server Installation Center”
Click Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio
You should see figure 8. Pay attention to this screen. Your Server name may showup empty filed or local.

MS SQL Server Management Studio

WIN9 is my computer name and SQLEXPRESS is my instance name. See your notes on figure 3. Set your Server type and Authentication like mine. 

Click Connect

Right click on Database and name “sharepoint” database. See figure 9

MS SQL Express Server database

Click OK
Expend Databases and you should be able to see your database 

Shrepoint installation:
Start installation
Install Software prerequisites
Install SharePoint Server
Enter Serial number
Click continue
Accept licence
Click Install Now
Run the SharePoint configuration
Click Next
Click Yes to reset services according sharepoint configuration
Create a new server farm
Fill in required information. See figure 11 below.

Set SharePoint Passphrase. Keep Passphrase long and hard to guess.
Click Next
See figure 13 for port number and security settings

Click Next
Varify all the information on figure 14 and make a note

Click Next.
If your configuration failed start over configuration and varify you have correct database information.

Click Start > All Programs > MS SharePoint 2010 and start SharePoint configuration.
Click Finish. See figure 15

Type Administration and Passphrase that you created earlier
You are all set to go 

If you get above error message during sharepoint installation, do not panic. All you have to do is start SQL Server Management Studio > extend databases > Right click your database (sharepoint) > Select Properties  > Options > You know what to look for

You may notice when you purchase new computer or install new Internet Explorer, you don’t see Menu bar. Menu bar is where File, Edit, view and other options available for you to use. Here in this post i will show you how get to your menu bar.

Press ALT button on your keyboard and you will see is your menu bar. Second option would be pressing right click on white/gray area below the address bar and select Menu bar. See figure below. I would recommend you that you use second option so that you don’t have to suffer from printing and bookmarking from important site.

Menu Bar

What is Windows PE?

Windows Pre Installation Environment (Windows PE) is a stripped down version of Windows XP/Vista kernel capable of running from boot CD-ROMs/USB. It is used to prepare a computer for Windows installation, to copy disk images from a network file server, to initiate Windows Setup, computer maintenance.

Windows PE is not designed to be the primary operating system on a computer, but is instead used as a standalone pre installation environment and as an integral component of other setup and recovery technologies, such as Setup for Windows Vista/7, Windows Deployment Services (Windows DS), the Systems Management Server (SMS) Operating System (OS) Deployment Feature Pack, and the Windows Recovery Environment (Windows RE) or simply capture computer image for deployment and backup.
You may contact me and i will create you WinPE Boot CD/DVD/USB for minimal price.

Hello friends, here I have put together some windows 7 commands to help you better with computing. These commands you will insert into your “Search programs and Files” and some into command prompts.

Divice Manager
hdwwiz.cpl or devmgmt.msc

Add/Remove Programs
appwiz.cpl

Calculator
calc

Certificate Manager
certmgr.msc

Character Map
charmap

Check Disk Utility
chkdsk

Command Prompt
cmd

Component Services
dcomcnfg

Computer Management
compmgmt.msc

Date and Time Properties
timedate.cpl

Direct X Control Panel (If Installed)*
directx.cpl

Direct X Troubleshooter
dxdiag
Disk Defragment
dfrg.msc

Disk Management
diskmgmt.msc

Disk Partition Manager
diskpart

Display Properties
control desktop

Display Properties
desk.cpl

Display Properties (w/Appearance Tab Preselected)
control color

Dr. Watson System Troubleshooting Utility
drwtsn32

Driver Verifier Utility
verifier

Event Viewer
eventvwr.msc

File Signature Verification Tool
sigverif

Findfast
findfast.cpl

Folders Properties
control folders

Fonts
control fonts

Fonts Folder
fonts

Free Cell Card Game
freecell

Game Controllers
joy.cpl

Group Policy Editor (XP Prof)
gpedit.msc

Hearts Card Game
mshearts

Iexpress Wizard
iexpress

Indexing Service
ciadv.msc

Internet Properties
inetcpl.cpl
IP Configuration (Display Connection Configuration)
ipconfig /all

IP Configuration (Display DNS Cache Contents)
ipconfig /displaydns

IP Configuration (Delete DNS Cache Contents)
ipconfig /flushdns

IP Configuration (Release All Connections)
ipconfig /release

IP Configuration (Renew All Connections)
ipconfig /renew

1. Store toners in proper place
2. Handle toner cartridge carefully
3. Use appropriate peper type and size
4. Keep your printer clean and serviced
5. Use test page for color densities and quality
6. Run “Full Calibration” after changing a toner cartridge
7. Adjust color densities if needed
8. Use PQ (Power Quality) Troubleshooting
9. Use proper print drivers and firmware updates
10. Visit printer manufacture site for additional issues