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
atrbandaAsked:
Who is Participating?
 
Justin SmithSr. System EngineerCommented:
Sorry bro, just got confirmation that SQL Authentication is currently NOT avaialble for Web Analytics in SP 2010.  Maybe SP1 will fix this later this summer.

0
 
Justin SmithSr. System EngineerCommented:
Look up the Set-SPWebAnalyticsServiceApplication commandlet.

http://technet.microsoft.com/en-us/library/ff608102.aspx
0
 
atrbandaAuthor Commented:
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?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Justin SmithSr. System EngineerCommented:
BTW, thanks for posting this question.....I wasn't aware of this limitation beforehand.
0
 
atrbandaAuthor Commented:
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.
0
 
atrbandaAuthor Commented:
By design and it is not possible at the moment.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.