Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1617
  • Last Modified:

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
0
atrbanda
Asked:
atrbanda
  • 3
  • 3
1 Solution
 
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
 
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
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now