SharePoint 2010 Tutorial Free - SharePoint 2010 Architecture

     It has 4 layers

    1) SharePoint Sever 2010(Enterprise/Standard)
    2) SharePoint Foundation 2010
    3) SQL Server 2008,IIS 7.0 and .Net 3.5 Framework
    4) Windows server  2008(64bit)

Considering that you have just started learning SharePoint,trust me even if you know this you have started very well.Cheers !

So normally when I go for interviews in companies ,I just draw 4 storey building and name each block as mentioned when asked to define the architecture of SharePoint 2010

And as you learn SharePoint,eventually you will come to know what each layer contains.

      

      Reference : http://msdn.microsoft.com/en-us/library/office/ee557253(v=office.14).aspx

      For more information free tutorial for beginners on SharePoint. Please refer other posts on my       blog. 

SharePoint 2010 Tutorial Free - What is SharePoint ?

Microsoft SharePoint 2010 is a Web-based platform that provides  enterprise-scale capabilities to meet business-critical needs such as managing content and business processes, simplifying how people find and share information across boundaries, and enabling informed decision

SharePoint enables their users to create, manage, and easily build SharePoint sites.

SharePoint helps teams stay connected and productive by providing easy access to the people, documents, and information that can help in decision making and getting work done.

Reference : http://msdn.microsoft.com/en-us/library/office/dd776256(v=office.12).aspx

For more information free tutorial for beginners on SharePoint. Please refer other posts on my blog. 

Cannot open database "SharePoint_Config" requested by the login. the login failed error

error - Cannot open database "SharePoint_Config" requested by the login. the login failed

After re-installing MSQL 2012,I tried to connect the Central Admin which gave the following error :

So I ran… SharePoint 2010 Products Configuration Wizard  

I got this error while I was trying to run SharePoint 2010 Products Configuration Wizard.

Resolution :

1)      Run this command : PSConfig -cmd configdb –disconnect

2)      Make sure the account that you are using has following roles assigned in SQL  

Dbcreator , public and securityadmin roles

Go to SQL -> Security -> Logins -> UserAccount -> Right Click -> Properties -> Server Roles -> Check -> Assign the Dbcreator , public and securityadmin roles - OK

3)      open regedit (from run command) ,Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

4)      Run SharePoint 2010 Products Configuration Wizard and Re-create new farm

Creating new farm will take sometime,so have some patience ;)

Well I am not sure if Step 1 & 2 are required but I am just letting you know the drill that I followed

Additionally Tips :

·         Make sure all the SQL services are running with the account that you are using to install Sharepoint.

·         Also make sure the Sharepoint timer services are running.

·         Checking the error in Event viewer can also help, you can then google the error.

References :

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

http://technet.microsoft.com/en-us/library/ee662513(office.14).aspx

Hope this helps !

Error - Cannot connect to configuration database

Cannot connect to configuration database - Error

After re-installing MSQL 2012,I tried to connect the Central Admin which gave the following error :

So I ran… SharePoint 2010 Products Configuration Wizard  

I got this error while I was trying to run SharePoint 2010 Products Configuration Wizard.

Resolution :

1)      Run this command : PSConfig -cmd configdb –disconnect

2)      Make sure the account that you are using has following roles assigned in SQL  

Dbcreator , public and securityadmin roles

Go to SQL -> Security -> Logins -> UserAccount -> Right Click -> Properties -> Server Roles -> Check -> Assign the Dbcreator , public and securityadmin roles - OK

3)      open regedit (from run command) ,Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

4)      Run SharePoint 2010 Products Configuration Wizard and Re-create new farm

Creating new farm will take sometime,so have some patience ;)

Well I am not sure if Step 1 & 2 are required but I am just letting you know the drill that I followed

Additionally Tips :

·         Make sure all the SQL services are running with the account that you are using to install Sharepoint.

·         Also make sure the Sharepoint timer services are running.

·         Checking the error in Event viewer can also help, you can then google the error.

References :

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

http://technet.microsoft.com/en-us/library/ee662513(office.14).aspx

or simple process would be

Please follow a general practise when your SharePoint Central Admin does not work make sure

1)    Go to run->Services.msc à SharePoint timer services are running()

2)    Go to run->Services.msc à SQL(SharePoint)  service is running

3)    Go to IIS àIn application pool – make sure Central Admin  v4 application is started

In my case the application pool wasn’t working, so I started the Central Admin v4 application pool

And TaDa ! My central admin starts working J

Hope this helps !

add content db to sharepoint 2010

You can add an existing content dB to an existing site collection

Once this activity is done, SharePoint creates the Url buy default and you can just navigate to the Url and check if the content dB has all the data and verify is this was successfully done.

  

Adding content dB to site collection:

1)      Go to central Administration

2)      Application Management

3)      Databases à Manage content database à Add a content database

4)      Check Database server name(this would populate automatically, just verify)

5)      And give Database name – this would also populate or have a name by default BUT we need to CHANGE this

the Database name has to be a name of an existing DB which you want to add to the site collection.

You really don’t have to worry about all the other default options

6)      Select Windows Authentication if not selected.

7)      No other changes.

8)      OK

9)      It will show the database in Add a content database screen.

Check Point

1) Go to Central Admin à Application Management.

2) Site Collections à View all site collections

3) This will take you to a screen where you can see the Url of your site collection corresponding to the DB that you attached to the site collection.

Make sure you select the correct Url of your site collection

4) Click on the Url to see other details

5) Browse the url/_layouts/settings.aspx to see the data in the DB.

In my case it is  à http://myserver01:9999/sites/Team/_layouts/settings.aspx