Recently there is a case where we need to use BDC to generate some views from our sqlserver database. We have a database with a sqlserver serviceID. However, we do not want to setup SSO. One of the developers is supposed to provide a solution to this view since I was on vacation. He used Passthrough as the AuthenticationMode in the BDC application definition. However, that is not a viable solution considering we have no access to the database and we do NOT want to keep adding IDs to the database, adds an extra step to maintenance. (It actually pisses me off to some extend since he didn't even bother to figure out a workable solution for our particular environment.)
Anyhoo, using RevertToSelf would work in our particular case. In the RevertToSelf scenario, the BDC will be using the application pool account to reach out to the database. We only have to give access to this one account in the database. Saved us a lot of time. In addition to putting this ID for access to the database, this ID also needs access to the BDC Entity on the SSP page (SSP > Business Data Catalog Applications > YourLOBSystem > YourView > Manage Permissions). Also noticed that other domain IDs that try to access the BDC list webpart also needs to have their IDs here! ...
Monday, January 7, 2008
Thursday, January 3, 2008
This form template is browser-compatible, but it cannot be browser-enabled on the selected site !!!
Get error:
This form template is browser-compatible, but it cannot be browser-enabled on the selected site
when trying to published a full-trust infopath browser enabled form.
Soln: must activate Office SharePoint Server Enterprise Site Collection features
(Features such as the business data catalog, forms services, and Excel Services, included in the Office SharePoint Server Enterprise License) from the Central Admin site also, besides the site feature and site collection that you are publishing to
Central Administration > Site Settings > Site Features
activate Office SharePoint Server Enterprise Site Collection features
This form template is browser-compatible, but it cannot be browser-enabled on the selected site
when trying to published a full-trust infopath browser enabled form.
Soln: must activate Office SharePoint Server Enterprise Site Collection features
(Features such as the business data catalog, forms services, and Excel Services, included in the Office SharePoint Server Enterprise License) from the Central Admin site also, besides the site feature and site collection that you are publishing to
Central Administration > Site Settings > Site Features
activate Office SharePoint Server Enterprise Site Collection features
Thursday, November 8, 2007
MOSS AAM - Need Redirecting to alternate url (but same page!)
Problem: We had a moss site of , added alternative access mapping (AAM) so collegues of other countries can view the pages. The changed in url messed up the infopath browser-enabled forms that was on the old site. errors could be prompting you to save the form or saying the form has been closed. However, forms will open and work well on the new url.
Soln: To prevent users from using the old url, we had to do a redirect like so on the same default.aspx page:
<asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server">
<META Name="CollaborationServer" Content="SharePoint Team Web Site">
<script type="text/javascript">
//add here:
var url = window.location.href;
if(url.search(/servername:1234/i) != -1){
window.location="http://servername.co.com:1234/default.aspx";
}
//
var navBarHelpOverrideKey = "wssmain";
</script>
</asp:Content>
Soln: To prevent users from using the old url, we had to do a redirect like so on the same default.aspx page:
<asp:Content ContentPlaceHolderId="PlaceHolderAdditionalPageHead" runat="server">
<META Name="CollaborationServer" Content="SharePoint Team Web Site">
<script type="text/javascript">
//add here:
var url = window.location.href;
if(url.search(/servername:1234/i) != -1){
window.location="http://servername.co.com:1234/default.aspx";
}
//
var navBarHelpOverrideKey = "wssmain";
</script>
</asp:Content>
Tuesday, November 6, 2007
access denied going to newly created sharepoint (moss) site
Encountered this problem:
Created a moss site using host header (http://intranet.machinename.com), created site collection of / and /sites/hr. tried to logon but kept getting prompted. no matter what id used, access always denied.
Soln: to to Central Administration, Application Management, Authentication Providers, click on zone, make sure IIS Authentication Settings is set to NTLM (was kerberos!).
Created a moss site using host header (http://intranet.machinename.com), created site collection of / and /sites/hr. tried to logon but kept getting prompted. no matter what id used, access always denied.
Soln: to to Central Administration, Application Management, Authentication Providers, click on zone, make sure IIS Authentication Settings is set to NTLM (was kerberos!).
Tuesday, October 30, 2007
Infopath form upload, stuck on installing, upgrading etc
Problem: This is a new issue that suddently happened after I published a form with databinding issues (trying to use dynamic links). After going to 'Manage Form Templates' in Central Administration, Application Management, the form is stucked on upgrading. Checked Operations -> Timer job definitions, and status, try to delete the job and redo to no avail.
Solution: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm.exe -o execadmsvcjobs
Solution: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN>stsadm.exe -o execadmsvcjobs
Infopath browser form - test from client, doesn't see properties show up on sharepoint list/library
Problem: when testing from the client with the infopath form, submitting to sharepoint library, only see the name column, none of the properties seemed to be populated/promoted. On the repair documents/relink documents page, shows up as the 'Form' content type instead of the 'Investment' content type. (Investment is the content type of the published form.)
Soln: Steps to resolve: check the site content type, make sure the default content type is Investment, not Form. Reset IIS, resubmit from client should see the properties.
Soln: Steps to resolve: check the site content type, make sure the default content type is Investment, not Form. Reset IIS, resubmit from client should see the properties.
Thursday, July 5, 2007
When deploying to .net 2.0 web application project to production, looks for .cs file
Problem: when deploying to production, the web application is looking for the .cs file after the cs files were deleted. The cs files should have been wrapped in the assembly but didn't.
Solution: Codefile was specified in the directive. Use 'Codebehind' instead. Codebehind should have been converted automatically when you convert the website to a Web Application. Somehow if it didn't, it will look for the codefile specified.
Solution: Codefile was specified in the directive. Use 'Codebehind' instead. Codebehind should have been converted automatically when you convert the website to a Web Application. Somehow if it didn't, it will look for the codefile specified.
Tuesday, June 26, 2007
VM Guest OS takes forever to load
Problem: VM Workstation comes up fast, however, the Guest OS took forever to come up. ~ 18 mins!
Solution: check the memory usage on the menu (VM --> Settings). Make sure the setting is at the recommended memory. Do not go beyond the 'Maximum recommended memory.' They are not kidding when they say 'Memory swapping may occur beyond this size').
Solution: check the memory usage on the menu (VM --> Settings). Make sure the setting is at the recommended memory. Do not go beyond the 'Maximum recommended memory.' They are not kidding when they say 'Memory swapping may occur beyond this size').
Monday, June 18, 2007
Renaming file with local resource (multi-langual)
After renaming a multi-langual file that contains local/global resources, translation won't come through - always resort to one language.
Solution: Open the page and switch to designer. Rebuild.
Solution: Open the page and switch to designer. Rebuild.
Wednesday, June 13, 2007
Programmatically setting anonymous access to a list
To programmatically turn on anonymous access to a list: http://www.u2u.info/Blogs/Patrick/Lists/Posts/Post.aspx?ID=876
'-------------
Dim web As SPWeb = New SPSite("http://").OpenWeb()
Dim list As SPList = web.Lists("
'-------------
Dim web As SPWeb = New SPSite("http://
Dim list As SPList = web.Lists("
- ")
list.AnonymousPermMask = sprights.ViewListItems | sprights.OpenWeb |
sprights.ViewPages
'-------------
For disable the anonymous on your list, you only need to specify the
SPRights.EmptyMask to the AnonymousPermMask Property.
list.AnonymousPermMask = SPRights.EmptyMask
Subscribe to:
Posts (Atom)