Thursday, April 24, 2008

Upload a File to a SharePoint Document Library

I developed a document management system a while ago, however it can only handle the records of documents and those records are not directly linked to electronic documents which makes it far from optimistic.
By combining the system with sharepoint document library, the system can be used more regularly and reduce work load. i.e. create the document records and save a copy of documents under sharepoint document library, it can also be used to send transmittal electronically.
Thanks for the author of the following article:
http://geek.hubkey.com/2007/10/upload-file-to-sharepoint-document.html
I have been testing the solution and it seems to be working pretty well...

Monday, April 21, 2008

Kerberos authentication & delegation for SQL Server & IIS

To use Kerberos authentication

All computers must be in the same Active Directory forest or in domains in separate forests with trust relationships.
You must configure the Web server or application server machine accounts in Active Directory for delegation. Alternatively, if your ASP.NET application runs under a specific custom domain account, you can configure the domain account for delegation.
IIS must be configured for Windows authentication, or for certificate authentication with certificate mapping.
You must enable impersonation in your applications Web.config (see "How to impersonate the original caller").

http://www.securityguidanceshare.com/wiki/ASP.NET_2.0_Security_Questions_and_Answers_-_Impersonation_/_Delegation

Check SPN
setspn -L Machine_Name
Setspn -A http/www.microsoft.com (DNS) webserver1 (NetBIOS Name) [this is the one I made Reporting service works]
Check IIS Authentication method:
cscript c:\InetPub\Adminscripts\adsutil.vbs get w3svc/NTAuthenticationProviders

Grant delegation permission to the SQL Server service account domain user account (if not using localSystem account)

How to use Kerberos authentication in SQL Server
http://support.microsoft.com/kb/319723/en-us

Saturday, April 19, 2008

HOME ESX LAB


looks like I might need to expend the storage...I got 12 VMs loaded at the moment and will definitely add more!

Thursday, April 10, 2008

Excel Service & External data connection

After struggling to find out what is wrong, I eventually got Excel Service working now.
The important thing here is to deploy SSO for excel service (there are other options too, but I use SSO in my case). Here is a good reference from Technet:
http://technet.microsoft.com/en-us/library/cc262899.aspx (Plan external data connections for Excel Services)

Wednesday, April 9, 2008

Programatically create site under sharepoint server 2007 using web service

I was working on the integration between E4SE and sharepoint service 3.0(we actually use sharepoint server 2007). the integration involves providing web service for site creation and team members update. Although we got an older version that works with WSS 2.0, the source code is missing! I re-established the source code and make it working with WSS 3.0. Due to the limitation of sharepoint service, a customized sharepoint web service is also used. Will release the code if anyone interested.

Tuesday, April 8, 2008

Build an ESX Server 3.5 Server with ML110 G4

well, this esx server was built using HP ML110 G4 (Pentium D 2.8G, 6G RAM, 1XSATA HDD as system install disk and 2XSATA HDD on Adpatec 2610SA RAID Card for VMFS storage).

I loaded it with 4 virtual machines at the same time and the speed is really impressive.

No need to worry about no place to play with new systems/apps now.