Monday, February 18, 2008

MOSS 2007 basic configuration

1, 3 web applications: intranet, mysite and SSPadmin;
2, Create and configure Shared Service Provider and associate 'SSP Administration Site' with 'SSPAdmin', 'My site Location' with 'mysite' web app;
3, Create top level site collection and associate it with 'intranet' web app;
4, Configure indexing through SSP Administration site.
5, For Excel Service, might need to configure SSO (Single Sign ON).

Friday, February 15, 2008

SQL - Get current user

I was thinking of a way to delivery report based on user identity...it turned out that a simple sql statement can help
T-SQL: SELECT SYSTEM_USER

BTW, I was busy working on Epicor's E4SE & EBO stuff in the past few weeks. Eventually I was able to build the whole system and it is running well now. Some other stuff I am working on include WSS 2.0 (to be upgraded to MOSS 2007), SQL 2005 upgrade, BI/Reporting etc.