Saturday, October 25, 2008

Excel web access web part gives error message as “Access Denied”

Excel web access web part gives error message as “Access Denied”

Now suppose you wish to look at your workbook in sharepoint site you will have to take care of some things, first and the foremost is that your Excel calculation services needs to be turned on,
>>Then you need to make sure that the excel file you save is in xlsx format as the excel calculation services is not compatible with xls files.
>> Then make sure the location which can be UNC path or a sharepoint site is added to the trusted file location in SSP
>> Also choose Trusted children and Trusted data connection in Libraries and Embedded
>> Enabled user defined functionalities allowed

Then you add the Excel web Access web part to the site. Try adding the path in the configurable section, try accessing the page if you still get Access Denied Error message then maybe the culprit is your authentication provider which might be Kerberos, so you will have to run these 3 commands to make sure it is activated

stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1 (here escsecurity means excel calculation security)

stsadm -o setsharedwebserviceauthn -negotiate

stsadm -o execadmsvcjobs

Ran an IIS Reset

Then try accessing the webpart the workbook will render just fine.

Thursday, October 16, 2008

List of all stsadm commands with attributes

here is a list of all possible stsadm commands used in sharepoint site, this list was passed to me by a friend, thanks amzi

1. stsadm -o activatefeature {-filename -name -id } [-url ] [-force]
2. stsadm -o activateformtemplate -url [-formid -filename ]
3. stsadm -o addalternatedomain -url -incomingurl -urlzone -resourcename
4. stsadm -o addcontentdb -url -databasename [-databaseserver ] [-databaseuser ] [-databasepassword ] [-sitewarning ] [-sitemax ]
5. stsadm -o adddataconnectionfile -filename [-webaccessible ] [-overwrite ] [-category ]
6. stsadm -o add-ecsfiletrustedlocation -Ssp -Location -LocationType SharePointUncHttp -IncludeChildren TrueFalse [-SessionTimeout