Timer Cache Clear in SharePoint.

This post will help you on how to clear timer cache in SharePoint servers.

So lets get started :)

First of all,why we need to clear timer cache? there can be n number of reason to do it,sometimes an event id 6398 is logged in Application log which is due to configuration cache being outdated.So we required timer cache clearance.
There are other reason also and some common issue which requires timer cache clearance.

The path of configuration cache can vary in reagards to window server 2003,2008 or 2012.

We are performing clearnace on server 2012 below is my config path location and for 2008 it will be same.
"C:\ProgramData\Microsoft\SharePoint\Config\GUID"

Below are steps to for  Timer Cache/Configuration cache clearing.

1. We have to stop the timer serivce, Ctrl + R type services.msc hit enter.
2. Select SharePoint Timer Service and Stop it.

3. Once it is stopped,Go to the Config location mentioned above.
4.Backup the Cache.ini file. (DO NOT DELETE CACHE.INI) best way to avoid deletion of cache.ini is to open it.
5.Delete all the XML configuration files in GUID folder.Also note down the count of the XML files.

 6.After deletion of XML file open cache.ini.Select all and replace it by 1.Save and Close

7.Now we have to start the services.Go to Services.msc --->SharePoint timer service-->Start.
8.Once timer service get started it.XML will get auto generated.

9. Most of the time it will auto generate same number XML file which were deleted.One or two less do not worry.

10. Perform above steps on the SharePoint server in your Farm.

Login Falied : The Login is from an untrsuted domain for SQL Error.

Today, i followed Microsoft article to create it a SQL alias.

After creating an SQL alias in SQL configuration manager.

When i opened  SSMS and try to login with New SQL Alias name got hit by below error.

I got above error if authentication is Windows but if a changed to SQL server authentication was able to connect the new SQL Alias without any issue


Troubleshooting:-

1. Ping the new SQL Alias name was getting response.

2. Checked the DNS entry.

3. Checked for error in event viewer and found " SSPI handshaked Failed" in application log

Solution:-

DisableLoopBackCheck

We have to create Disable loop back check in registry editor.

Powershell to create it.

New-ItemProperty HKLM:\System\CurrentControlSet\Control\Lsa -Name "DisableLoopbackCheck" -Value "1" -PropertyType dword

We can created it manaully by following below steps:-

1. Ctrl + R type Regedit hit enter.

2.EXPAND "HKEY_LOCAL_MACHINE \SYSTEM\CONTROLSET001\CONTROL\LSA"

3. Right Click on LSA, New and click DWORD32.

4. Give name to it DisableLoopbackCheck, modify the value to 1.

After this i was able to login with New SQL Alias using windows authentication.

Happy SharePointing :)

Creating a Site Collection in SharePoint 2013

This post is for creating a site collection in SharePoint.

So lets get started :)

1. Open Central Admin--> Application management-->Create site collections

 2. Select the Web Application under which you have to create site collection.

3. Change the URL if you want.Select the Template as per your requirement.

4. Enter the name of Primary and secondary site collection administrator.( Primary is mandatory).Click OK

5. Wait while your site collection getting created.

6. Site Collection is created.Click OK

7. You can also click URL to browse it.

Your site collection has been created.

Happy SharePointing :)

Creating Web Application in SharePoint 2013

This post will help you out with Web Application creation in SharePoint.

So lets get started :)


1. Open Central Admin--> Application management--> Manage web application.

2.Click New.

3. Enter value in the field accordingly.As this is a new web application,you will create a new IIS web site,keep allow anonymous access as No.

4. Select Enable Windows Authentication and Integrated Windows Authentication (NTLM).

5. Change URL , Change the name of Application pool and managed account if you want.

 6. Change DB name and mention Fail-over Database server if you have any.

 

7.  Click OK and wait while your web application is getting created.Click OK

8. Web Application is created but if you try to browse the Web application.You will get an error.

9.You are getting the above error because didn't create a root site collection it is mandatory to create one after you create a Web application.


In my next post we will go thru on how to create site collection.

Happy SharePointing :)

Configuration of SharePoint 2013

This post is related to configure your newly install SharePoint 2013.

So lets get started :)

1. Open SharePoint 2013 Product Configuration wizard.

2. Click next and yes.

3. Select Create a new server farm and click Next

4. Enter the Database server name and credentials.

5. Enter Passphare. Click Next (Make sure your save this password because this password will required when you do farm configuration.)

6. Keep authentication as NTLM, Click Next. If you don't want to specify any port number

7. Wait while SharePoint product are configured.

8. Configuration of SharePoint Product is successful. Click Finish

9. Central Administration web page will be opened.Click Cancel.

10 It will redirect to Central Admin page

With this SP configuration is finished.

Happy SharePointing :)

Installation of SharePoint 2013

This Post will help you out with SharePoint 2013 installation

So lets get started :)


1. Download SharePoint server 2013 from Microsoft.

2. Mount the ISO file in window server

3. Before SharePoint installation we have to install few prerequisites.

4. There are two way to install the prerequisites online and offline.Offline which i will discuss in other post.In this post we will do online prerequisites installation which means having active internet connection because it will download the updates from Microsoft download center.

5. Open the ISO image and Run the prerequisitesinstaller.exe.

6. Click Next.

7. Accept the terms  and click Next.

8. It will start the installation and you may required to restarted the system.Click Finish to restart.

9.Once System restarts it will automatically start the prerequisites installer.
10. After prerequisites installer finished install all the required prerequisites.

 11.Run SharePoint setup.

 12. Enter Product Key and Click Continue

13.Accept the terms and Click Continue.

14. Click Install Now.Wait for installation to get completed.

SharePoint 2013 has been installed.

Click to Configure SharePoint 2013
Happy SharePointing :)

Installation of Microsoft SQL Server 2012

This post will help you out with SQL installation.

So lets get started :)

1. Download the SQL server from Microsoft site.Click the link to Download

2. Create a one user in A.D for SQL and one user for SharePoint which we will be using in future.
     I've created (SP.SQL and SP.Farm) for SQL and SharePoint respectively

3. Before we start the installation we should make sure that .net framework 3.5 feature is installed.

4. Insert the SQL media and Run it/ Install it.

5. Click Installation and Click On New SQL server stand-alone installation.

 6. Click OK

7. Enter the product key and click Next.Select I accept the license terms and Click Next

8. Setup file installation.Click Next once finished.

9 Select SQL Server Feature Installation and click Next

10. Select Features
    ( DB engine, SQL server Replication,Full-text extraction for search, Data Quality services)
    (Management Tools-basic and complete both)
     Click Next

11. Click Next if get no warnings.
12. Keep the default instance and Click Next

13. If Disk space  requirement passed click Next.
14. Enter the account name and password.I've created sp.sql for this. Click Next

15. Select Windows Authentication mode and click on Add current users.Click Next

16. Click Next, Next and Install
17. Wait for installation to get complete.
    

18. Once installation is finished, SQL server is installed on your server.

Happy SharePointing :)