Hi team,

I accidently deleted the Usage and Health service application and Now i am when i try to recreate it it still gives the error with old DB name . I am using Powershell to create the service application

the error it gives is farm account is not able to open the o

Hi,

To recreate the Usage and Health service application, refer to the following steps:

1. Deleted the Usage and Health service application from CA.
2. Refer to the article: http://njbblog.blogspot.com/2014/01/sharepoint-2013-how-to-configure-usage.html create a new Usage and Health service application with PowerShell. we can't use an exists database, we need to use an not existed database named "WSS_UsageApplication1" 

$SvcApp = New-SPUsageApplication Name WSS_UsageApplication -DatabaseName "WSS_UsageApplication1" DatabaseServer SQL 

$SvcAppProxy = Get-SPServiceApplicationProxy | Where {$_.TypeName -like Usage and Health*}

$SvcAppProxy.Provision() 

Now, we created the Usage and Health service application successfully.

If you want to use the old database, refer to the following article about point the Usage and Health data collection service application to database by using Windows PowerShell:

https://technet.microsoft.com/en-us/library/jj729804.aspx

Best Regards,

Lisa