Kendra Thorpe’s VU Blog

• I completed 70-291 and I now am an MCSE w/Security. Yay!

Things I figured out in SharePoint

• Connect to a WebDav SharePoint folder on a non-standard SSL port:
  • \\FQDN@SSL:PORTNUMBER\DavWWWRoot or \\server.test.com@SSL:9566\DavWWWRoot
• Map a drive to a SharePoint WebDav folder on a non-standard SSL port:
  • Net use DRIVELETTER: \\FQDN@SSL:PORTNUMBER\DavWWWRoot or net use S: \\server.test.com@SSL:9566\DavWWWRoot\
• How to create a UDC: http://dotnetbuzz.spaces.live.com/blog/cns!F3599E60D988EEB0!249.entry

Submitting InfoPath 2007 form data to SQL 2005 database: I created an InfoPath form to add/edit data in a simple SQL 2005 database. But after I published the form to SharePoint, I received this error message:

InfoPath cannot connect to the data source.

Access is denied.

Access is denied.

Thanks to this blog,http://www.eggheadcafe.com/software/aspnet/30510648/access-is-denied-but-win.aspx, I changed the form options to Full Trust. Here are the instructions on how to change an InfoPath 2007 form to Full Trust:

1. Tools Menu -> Form Options
2. Security and Trust
3. Unselect “Automatically determine security level”
4. Select Full Trust (The form has access to files and forms on the computer)

I was able to submit the data locally, but when I tried to submit the data from SharePoint, it told me I need a certificate. Urggh!

Altiris Unable to remove Windows Operating System Data Class from the Computer Resource – https://kb.altiris.com/display/1/articleDirect/index.asp?aid=38247&r=0.3199579