Month: December 2012

DotNetNuke Installation Guide

DotNetNuke is the Web Content Management Platform to build web sites and web application. Powered by the .NET development platform, DotNetNuke features powerful modules and interface making it stand apart from its CMS competitors.

This tutorial, being an introduction for establishing a DotNetNuke site, will take you through the important steps to get your site up and running.

This tutorial is for installation of DotNetNuke Community Edition.

For the purpose of introduction to DotNetNuke installation, the database instance used in the tutorial is SQL Server 2005 / 2008 / 2008R2 / 2012 Express with user instance database.

The operating system used to install is Windows Server 2008 R2.

Step 1: Requirements and Installation Media

The requirements for DotNetNuke are as follows:

  • Supported Operating Systems
    Windows XP
    Windows Server 2000
    Windows Server 2003
    Windows Vista
    Windows 7
    Windows 8
    Windows 2008
    Windows 2008 R2
  • Web Server
    Microsoft IIS 5.0, 5.1, 6.0, 7.0, 7.5, 8.0 
  • Database Server
    Microsoft SQL Server 2005
    Microsoft SQL Server 2008
    Microsoft SQL Server 2005 Express
    Microsoft SQL Server 2008 Express
    Microsoft SQL Server 2008 R2
    Microsoft SQL Server 2008 Express R2 
  • .NET Framework
    3.5 SP1
    4.0
    4.5 
  • Recommend Environment
    Windows Server 2008 R2
    IIS 7.5
    SQL Server 2008
    .NET Framework 3.5 SP1

Installation Media:

Obtain the installation media from the following link:

http://dotnetnuke.codeplex.com/releases/view/93277

In this tutorial, DotNetNuke 06.02.03 release is used.

Step 2: Prepare the DotNetNuke Environment.

    1. Once you’ve downloaded the latest stable release from the link provided above, extract the contents of the zip file to a folder on your computer.
    2. Create a directory in the C:\inetpub\wwwroot\ location named DNN.
    3. Copy the contents extracted from the package downloaded to this newly created directory.
    4. Right click on DNN directory; select properties. On the security tab, you’ll be presented with following screen.Ste2_4
    5. In this step, we will be adding the permissions for the appropriate user, in our case, as we are using Windows Server 2008 R2; we are required to add permissions for user “Network Service”.  Note: Windows XP uses the local ASPNET account, Win2003/Vista/2008/7 use the local Network Service account
    6. So, on the above screen, click on Edit. On the proceeding screen, click on Add. Now you will be able to see the following dialog box.Step2_6
    7. In the “Enter the object names to select:” field, type in “Network service”. Click on Check Names. You’ll be able to see Network Service underlined in the same field. This shows the user which you’ve entered is valid.
    8. Click Ok, you’ll be able to see the previous screen where Network Service will be listed under Groups or user names.
    9. Under permissions for NETWORK SERVICE, check select allow Full Control.
      Step2_9
    10. Click OK, also click OK on DNN properties screen! All OK!
    11. Now, it is time for the most crucial step in the DNN installation. IIS MANAGER!
    12. Click Start, goto Run.. And type in “inetmgr”.Step2_12
    13. You’ll be presented with a calm screen of IIS Manager.
    14. Expand Sites, you’ll be able to see the “Default Web Site”.Step2_14
    15. Expand it too!
      Step2_15
    16. Right click the directory, DNN. Select “Convert to Application”.
    17. Click OK on the dialog box that appears.
    18. Hooray! The necessary steps for preparing the environment are complete!

Let us move on to the next step where we’ll be installing the DotNetNuke.

Step 3: Installing DotNetNuke

 

  1. Browse to the site using http://localhost/DNN
  2. The following screen will be shown. Make sure under installation method, Typical is selected. Click Next to continue.Step3_2
  3. On the File Permissions screen, make sure you are able to see the following message-
    Your site passed the permissions check.
    Yes, you should be able to see it in green ONLY!
  4. Click Next to continue.
  5. Next Screen is the database connection configuration. We don’t have to do anything out here as the default option selected is SQL Express Database. Click Next.
  6. It will start building the database for your DNN site. It may take a while.
  7. When you’re able to see following screen, the installation of DotNetNuke site with database as SQL Express is DONE!!Step3_7
  8. Click Next to contiue.
  9. Next screen will let you set a host account for DNN site.
  10. Enter the password, a valid e-mail address to finish the installtion. Click Next to finish.

Your DNN site is created, the Getting Started screen is shown.

As described initially, this guide is for the DotNetNuke installation with SQL Server 2005 / 2008 / 2008R2 / 2012 Express with user instance database.

In the next edition of the DotNetNuke guide, I’ll be taking you through the DotNetNuke installation with SQL Server 2005 / 2008 / 2008R2 / 2012 or Express edition with attached database.

🙂 🙂  Happy New Year 2013 🙂 🙂  !!

 

Advertisements

SharePoint 2010 Timer Job For Sending Email Notification

Merry Christmas …. !!!

Every one are very familiar with SharePoint 2010 Timer Job. We just take a quick look over Timer Job. SharePoint handles some repetitive background process at some specific time is called ” Timer Job”.

Now the question is How the Timer Job will Help you ? OK, suppose you are a Project Manager and you want to remind your colleague to update your daily status. You just write a timer job that will send the email to your colleague for updating the daily status sheet.

Lets start with walk through ….. 🙂

  • Crate a SharePoint Custom list and Name it “CustomEmailNotifications” and Store the Email addresses in Title Column.
  • Open Visual Studio 2010 and create a new Empty SharePoint Project and name it “NewNotificationTimerJob“.
  • Add a new Class and call it “CustomEmailNotificationJob”.
  • Copy following code.

public class CustomEmailNotificationJob:SPJobDefinition
{
public const string JOB_NAME = “Custom Daily Status Notifications Job”;

public CustomEmailNotificationJob()
: base()
{
}

public CustomEmailNotificationJob(string jobName, SPService service, SPServer server, SPJobLockType targetType)
: base(jobName, service, server, targetType)
{
}

public CustomEmailNotificationJob(string jobName, SPWebApplication webApplication)
: base(jobName, webApplication, null, SPJobLockType.ContentDatabase)
{
this.Title = JOB_NAME;
}

public override void Execute(Guid contentDbId)
{

// Change your site
using (SPSite oSPsite = new SPSite(“http://abcd/”))
{
using (SPWeb oSPWeb = oSPsite.OpenWeb())
{
oSPWeb.AllowUnsafeUpdates = true;

// Fetch the List
SPList list = oSPWeb.Lists[“CustomEmailNotifications”];
SPListItemCollection collListItem = list.Items;
foreach (SPListItem oListItem in collListItem)
{
EmailUser(oListItem.Title);

}
}
}
}

private bool EmailUser(string emailAddress)
{
MailMessage mail = new MailMessage();

//change the Email address
mail.From = new MailAddress(“someone@mail.com”);
mail.To.Add(emailAddress);
mail.Subject = “Daily Status”;
mail.Body = “Please Update your Daily Status on Portal : “;

//Change to your SMTP server
SmtpClient smtp = new SmtpClient(“abc.com”);
smtp.Send(mail);
return true;
}
}

  • Next we need to add a Feature, so right-click the Features folder and add Feature
  • After adding the Feature, right-click it and Add Event Receiver
  • Copy the following code to the event receiver:

public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
SPSite site = properties.Feature.Parent as SPSite;
//remove the job if it already exists
foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
{
if (job.Name == CustomEmailNotificationJob.JOB_NAME)
job.Delete();
}

// create the job
CustomEmailNotificationJob emailJob = new CustomEmailNotificationJob(CustomEmailNotificationJob.JOB_NAME, site.WebApplication);
SPMinuteSchedule schedule = new SPMinuteSchedule();
schedule.BeginSecond = 0;
schedule.EndSecond = 59;
schedule.Interval = 5;
emailJob.Schedule = schedule;
emailJob.Update();
}

// Uncomment the method below to handle the event raised before a feature is deactivated.

public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
{
SPSite site = properties.Feature.Parent as SPSite;
foreach (SPJobDefinition job in site.WebApplication.JobDefinitions)
{
if (job.Name == CustomEmailNotificationJob.JOB_NAME)
job.Delete();
}
}

  • Now the last step is to set the scope of the feature to Site
  • Build the Project and Deploy.
  • Go to Central Admin — > Monitoring — >Timer Jobs — >Review job Definition .

Timerjob1

  • In the Review Job Definitions you can see your timer job.
  • Hope every thing is write you will receive notification.

Debug Your Timer Job

For debugging your timer job you can follow this link  ” http://msdn.microsoft.com/en-us/library/ff798310.aspx ”

Enjoy  ….. 🙂 🙂 🙂 !

Top Myths About Cloud Computing

Cloud computing has been a hot topic during the last few years for technology specialists all over the world. Cloud computing has been adopted by many enterprises, but still challenges continue to rise. With all the articles and documentation on this subject, there are many myths that have developed over time. So here are the most common myths regarding cloud computing: security, data loss and performance.

Security is compromised in the cloud

Without a doubt, this is the most talked about point. In order to be a successful service provider, cloud providers have to assure the customers or prospects that their data is secure. The security risks that exist in the cloud are no different than the ones that exist in-house. The greatest advantage when outsourcing to cloud is that providers are permanently focused on improving controls and procedures so that the data is always secure, while enterprises might neglect this focus from time to time. So one could argue that a risk could be to remain in a physical environment. Most cloud computing providers also offer the customer different levels of security protection, which allows for more enhanced security.

You lose control of data in the cloud

This is another common myth. Most people think that they will not be able to access their data whenever they need because they cannot see the actual physical drive’s that the data is being stored on. With the Cloud, the technology maintenance and support issues are in the hands of the cloud hosting provider, which means a high level of availability and data.  Data in cloud environments is segmented and encrypted and some providers also allow you to control how your data is stored, which would allow your data to be on a shared storage system or dedicated storage.  I have worked with these types of cloud systems and think that flexibility is the future of cloud management.

Performance is a problem in the cloud

It is easier to add additional resources in a cloud environment and if deployed correctly, those resources can be balance and enable you to achieve a higher level of performance and redundancy. The latest servers built for the cloud, like the Cisco UCS that I’m familiar with run on very high performance blades that most companies do not deploy in a physical environment which has allowed us to achieve much more performance over the same systems in a physical environment.  There could be some refactoring of your db’s and applications to take advantage of the cloud to receive the same benefits we have received above.

Creating Your First Yii Application

Hello everyone. In this tutorial we will be looking at setting up the Yii framework and create our skeleton app step by step. Lets begin.

Firstly, we need to download the Yii framework. This can be done from the Yii Framework website. When the download is complete, unzip the file and you will see a folder containing:

  • demos
  • framework
  • requirements
  • and some legal mumbo jumbo & other stuff

The only folder we are interested in is the framework folder. Copy this folder and go to your localhost. Paste the yii framework folder in a new folder where we are going to setup our application, in this tutorial we are using: localhost/yii-demo

Cool, Now open up your command prompt and navigate to the localhost/yii-demo/framework (e.g : c:\wamp\www\yii-demo\framework

Now type in:  yiic webapp c:\wamp/www/myFirstYiiApp This will ask you if you want to “Create we application under ‘C:\wamp\www\myFirstYiiApp’? [Yes:No]“
We do want to so type in “yes”. Some of you might get an error at this point saying something about php or something like that (great tutorial right?). That simply means you don’t have php setup as an environment variable.

To fix this:
“Open the Environment Variables window by going to: Start -> My Computer (right click!) -> Advanced Tab -> Environment Variables -> Click Path in System variables -> Edit.

In Windows 7, press the Win key and type “env”. You should see a control panel section with a shortcut to “Edit the system environment variables”. Select it and then click on “Environment Variables…”
Click on the variable called PATH and click “Edit…”. Do not delete the paths already there! Separate each path with semicolons.
Now you have to add the following PATHs in Windows: “C:\wamp\bin\php\php5.2.8″ and “C:\wamp\www\yii-demo\framework”. The former path should lead where your php.exe resides, and the latter where your yiic.bat resides.”
That bit is stolen from the Yii wiki page, thanks.
So we have type yes (or simply Y) and we should see a whole bunch of lines of stuff happening and the message “Your application has been created under C:\wamp\www\myFirstYiiApp ”. We have now created our skeleton app.
If you point your browser at localhost/myFirstYiiApp you should see the Yii skleton app. Well done, you have just installed Yii.

Some Basic Tips To Speed Up Your MySQL Queries

If you are interested in how to create fast MySqlqueries, this article is for you

1.    Use persistent connections to the database to avoid connection overhead.

2.    Check all tables have PRIMARY KEYs on columns with high cardinality (many rows match the key value). Well,`gender` column has low cardinality (selectivity), unique user id column has high one and is a good candidate to become a primary key.

3.    All references between different tables should usually be done with indices (which also means they must have identical data types so that joins based on the corresponding columns will be faster). Also check that fields that you often need to search in (appear frequently in WHERE, ORDER BY or GROUP BY clauses) have indices, but don’t add too many: the worst thing you can do is to add an index on every column of a table (I haven’t seen a table with more than 5 indices for a table, even 20-30 columns big). If you never refer to a column in comparisons, there’s no need to index it.

4.    Using simpler permissions when you issue GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements.

5.    Use less RAM per row by declaring columns only as large as they need to be to hold the values stored in them.

6.    Use leftmost index prefix — in MySQL you can define index on several columns so that left part of that index can be used a separate one so that you need less indices.

7.    When your index consists of many columns, why not to create a hash column which is short, reasonably unique, and indexed? Then your query will look like:

8.    Consider running ANALYZE TABLE (or myisamchk –analyze from command line) on a table after it has been loaded with data to help MySQL better optimize queries.

9.    Use CHAR type when possible (instead of VARCHAR, BLOB or TEXT) — when values of a column have constant length: MD5-hash (32 symbols), ICAO or IATA airport code (4 and 3 symbols), BIC bank code (3 symbols), etc. Data in CHAR columns can be found faster rather than in variable length data types columns.

10.    Don’t split a table if you just have too many columns. In accessing a row, the biggest performance hit is the disk seek needed to find the first byte of the row.

11.    A column must be declared as NOT NULL if it really is — thus you speed up table traversing a bit.

12.    If you usually retrieve rows in the same order like expr1, expr2, …, make ALTER TABLE … ORDER BY expr1, expr2, … to optimize the table.

13.    Don’t use PHP loop to fetch rows from database one by one just because you can — use IN instead

14.    Use column default value, and insert only those values that differs from the default. This reduces the query parsing time.

15.    Use INSERT DELAYED or INSERT LOW_PRIORITY (for MyISAM) to write to your change log table. Also, if it’s MyISAM, you can add DELAY_KEY_WRITE=1 option — this makes index updates faster because they are not flushed to disk until the table is closed.

16.    Think of storing users sessions data (or any other non-critical data) in MEMORY table — it’s very fast.

17.    For your web application, images and other binary assets should normally be stored as files. That is, store only a reference to the file rather than the file itself in the database.

18.    If you have to store big amounts of textual data, consider using BLOB column to contain compressed data (MySQL’s COMPRESS() seems to be slow, so gzipping at PHP side may help) and decompressing the contents at application server side. Anyway, it must be bench-marked.

19.    If you often need to calculate COUNT or SUM based on information from a lot of rows (articles rating, poll votes, user registrations count, etc.), it makes sense to create a separate table and update the counter in real time, which is much faster. If you need to collect statistics from huge log tables, take advantage of using a summary table instead of scanning the entire log table every time.

20.    Don’t use REPLACE (which is DELETE+INSERT and wastes ids): use INSERT … ON DUPLICATE KEY UPDATE instead (i.e. it’s INSERT + UPDATE if conflict takes place). The same technique can be used when you need first make a SELECT to find out if data is already in database, and then run either INSERT or UPDATE. Why to choose yourself — rely on database side.

21.    Tune MySQL caching: allocate enough memory for the buffer (e.g. SET GLOBAL query_cache_size = 1000000) and define query_cache_min_res_unit depending on average query resultset size.

22.    Divide complex queries into several simpler ones — they have more chances to be cached, so will be quicker.

23.    Group several similar INSERTs in one long INSERT with multiple Values lists to insert several rows at a time: query will be quicker due to fact that connection + sending + parsing a query takes 5-7 times of actual data insertion (depending on row size). If that is not possible, use START TRANSACTION and COMMIT, if your database is InnoDB, otherwise use LOCK TABLES — this benefits performance because the index buffer is flushed to disk only once, after all INSERT statements have completed; in this case unlock your tables each 1000 rows or so to allow other threads access to the table.

24.    When loading a table from a text file, use LOAD DATA INFILE (ormy tool for that), it’s 20-100 times faster.

25.    Log slow queries on your dev/beta environment and investigate them. This way you can catch queries which execution time is high, those that don’t use indexes, and also — slow administrative statements (like OPTIMIZE TABLE and ANALYZE TABLE)

26.    Tune your database server parameters: for example, increase buffers size.

27.    If you have lots of DELETEs in your application, or updates of dynamic format rows (if you have VARCHAR, BLOB or TEXT column, the row has dynamic format) of your MyISAM table to a longer total length (which may split the row), schedule running OptimizeTABLE query every weekend by crone. Thus you make the defragmentation, which means more speed of queries. If you don’t use replication, add LOCAL keyword to make it faster.

28.    Don’t use ORDER BY RAND() to fetch several random rows. Fetch 10-20 entries (last by time added   or  ID) and make array_random() on PHP side. There are also other solutions.

29.    Consider avoiding using of HAVING clause — it’s rather slow.

30.    In most cases, a DISTINCT clause can be considered as a special case of GROUP BY; so the optimizations applicable to GROUP BY queries can be also applied to queries with a DISTINCT clause. Also, if you use DISTINCT, try to use LIMIT (MySQL stops as soon as it finds row_count unique rows) and avoid ORDER BY (it requires a temporary table in many cases).

31.    When I read “Building scalable web sites”, I found that it worth sometimes to de-normalise some tables (Flickr does this), i.e. duplicate some data in several tables to avoid JOINs which are expensive. You can support data integrity with foreign keys or triggers.

32.    If you want to test a specific MySQL function or expression, use Benchmark function to do that.

Cascading Drop Down List In SharePoint 2010

SharePoint 2010 has provided lot of things Out-of-box and it’s just a matter of configuration.But some times we don’t know how to achieve that functionality. Today We will discuss Cascading  Drop down List in SharePoint 2010.

Result

As we know InfoPath as a Microsoft Office product features a different usage-scenario from the other Office applications, such as Word and Excel. In order to use InfoPath to fill in a form, a user must have a designer develop an InfoPath template first.

All the data stored in InfoPath forms are stored in an XML format, which is referred to as the “data source”.

InfoPath provides several controls and For each controls, actions (called “rules”) can be bound in. A rule defines a specific action that will be performed under certain conditions.  So we will Achieve our goal using Infopath forms.

So will follows following steps :-

  • Create a Custom list called ‘states’.
  • Add States to the list: Maharashtra, Uttar Pradesh, Rajasthan, Gujrat etc..

statelist

  • Create another list for Cities and called ‘cities’.
  • Go to the list settings of ‘cities’ and click on ‘create column’. Create a Lookup column called ‘State’. with following information. Get information from: ‘states’,  in this column: ‘Title’

list_Column

list_

  • Add some cities to this list. I created multiple cities at each location.

Newitem

citieslist

We have need to create one more Custom List where we apply this …

  • create a new Custom list called ‘MyHomeTown’.
  • Click on ‘Create column’ and create a Lookup column called ‘State’. Get information from: ‘states’,  in this column: ‘Title (as earlier screenshot )
  • Repeat above step, for create a Lookup column called ‘City’. Get information from: ‘cities’,  in this column: ‘Title’

citylookup

citylookup_settings

  • Open the list settings for ‘MyHomeTown’ and click on ‘Form settings’.
    You will see a label with the text ‘Customize the current form using Microsoft InfoPath’. Click OK.

formsetting

customize the current form

  • The MyHomeTown form will now be opened in InfoPath 2010.

infopath

  • Right click on the State field, and select properties.
    Select ‘Get choices from an external data source’ and click ‘Add…’.
    Create a connection with the following settings:-

ControlProperties

stateInfopath_PropSetting

1. New connection, receive data

CreateNewConnection

2. Receive data from: SharePoint library or list

SourceOfData

3. select ‘states’ library

statesLib

4. select the ‘id’ and ‘title’ column.

AddIdAndTitle

5. Do not check the box for making a copy of the data.

StoreACopyOfData

6.check the box that asks for automatically retrieving data when the form is opened. Save the external data source as ‘states1′

AutomaticalltRetrieve

  • At value, choose ‘ID’ and at display name, choose ‘Title.
  • Right click on the City field, and select properties.
    Select ‘Get choices from an external data source’ and click ‘Add…’.
    Create a connection with the following settings:

1. New connection, receive data

CitiesInfopathProperties

2. Receive data from: SharePoint library or list

SourceOfData

3. select ‘cities’ library

citieslib

4. select the ‘id’, ‘title’ and ‘State’ column.

titleIdState

5. Do not check the box for making a copy of the data in the form Template.

StoreACopyOfData

6. do not check the box that asks for automatically retrieving data when the form is opened. Save the external data source as ‘cities1′

AutomaticalltRetrievecities

  • At value choose ‘id’, choose ‘Title’ for  the display name.

cities1

We have almost Done, just few steps are remaining here. 🙂 🙂

  • Click on the xPath button at the properties dialog of Room next to ‘Entries’.Click on the ‘Filter data’ button.

Xpath

FirstPopup

  • Click on ‘Add’.

Addfilter

1. In the first column, choose ‘select a field or group’.

Selectfieldgroup

2. A window pops up .Select the ‘main’ datasource, click on ‘dataFields’ and select ‘State’

main

3. In the second column, choose ‘equals to’.

4. In the third column, choose ‘select a field or group’. Again a window pops up,

thiredField

5. Select the ‘rooms’ datasource, click on ‘dataFields’ and select ‘State’.Click OK .

thirdfield1

thirdfinal

6. The filter will now look like ‘State equals State’. Now close all property dialogs.

filterconnection

  • Select the State column and click on ‘Add Rule’. Select the query action when the field is changed

Addrule

addrule1

  • Now choose the data connection ‘cities1′ and click OK.

ruledetails

  • Again, click State and make a new rule: When the field is being changed, set a value for a field.

setfieldvalue

  • Choose field ‘City’ and leave value empty.

roomdetails1

Finally! We are done. Fast publish the form to SharePoint again by pressing ctrl+shift+Q. Now if you carefully executed all steps above, you will see a form like this:

final

final1

Ting ting Titing  🙂 🙂 🙂

 

SharePoint 2010 Enterprise Single Server farm Installation

PM_logoSmall

Before starting actual steps, we would like to understand few basic concepts. So What is farm? Farm is group of Co-related, interdependent still isolated Applications.

Farm can be deployed as

  1. Multi-Server Farm: in which different servers have different roles, like someone has web Server Role, Application Server Role and Database server Role.
  2. Single server farm: In this all above Roles are assigned to Single Server. All of Above roles Played by Single Server. In single server farm we can add more servers later.
  3. Stand-Alone farm cannot add another Server in future.

Today we will see how to setup single server farm.

Minimum Hardware Requirements For Single server farm:-

  1. 64 bit processor.
  2. 8 GB for production use in a single server or multiple server farm .For test Installation we can use 4 GB RAM.

Software Requirements For Single server farm:-

  1. Windows Server 2008 or 2008 R2 (64 bit).
  2. The 64-bit edition of Microsoft SQL Server 2008 R2.We can also use SQL Server 2008.
  3. Service packs 2 update. Now we can use Service pack 1 for SQL Server 2008.
  4. Or Microsoft SQL Server Enterprise 2005 64 bit with latest service pack and cumulative updates.
  5. Cumulative update package 2 for SQL Server 2008 Service Pack 1.
  6. Microsoft SharePoint Server 2010 Enterprise Installer.

For more details on pre-requisites and proper planning refer http://technet.microsoft.com/en-us/library/cc262485.aspx

Security Requirements For Single server farm:-

  • Active directory domain controller (AD/DC) must install on server to create and Assign roles to user.
  • Create A three Account in Active Directory users and Computers as given below:-

                      1Installation User:- srv-sp-setup
                      2.  SQL User :- srv-sp-sql
                      3.  Farm Admin :- srv-sp-farm

  • Give the Domain Admins and Local Administrator rights to these three accounts.
  • To install SQL server 2008, login with srv-sp-sql Account.
  • Assign the “Dbcreator”, public and “Securityadmin” roles to “srv-sp-setup” and “srv-sp -sql “in Sql server.
  • To install Microsoft SharePoint 2010, Login with Srv-sp-setup Account.
  • SharePoint 2010 server Configuration wizard should run with srv-sp-farm account.

There are Few Simple Steps Afterword we are able to install single server farm easily. Follow the following steps:

  • Double click on SharepointServer.exe .it extract all files

SingleServerfarm1

  • Firstly install all the prerequisites as shown below, for that you require Internet Connection on your server. If you don’t have internet connection on same server .then Download SharePoint 2010 Prerequisites to other machine where Internet connection is available and put that prerequisite on shared location and Access it. Following are prerequisites which should be downloaded offline if direct internet connection is not available.
  1. 1. Application server role. Web server (IIS) Role.
    2. Microsoft SQL server 2008 Native Client.
    3. Hotfix for Microsoft Windows(KB976462)
    4. Windows identity foundation(KB974405)
    5. Microsoft Sync Framework Runtime v1.0(x64)
    6. Microsoft chart control for Microsoft .Net framework 3.5
    7. Microsoft filter pack 2.0
    8. Microsoft SQL server 2008 Analysis services ADOMD.NET
    9. Microsoft server speech platform runtime (x64).
    10.Microsoft server speech recognition language- TELE(en-US)
    11. SQL 2008 R2 Reporting Services SharePoint 2010 Add- ins.
  • Now here we have Internet Connection, Click on prerequisites.

SingleServerfarm2

  • After clicking on Prerequisite Welcome screen comes and in below there is a box in which you can see list of prerequisites.

SingleServerfarm3

  • Click Next. License Agreement Screen Appears .click on the check box and accept the terms and condition. Then click next.

SingleServerfarm4

  • After clicking next prerequisite installation begins. It will take few minutes

SingleServerfarm5

SingleServerfarm6

  • After Few minutes installation is complete click on finish button.

SingleServerfarm7

  • Now we are going to SharePoint Single server installation. Click on Install SharePoint Server.

SingleServerfarm8

  • After clicking on Install SharePoint Server Product key window appear, insert your product key. Then continue.

SingleServerfarm9

  • Read the Microsoft Software license term, then click continues.

SingleServerfarm10

  • After click on continue button next screen comes here you can select Standalone or Server Farm. Now we are looking for Single server farm Installation .So we are Clicking on Server farm Option.

SingleServerfarm11

  • After clicking on server farm. Next screen provide option to choose server type, complete or Stand-alone .Now we are clicking on complete and then click on Install Now.

SingleServerfarm12

  • Now your Installation is start.

SingleServerfarm13

SingleServerfarm14

SingleServerfarm15

  • Now click on the close button, but before ensure the check button is check .so the configuration wizard runs automatically.

SingleServerfarm16

  • After click on the close button SharePoint Configuration Wizard runs automatically .Click on next Button.

SingleServerfarm17

  • After clicking on next button one pop Window comes click on yes.

SingleServerfarm18

  • After Clicking on yes, Next screen provides the option to choose an existing server farm or create a new server farm. Because we are installing single server farm so there is no existing farm. Let’s choose create a new server farm and click next.

SingleServerfarm19

  • Then in the next screen we can set our database with SharePoint 2010 server, here we can give the Database name and domain user name and password. You can change your database name to more secure your database because it is default database name any one can access your database .Now we can go for default database name because it is our demo configuration. Username is our domain Administrator it does not require any specific permission. Through this account we can manage the central Administrator of SharePoint farm. Take a screenshot of this screen for future use. After putting all information click next.

SingleServerfarm20

  • After clicking next. Next screen for security setting, here we give passphrase, it used when we add another server in the farm. It must be strong means combination of alphabet, numbers and special character and minimum 8 characters required. Then click next.

SingleServerfarm21

SingleServerfarm22

  • After clicking next .another screen appears here we can set the port number for SharePoint Central Administration or we can choose default port number. It looks like a http://databaseserver name: port number/ .Once you choose the port number we cannot further change it. Here we can go for default port number .and we can also set the Authentication provider NTLM or kerberos .generally we are choosing NTLM. Then click on next.

SingleServerfarm23

  • Next screen shows the summary what we have taken. Take the screenshot of this screen for further use .this us best practices. Click next.

SingleServerfarm24

  • After clicking next our configuration is start.

SingleServerfarm25

SingleServerfarm26

SingleServerfarm27

  • Click on finish to close configuration wizard.

SingleServerfarm28

  • After closing SharePoint configuration wizard new window is pop for configuring SharePoint farm, click on start the Wizard.

SingleServerfarm29

  • In the next screen you can choose an account from which you manage all the services. By default there are 14 services available .you can un-check the services which you don’t run from this account. Then click next. Generally Managed Metadata Service, Search service application, User profile service applications are minimum recommended which should be selected.

SingleServerfarm30

  • In the next screen we can choose any template to create a top level site .now we can choose team site for it. Then click ok.

SingleServerfarm31

  • Next screen shows completion of farm configuration wizard. Click on finish. Now your central Administration is appear .

SingleServerfarm32

SingleServerfarm33

  • To see our site we are going to Application management—>manage web Application

SingleServerfarm34

  • Copy The URL And open in to new Tab.

SingleServerfarm35

SingleServerfarm36

  • Now Our SharePoint Site Is Up and Running.

SingleServerfarm37

Done  …. 🙂 🙂 🙂  Enjoy ….:)