Login failed for user ''

Question

Hi, I'm learning AppFabric configuration.

I managed to install and configure monitoring and persistance database using script based on

Appfabric script

Starting 'Configure AppFabric' shows both configurations in green

I'm now trying to get through AppFabric tutorial from

AppFabric tutorial

I reached lesson 4 and saw that clicking Apply doesn't do anything.

I then tried to start AppFabric dashboard in IIS manager

It shows "Error(s) occured" with error "Error(s) occurred while gathering data for the Appfabric dashboard.....Login failed for user ''. "

I don't know where to set this user properly and why it wasn't configured during script execution.

Any help appreciated

Answer 1

Maybe the user that was being used when setting up monitoring or persistence is not the same user when doing step 4? I am wondering if maybe the connection strings setup for monitoring or persistence are using a certain user? These connection strings are set during the earlier steps and I think you can find them in the web.config files on your IIS server.

Thanks,

---

If this answers your question, please use the "Answer" button to say so | Ben Cline

Answer 2

Monitoring and persistence store was configured in this way:

	$monitoringdbdata = Initialize-ASMonitoringSqlDatabase –Database $MonitoringDatabaseName –Admins "dom\AP-Administrators" –Readers "dom\AP-Observers" –server $MonitoringComputerName –Writers "dom\AP-Users"

$persistencedbdata = Initialize-ASPersistenceSqlDatabase –Database $PersistenceDatabaseName –Admins "dom\AP-Administrators" –Readers "dom\AP-Observers" –server $PersistenceComputerName –Users "dom\AP-Users" -Force
	
$services = Get-WmiObject Win32_Service -filter "name='AppFabricEventCollectionService' OR name='AppFabricWorkflowManagementService'"
    foreach ($service in $services) {
		$inParams = $service.psbase.getMethodParameters("Change")
		$inParams["StartName"] = "dom\AP-Admin"
		$inParams["StartPassword"] = "P4ssw0rd"
		$service.invokeMethod("Change",$inParams,$null)
		$service.stopservice()
		$service.startservice() 
}

	appcmd set config /clr:4 /commit:WEBROOT /section:connectionStrings /+"[connectionString='$($monitoringdbdata.ConnectionString)',name='$MonitoringConnectionStringName',providerName='System.Data.SqlClient']" | Write-Log
	appcmd set config /clr:4 /commit:WEBROOT /section:connectionStrings /+"[connectionString='$($persistencedbdata.ConnectionString)',name='$PersistenceConnectionStringName',providerName='System.Data.SqlClient']" | Write-Log

	Add-ASAppSqlInstanceStore -Name $Persistence_InstanceStoreName -ConnectionStringName $persistenceConnectionStringname -Root

	Set-ASAppMonitoring -MonitoringLevel $MonitoringLevel -ConnectionStringName $MonitoringConnectionStringName -Root
	
	Set-ASAppSqlServicePersistence -ConnectionStringName $PersistenceConnectionStringName -Root -HostLockRenewalPeriod "00:00:20" -InstanceEncodingOption "GZip" -InstanceCompletionAction "DeleteNothing" -InstanceLockedExceptionAction "BasicRetry"

Answer 3

Hi again. I found the problem and I think this is problem with Powershell cmdlets.

I configured Appfabric manually and by script and compared config files.

It appeard that Initialize-ASPersistenceSQLDatabase didn't add 'Integrated Security = true' to connection string and this casued error I described.

Manual configuration added this correctly

I manually corrected this in a config file and dashboard works like a charm.

If here is somebody who can confirm this issue please check it out. If anybody knows where I should post to find it out please also let me know