The Report Server Installation Is Not Initialized. (rsReportServerNotActivated)

HI All,
          One of my blog member has submited info on solving the issue "Report Server Installation is Not Initialized".This issue will commonly occur after configuring the ssrs ,This issue can be solved in many ways.One of the best way to solve instanlty is deleting the encrypted keys

Solution:

• Open Reporting Services Configuration Manager
• Go to Encryption Keys
• Delete Encrypted Content
• Click on Delete
• Reset IIS

Configure SharePoint 2013 apps on Server

Hi All,
        Below are the steps to configure the apps in SharePoint 2013 Server
configure dns
1. Create a Forward Lookup Zone in DNS
System account cannot deploy apps so we need to create another account
2. Create user with appropriate rights (equivalent to the administrator
   member of
       1. Administrators
 2. Domain Admins
 3. Domain Users
 4. Enterprise Admins
 5. Group Policy Creator owner
 6. IIS_USRS
 7. Performance Log Users
 8.  Performance monitor users
 9. Schema Admins
 10. SQLServerMSAUser$MSSQLSERVER
 11. WSS_ADMIN_WPG
 12. WSS_RESTRICTED_WPG_V4
 13. WSS_WPG
3. Central Administration
   security
     Configure Managed Accounts 
     Register Managed Accounts
  (Register the newly created account - eg. spsappadmin)
   
     Configure Service Account
         set the newly created account as the farm account -
   (this will add the user to the sp_config database)
         reset the farm account back to the original administrator.
   (The previous step only ensures the new account has the appropriates rights on the DB
      System account cannot deploy apps)
4. Start the services
      App Management Service
      Microsoft Subscription Setting Service
5. Change service account application pool account
       Application Management Service - set it to the new account
6. Load SharePoint Management Shell (Power shell)
 $account = Get-SPManagedAccount "domain\user"
 Configure a new
 App Management Service Application
      a) App pool         
     $appPoolAppSvc = New-SPServiceApplicationPool -Name AppServiceAppPool -Account $account
             b) Application     
     $appAppSvc = New-SPAppManagementServiceApplication -ApplicationPool $appPoolAppSvc -Name AppServiceApp -DatabaseName AppServiceDB
      c) Proxy
     $proxyAppSvc = New-SPAppManagementServiceApplicationProxy -ServiceApplication $appAppSvc
  Microsoft SharePoint Foundation Subscription Settings Service
      a) App pool     
  $appPoolSubSvc = New-SPServiceApplicationPool -Name SettingsServiceAppPool -Account $account
             b) Application
  $appSubSvc = New-SPSubscriptionSettingsServiceApplication –ApplicationPool $appPoolSubSvc –Name SettingsServiceApp –DatabaseName SettingsServiceDB
             c) Proxy
  $proxySubSvc = New-SPSubscriptionSettingsServiceApplicationProxy –ServiceApplication $appSubSvc

7. Configure app url
 Set-SPAppDomain <appDomain>
 Set-SPAppSiteSubscriptionName -Name "app" -Confirm:$false
8. Add the user to the site

HIde List Tab from Ribbion for List

HI All,
          After very long time I am posting the issue on SP 2013 .One of my follower mailed me few times for the solution to hide the List Tab from the SP Ribbon.

Step-1
 Insert the Script Editor Web-part in the List or Document Library
Step-2
   Insert the below snippet

<style type="text/css"> #Ribbon\.List-title{ DISPLAY: none !important } </style>
Step-3
     Check Hidden Option the Layout option ->ok

Setup is unable to proceed due to following error(s)

Hi All,
          Few days back when I am installing Sp 2013 I faced the below issue

Setup is unable to proceed due to following error(s)
The Producr requires Windows Server 2008 Server Pack 2 or above.
Correct the issue(s) listed above and run setup

Solution:
Download the below exe files and run with command prompt
.NET Framework 3.5 SP1
Windows PowerShell 2.0
Windows Installer 4.5 Redistributable
 

browser id="Safari2" parentID="Safari1Plus"

When you open a file with SharePoint Designer, it creates all kind of FrontPage Server Extension functionality in your web application. One thing it does it that it creates a _vti_cnf folder in every folder you have in your web application. If you remove all these folders you fix your problem.

I don't know of a handy DOS command to delete all these folders recursively, but with some PowerShell I solved the problem.

Open a PowerShell prompt, set the current directory to the folder hosting your web application and execute the following command to see the "damage":

PS C:\Inetpub\wwwroot\wss\VirtualDirectories\wss3dev> get-childitem -path . -name _vti_cnf -recurse
_vti_cnf
App_Browsers\_vti_cnf
App_GlobalResources\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\CSs\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\Tree\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\JS\_vti_cnf
wpresources\_vti_cnf
_app_bin\_vti_cnf

Now execute the following PowerShell command to kill all these folders and become a happy camper again:

PS C:\Inetpub\wwwroot\wss\VirtualDirectories\wss3dev> get-childitem -path . -name _vti_cnf -recurse | % { remove-item -Path $_ -recurse }

User Profile Synchronization Service Stuck at "Starting"

Hi All,
              These days while working on "Enterprise Search" .I faced an error and when I went to User Profile Synchronization Service  which is in(Central admin->Application Management->Service Application->Manage Services on Server) it is in "Starting mode" . I binged in for this solution and many url's suggested to create new user profile and blah blah blah . Then I had a look on my Timer service and it too is fine, And  I remembered a time in the past where deploying updates jacked up the Timer service, making it appear as it was running when it really wasn't. I opened Powershell

1.$farm=Get-SPFarm
2.$farm.TimerService.Instances

After running second line I go ID of Timer Server and used it in below command

1.$timer=$farm.TimerService.Instances | where {$_.ID -like "4824-2425-2132-2442*"} 
2.$timer.Status = [Microsoft.SharePoint.Administration.SPObjectStatus]::Online
3.$timer.update()
  When I look back Manage Services on Server  which is in(Central admin->Application Management->Service Application->Manage Services on Server) it is in "Start" Mode.

 

Sql query to Restore Database

Hi All,
          These days i had come to a situation where i need  to restore large amount of DB .When I try restore Sql Sever GUI it is taking long time.Then with the help of below restore query it had almost saved lot if time


Restore DATABASE WSS_Content_ecdb178dc5434f4299f516abc83e48ed  From Disk = 'D:\sqldb.bak' With REPLACE
Go