We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SharePoint 2010 Web Analytics Service - connecting with SQL authentication?

Medium Priority
1,716 Views
Last Modified: 2016-02-24
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
Comment
Watch Question

Justin SmithSr. System Engineer
Top Expert 2012

Commented:
Look up the Set-SPWebAnalyticsServiceApplication commandlet.

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

Author

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?
Sr. System Engineer
Top Expert 2012
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Justin SmithSr. System Engineer
Top Expert 2012

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

Author

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.

Author

Commented:
By design and it is not possible at the moment.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.