.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Kerberos between MOSS 2007 and SSAS 2005

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.

We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail.  We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work.  We've used other materials we have on kerberos here.  But the end result is that the double hop is not happening.  We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services).  In every case the connection is not happening.

Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message).  Excel services works fine if I use the unattended service account, but when I switch the odc file to windows (should cause kerberos to kick in) it fails.  When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.

In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer.  I have no problems connecting to the cube directly through excel, so the security at that end passes t

View Complete Post

More Related Resource Links

Excel 2007 connectivity to SSAS 2005 cube

Hello - I am using an excel 2007 odc file to connect to an analysis services 2005 cube (on windows server 2003 R2 OS). I receive the following error message   "Excel was unable to get necessary information about this cube. The cube might have been reorganized or changed on the server" Have already attempted the following fixes but running out of ideas now 1. Added localeIdentifier to ODC file    <odc:ConnectionString>Provider=MSOLAP.3;Integrated Security=SSPI;Persist Security Info=True;Data Source=bisql;Initial Catalog=SLAM ACT BUD; LocaleIdentifier = 1033 </odc:ConnectionString> 2. Ensured that all dimensional attributes which are used in MDX calculations (named sets, calculated members) are set to "AttributeHierarchyEnabled  = True" Running out of steam so any help is greatly appreciated.

SQL SERVER 2005 Analaysis Services -> KPI -> MOSS 2007. Connection Timed Out


I am using SharePoint 2007 and trying to set up some KPIs in Executive Dashboard.
I have an ODC uploaded to my document library which has been connected to analysis
services cube which also has some kpi's. When i use the ODC file to connect to analysis
services to retrieve the KPI they don't seem to appear under ALL KPI'S and i also get an

This data connection does not use encryption for the communication with the SQL Server
 2005 Analysis Services server. It is recommended to enable encryption for the SQL Server
2005 Analysis Services server to help prevent unauthorized users from viewing this information.

The connection either timed out or was lost.

The same works connection file works in Excel. 




moving from Visual Studio 2005 to visual studio 2010. Will be on MOSS 2007 for next year at least.


Most of my web servers are 64 bit.

At this new shop I don't have any custom visual Studio 2005 compiled workflows or sharePoint solutions.  What I do have is a few DLLs we've deployed manually to the Web front ends in the 12 hive,  And a few low volume non-sharepoint websites I've deployed with the source - because I knew I'd be moving to 2010 very soon.

What's the risk of moving my development client to 2010? Can I have 2005 and 2010 on the same client? Does 2010 have an option for compiling to 2005 compatibility?

What happens if I compile those solutions (as is) in vs 2010 and deploy?  Does something special need to be installed in SharePoint or my web servers to support VS2010 compiled solutions?

BTW, how smooth is the 2005 to 2005 code coversion (if any) process. Can I open 2005 projects/solutions in 2010?




MOSS 2007 Tutorials video

This link about how create sharepoint website ,blogs,team site,document lib etc

AJAX in MOSS 2007

These days implementing AJAX in sharepoint has become a important request for share point applications.

Here i'm explaining how to create and deploy a AJnAX webpart in step by step manner

Master Pages in MOSS 2007

'MasterPages' feature in sharepoint 2007 makes the entire customization job easy.In 2003 we used to face lot of issues to get the same look and feel and the standard behaviour for overall site. In 2007, customizing the look and feel for the entire site can be done in a simple way by using 'MasterPage' feature.

Content Types in MOSS 2007

In this article I will try to describe the one of the best feature in Microsoft office Share Point 2007 called Content Types.

Content types are simply collection of contents.Each content in a Content type can have different settings.Basically it is a reusable collection of settings which you want to apply to a particular category of contents.

MOSS 2007: Automate Web App Deployment with the SharePoint API


Learn how to automate custom SharePoint application deployments, use the SharePoint API, and avoid the hassle of custom site definitions.

E. Wilansky, P. Olszewski, and R. Sneddon

MSDN Magazine May 2008

MOSS 2007 and MySite in Outlook

Looking to get the My Site feature working in Outlook 2007 when you right click someone's name in an email. I've followed this (http://support.microsoft.com/kb/968115) and I can add/remove various fields but when it comes to the My Site feature it nevers show a link to the users Sharepoint My Site. It's strange because the URL for people's My Site is in AD. It's not like I even get a error message where the My Site option should be - the field never displays...help!

Unable to open pdf from document library MOSS 2007


When I click on a pdf document uploaded in a document library it comes up with a blank page. 

I guess it's trying to open pdf on the browser. I turned off "Display PDF in browser " option in Adobe Preferences, but it doesn't help, same issue.

I tried other browsers too, it's the same issue.

I am able to open all other pdf files local to my machine fine.

I am using IE 8 on my machine (Windows 7) and the Sharepoint server is MOSS 2007.



MOSS 2007 License and Pricing

I just need a small help related to MOSS 2007 License and Pricing.

The scenario is that we have the following number of servers and users are 750.

# moss-SQl1 - (DB server 1)
# moss-SQl2 - (Mirrored DB server 2)
# moss-app -    (Application server)
# WFE1 -  (Web front end server 1)
# WFE2 -           (Web front end server 2)
# MOSS-SQLWITNESS –   (witness server for database mirroring)

To my understanding we need to purchase:
MOSS 2007 Server Licenses -- 2 @ 4424$
Enterprise CALs           -- 750 @ 75$ + 94$ for standard CAL

and it amounts to: 2 * 4424 + (75+94) * 750 =   8848 + 126750 = 135598$.

I think this calculation has gone wrong somewhere. Could you please correct me if I assumed anything wrong here.

One more question is: If we purchage one CAL, can this be used by only one user?

Thanks, Chandralekha

Checkout/Chevk in issue in MOSS 2007 while connecting through VPN(virtual private network)


HI, I am using VPN connection . When I try modify a file and try to checkin the file in sharepoint document library it does not gets checked in. I get a message saying

"Unable to checkin the file, since File is being edited in Local Draft, please close the application or discard the checkout ".

Please do the needful....



MOSS 2007 configuration error


Hi Experts,

I installed sharepoint 2007 successfully but while configure the sharepoint it gives following error:

The following services may have to be started or reset during configuration:

1. internet Information services

2.Sharepoint Adminstration services

3.Sharepoint Timer service

But already run ISS in my server. how can i solve this problem

Exporting web from MOSS 2007 to WSS 3.0

Hi! I'm trying to export SharePoint web site from MOSS 2007 to WSS 3.0.

There are some problems, which prevent me. WSS doesn't include two features: DataConnectionLibruary and TransMgmtLib. This features are not avaible on WSS, so I tried to deactivate these features using site capabilities. It wo'nt help. Here is the exception text:

Could not find Feature TransMgmtLib
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.VerifyFeatureDefinition(SPRequirementObject reqObj)
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.Validate(SPRequirementObject reqObj)\
at Microsoft.SharePoint.Deployment.ImportRequirementsManager.DeserializeAndValidate()
at Microsoft.SharePoint.Deployment.SPImport.VerifyRequirements()
at Microsoft.SharePoint.Deployment.SPImport.Run()
at InfoCenter.ConsoleTestingApp.Program.ImportInfoCenter()

The question is: which way must I go to solve this problem? Is it really possible (I mean export from MOSS to WSS)? And what is the purpose of TransMgmtLib feature? Thanks.

Cannot locate Tsneu.xml to Configure SharePoint Treasure (Synonym) In MOSS 2007


Hi all,

I wanna follow this article -> http://www.codeproject.com/Articles/36203/How-to-Configure-SharePoint-Treasure-Synonym-In-MO.aspx?msg=3038555 

to figure SharePoint Treasure (Synonym) In MOSS 2007.


I created the SSP for searching file, and my SSP guid is 7xxxxxx-xx etc., but in my MOSS 2007 server,  

I have this folder -> "Drive:\Program Files\Microsoft Office Servers\12.0\Data",

but no I haven't "Drive:\Program Files\Microsoft Office Servers\12.0\Data\Applications\" folder, so I cannot locate Tsneu.xml as above article.


I can find "tsneu.xml" file in following 4 folders, I don't know which file I should modify... 


MOSS 2007 : I am looking for tutorial about how tu use infopath 2007 forms and to associate to them



I am quite new on sharepoint 2007,

i am at the moment looking for tutorial to help to understand better the concept of workflow you can associate with infopath 2007.

I would like to create a  form that the visitor of the website can fill and then submit.

once the form submitted i would like tto be able to store all the date picked up to the database sqlserver 2005 and then to be able to send a email to the administator to be kept inform  of that.

the 2 tutorial i found that i found interested are http://weblog.vb-tech.com/nick/archive/2007/02/25/2207.aspx and the microsoft one o.n the virtual lab.

So what i am looking for is any tutorial which can help me to be understand very well how to use the worklow with infopath or if you have as well some book to advice me for that i would be happy.


SQL 2008 servers and MOSS 2007 with SSRS


I need help figuring out the limitations in a multi-database server environment and MOSS 2007 installation with SSRS.  Here is the run down:

  • I currently have MOSS 2007 server with backend on SQL 2005, which also acts as the SSRS server.  In addition I have another SQL 2005 server where business data resides and against which most of the SSRS reports run.
  • Future plan (over which I don't really have a say) is MOSS 2007 with backend on SQL 2008, which will remain to be the SSRS server.  The second SQL server with business data will be migrated to SQL 2008 R2.

Questions: does this architecture requires SSRS 2008 add-in or SSRS 2008 R2 add-in (integrated mode)?  Will there be an issue of building SSRS 2008 reports that go after SQL 2008 R2 and SQL 2008 data mix?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend