Archive for May, 2010

SharePoint 2010 Virtual Machine (VM) – Installing SQL Server 2008 – 3/4

When clicked on the setup, “Program Capability Assistant” window will appear informing that you must apply SP1 or later before running this program. Click “Run Program”.

“SQL Server Installation Centre” window will appear. Click on “Installation”

Select “New SQL Server Stand-alone installation or add features to an existing installation”

“Set Support Rules” window will run and you can check the results by clicking on “Show details”

“Product Key” window will appear, enter the key and click “Next”

“License Terms” will be confirmed. Accept it.

Setup Support files will be installed

“Setup Support Rules” confirmation window will appear. Click “Next”

“Feature Selection” window will appear. Select

Database Engine Service with Full-Text Search

Reporting Services

Business Intelligence Development studio and

Management Tools

“Instance Configuration” will appear, recommends leaving it default

“Disk Space Requirements” will be check

Enter the account login and password to be used for services

Enter SQL Server Administrator login

“Install but do not configure the report server” option should be checked

Not interested in sending errors to Microsoft

Installation rules will be checked

“Ready to Install” screen with all the configuration appear

“Installation Progress” will be displayed

Installation completed with success


Install Service Pack 1

Download and install Service Pack 1 from following URL:

Please do verify that this is the latest service pack.








Install CU 2 for SQL Server 2008 Service Pack 1

Download and install, cumulative update package 2 for SQL Server 2008 Service Pack 1 from following URL:




Leave a Comment

SharePoint 2010 Virtual Machine (VM) – Installing Windows Server 2008 R2 – 2/4

We can select “Standard” and “Enterprise” flavor of Windows Server 2008 R2. Typically, “Standard” should be selected for developer VM.

Windows Server 2008 R2 installation will be started.

After the success full installation of Windows Server 2008 R2, “Initial Configuration Task” and “Server Manager” windows will appear, close these windows. The first step is to disable “Internet Explorer Enhanced Security Configuration”.

1 Disable Internet Explorer Enhanced Security Configuration

“Administrative Tools” -> “Server Manager” -> “Configure IE ESC” (Security Information Area) -> Select “Off” for Administrators as well as users.



2 Activate Windows

Next step is to activate windows, type “Oobe.exe” in Run. “Initial Configuration Task” window will appear. Select “Activate Windows”, a new window will appear, enter key and click “Next”. This may take few minutes and prompted by “Activation was successful” message.




3 Change Machine Name

On “Initial Configuration Task” window, click on “Provide Computer Name and domain”. Click on “Change”, enter name of the machine and domain and click “OK”




4 Update Machine

On “Initial Configuration Task” window, select “Download and install Update”. “Windows Update” window will appear. Click on “Turn on automatic Updates”. Windows will search for update and bring updates needs to be installed. Click on “Install Update”, it will ask for license. Accept license and updated will be installed on your machine.





5 Server Role and Role Services

Click on “Add Roles” in “Initial Configuration Task”. “Add Roles Wizard” will appear. Click “Next” and select “Application Server”. A pop up window will appear requesting for “Add features required for Application Server”, click “Add Required Features”. Click “Next” and you will reach “Select Role Services” window.




On “Role Services” window, select

Net Framework 3.5.1

Web Server (IIS) Support

TCP Port Sharing

HTTP Activation

Named Pipe Activation

This will ask for “Add Features”. Click on Add “Required Features”.

Click “Next” and “Web Server IIS” window will appear. Click “Next” and “Role Services Window for IIS” will appear. Let the default options checked and click “Next”. A summary will appear, click “Install”.





Leave a Comment

SharePoint 2010 Virtual Machine (VM) – Creating a VM – 1/4

We will be using VMware WorkStation 7.0.1. You can download it from

After installing VMware on your machine, click on “New Virtual Machine”

This will open “New Virtual Machine Wizard”. Select “Typical (recommended)” and click “Next”

Select the path of “Windows Server 2008 R2” ISO image and click “Next”

No need to provide “Windows Product Key” and “Password”

This will generate a warning, click “Yes”. Enter the name of VM and location of the VM

Leave “Disk Capacity Settings” as it is

Setting of the VM will be confirmed.

You can change the RAM size by clicking on “Customize Hardware”

Click “OK” and “Finish”. This will take to installation set up of Windows Server 2008 R2

Leave a Comment

SharePoint 2010 Virtual Machine (VM) – 0/4

Our goal is to create a VM running Windows Server 2008 R2, SQL Server 2008 and SharePoint 2010. We will start by:

Comments (2)

SharePoint 2010: Compare SharePoint Editions

Microsoft has provided detailed list of components available in different editions: Foundation, Standard and Enterprise. Also, one can filter components on the bases of Sites, Communities, Content, Search, Insights, Composites and All.

Leave a Comment

SMTP: Sent Mail – Unable to connect to the remote server —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it


We were unable to send email using SMTP client. Every time we tried, our event viewer has following entry:


Event Type:    Error

Event Source:    XXXXX

Event Category:None

Event ID:    0

Date:        XXXXXX

Time:        XXXXXX

User:        N/A

Computer:    XXXXXX


Mail Send:error sending email Failure sending mail. at System.Net.Mail.SmtpClient.Send(MailMessage message)

at Mail.Send(String from, String to, String subject, String body, Boolean sendAsHTML) in XXXXXXXXX:line 675 System.Net.WebException: Unable to connect to the remote server —> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)

at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)

at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)

— End of inner exception stack trace —

at System.Net.ServicePoint.GetConnection(PooledStream PooledStream, Object owner, Boolean async, IPAddress& address, Socket& abortSocket, Socket& abortSocket6, Int32 timeout)

at System.Net.PooledStream.Activate(Object owningObject, Boolean async, Int32 timeout, GeneralAsyncDelegate asyncCallback)

at System.Net.PooledStream.Activate(Object owningObject, GeneralAsyncDelegate asyncCallback)

at System.Net.ConnectionPool.GetConnection(Object owningObject, GeneralAsyncDelegate asyncCallback, Int32 creationTimeout)

at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port)

at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port)

at System.Net.Mail.SmtpClient.GetConnection()

at System.Net.Mail.SmtpClient.Send(MailMessage message)

For more information, see Help and Support Center at



McAfee OAS is running on our system and blocks all email. Add exe in the allow list of McAfee.

Virus Scan Console -> Access Protection -> Prevent mass mailing worms from sending mail -> Edit -> Add exe in (Process to exclude list)

You can verify it by checking the logs

Virus Scan Console -> Task -> View Logs

Comments (8)

SharePoint Q&A with the MVP Experts: May 25 & May 26, 2010

Microsoft schedule to two chat session with the MVP Experts for SharePoint on May 25 and May 26, 2010.

For reminders:

To join:


Leave a Comment

SharePoint 2010: SharePoint 2010 Developer Training Material

Leave a Comment

SharePoint Object Model: ListItem Reference in ItemAdding Event Handler

void ItemAdding(SPItemEventProperties properties)


SPSite spSite = new

SPWeb webSite = spSite.OpenWeb();

SPList spList = webSite.Lists[properties.ListId];

SPListItem listItem = spList.Items[spList.Items.Count – 1];



Leave a Comment