Jim Lawrence
accessd at shaw.ca
Tue May 15 17:30:31 CDT 2007
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