[dba-SQLServer] OT SharePoint

Jim Lawrence accessd at shaw.ca
Thu May 17 16:05:51 CDT 2007


Hi Martin and Eric:

Thank you so much for your help. I will be looking into this further when
the desktop gets a little more cleared of projects. If you do not mind I
will have some more questions to ask by then.

Jim 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Eric Barro
Sent: Wednesday, May 16, 2007 7:23 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] OT SharePoint

Jim,

Knowledge of the app pool works in your favor if you have to debug.
Otherwise you don't have to mess with it. Same goes for web parts. It's a
plug-n-play proposition. I was just giving you the lay of the land so to
speak. Don't worry about RSS feeds either.

MOSS 2007 is the portal technology that sits on top of WSS. WSS is the
engine, MOSS is the super-charger or turbo-boost for the engine. Both
products are server technologies.

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 3:31 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] OT SharePoint

Thank you some much you guys, Martin and Eric for the help. You have given a
lot to chew on and if it is alright there will be more pointed questions
then.

Current have one of my servers set up with AD, IIS6, .Net FrameWork (not
sure which version yet). 

Does it need SQL Express or is the full-version of SQL 2005 OK?   

Have a good handle of Web pages, but have done nothing major with the App
Pool or anything with web parts or RSS feeds...

Is this MOSS server some kind of pre-configured SharePoint module or a total
stand-alone proprietary application? Or is it a custom server? 

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

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
 

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

_______________________________________________
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
 

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




More information about the dba-SQLServer mailing list