asked on

SharePoint 2010 Web Analytics Service - connecting with SQL authentication?

Hello Everybody,

I have SharePoint 2010 server in DMZ which is not in domain and SQL server which is located in LAN. I was able over PowerShell to configure almost all my services to use SQL authentication (and not Windows Integrated).

I stopped with Web Analytics Service where I didn't find on web syntax for connection string of its xml string. It looks like this:

$stagerSubscription = "<StagingDatabases><StagingDatabase ServerName='$databaseServerName' DatabaseName='$StagerDB'/></StagingDatabases>"
$reportingSubscription = "<ReportingDatabases><ReportingDatabase ServerName='$databaseServerName' DatabaseName='$WarehouseDB'/></ReportingDatabases>"

New-SPWebAnalyticsServiceApplication -Name $WebAnalyticsSAName -ApplicationPool $saAppPoolName -ReportingDataRetention 20 -SamplingRate 100 -ListOfReportingDatabases $reportingSubscription -ListOfStagingDatabases $stagerSubscription

Open in new window

There was no explanation on technet or anywhere else :(

I'd really appreciate some ideas.

Thanks,
Matt

Justin Smith

Look up the Set-SPWebAnalyticsServiceApplication commandlet.

http://technet.microsoft.com/en-us/library/ff608102.aspx

atrbanda

ASKER

I did, but it is too generic:

ListOfReportingDatabases - Specifies the server and database name for the Web Analytics Reporting database. The parameter value is an XML string that contains the server name and the database name. The type must be a valid XML string.
ListOfStagingDatabases - Specifies the server and database name for the Web Analytics Staging database. The parameter value is an XML string that contains the server name and the database name. The type must be a valid XML string.

Is there a field which can contain login information?

ASKER CERTIFIED SOLUTION

Justin Smith

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Justin Smith

BTW, thanks for posting this question.....I wasn't aware of this limitation beforehand.

atrbanda

ASKER

Thank you for your confirmation. Similar thing to think of is also User Profile Synchronization Service. But anyway, at the moment i used "workaround". I installed sql express on sharepoint server and as there's no sensitive information, published this service application database locally.

atrbanda

ASKER

By design and it is not possible at the moment.