[dba-SQLServer] OT SharePoint

Eric Barro ebarro at verizon.net
Tue May 15 15:56:57 CDT 2007


Jim,

If you just want to have a feel for what Sharepoint looks and feels like you
can download the following:

1. WSS 3.0 - Windows Sharepoint Services
2. .NET 2.0 is required - pre-requisite since WSS uses the .NET framework
3. SQL Server Express 2005
4. SQL Management Studio - to manage SQL Express 2005.

You will also need to draw on the following skill set

1. Active Directory - SP is tightly integrated with AD for security.
2. IIS 6.0 - this serves the pages.
3. IIS application pools - recommend creating a super user for managing SP.
When it installs it needs an AD user that has access privileges to SQL
server and the application pools.. I usually create one called spsAdmin and
use that whenever SP requires a user. It uses that to impersonate
connections, etc...saves you a lot of heartache later.
4. SQL server - navigating and poking around to see where SP places the
databases and tables. The config database in SQL is the key.

Once the installation runs smoothly you should be able to configure and
play.

SP uses the concept of web parts. Think of web parts as mini-applications
that can be plugged into a main web page. Thus you can have a web part that
displays the weather in your location using RSS feeds from weather.com or
some other site. You can have a web part that consumes RSS feeds from
Wired.com or any site that has them. In other words you get a lot of
functionality with little or no programming because each web part has been
pre-programmed to do a specific thing. Web parts can also share information.
One web part can accept data input from the user and send that off to
another web part to display the results.

Setting up users requires AD.

Eric


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Tuesday, May 15, 2007 1:22 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] OT SharePoint

Thank you, Steve, Eric and Martin for the information... So is it just a
document manager? I guess it would be great for a lawyers', accounts' or
even a government office. 

Is the app installed automatically, just has to be located and initialized
or is it sitting on the Server 2003 installation disks? Is it fairly
intuitive or does it require a great deal of preparation. Is the MOSS a
client app for desktop stations? Can a ordinary browser use it? Is it fairly
straight forward to setup clients? If I decide to play is there any 'gochas'
to look out for? 

TIA
Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Tuesday, May 15, 2007 10:05 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] OT SharePoint

I have just moved job to oversee the deployment of a 29,000 user MOSS
install. First 300 user site goes live July. Out of the box it provides
great features. With some programming even more. I am lucky as I have been
paired iwth one of the best programmers in the University for this.
 
We are initially using it to drive almost all of our administrative
functions. Document sharing, communications etc
 
Its early days and it does have issues once you get beyond the user
interface but it is very good. The searching ability it has to search MOSS
sites, Exchange and file shares etc is really useful to us. 
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974465
 

 

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.467 / Virus Database: 269.7.0/804 - Release Date: 5/14/2007
4:46 PM
 




More information about the dba-SQLServer mailing list