@echo off
echo ===============================================================
echo Back up sites for the farm to GLBRC
echo ===============================================================
cd\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
@echo off
stsadm -O backup -url http://dev06:40000 -filename d:\backup\40000.dat -overwrite
echo completed
Tuesday, September 1, 2009
Tuesday, May 5, 2009
Powershell script for SQL Backup
Full Backup
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Action = 'Database'
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".bak")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Backup of MyDatabase done"
** For checking("C:\test", "mydatabasebackup-$($today.toString('yyyy-MM-dd HH-mm-ss ')).bak")
Transaction log backup
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Action = 'Log'
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".trn")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Log Backup of MyDatabase done"
Differential backup
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Incremental = 1
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".diff")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Differential Backup of MyDatabase done"
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Action = 'Database'
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".bak")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Backup of MyDatabase done"
** For checking("C:\test", "mydatabasebackup-$($today.toString('yyyy-MM-dd HH-mm-ss ')).bak")
Transaction log backup
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Action = 'Log'
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".trn")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Log Backup of MyDatabase done"
Differential backup
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") out-null[System.IO.Directory]::CreateDirectory("C:\test") out-null
$srv=New-Object "Microsoft.SqlServer.Management.Smo.Server" "ServerName"
$bck=new-object "Microsoft.SqlServer.Management.Smo.Backup"
$bck.Incremental = 1
$fil=new-object "Microsoft.SqlServer.Management.Smo.BackupDeviceItem"
$fil.DeviceType='File'
$today = Get-Date
$fil.Name=[System.IO.Path]::Combine("C:\test", "TEST" +".diff")
$bck.Devices.Add($fil)
$bck.Database="DBName"
$bck.SqlBackup($srv)
write-host "Differential Backup of MyDatabase done"
Monday, April 13, 2009
How to Set Alternate Access Mapping (AAM) On MOSS2007 Server
To Perform AAM on MOSS 2007 we can do it 3 steps after creating web site.
1. Central Administration:
a) open Centrl Administration In Moss2007 Server.
b) Go to Operations, Global Cofiguration and Click on Alternate Access mapping.
c) Then Click On Add internal URL, In Alternate Access mapping Collection Select the Web Application, Which We need to do Mapping and In Add Internal URL tab should like ex.(http://sample.test.com) and Zone Column Select Intranet.
Note: we have created Interanl URL http://sample.test.com. In this sample is the Alias(CNAME) name which we need to mention in DNS server.
2. DNS Server:
a) Open DNS Management console.
b) Expand Forward Lookup Zones.
c) Select appropriate Zone, Right click on that and select New Alias ( CNAME ).
d) New Resources Record type Alias name Sample, which we created in Internal URL. It will show FQDN.
e) Click browse and point the FQDN target host (Sharepoint server)
3. IIS on Web Server:
a) Open IIS Manager In the Webserver.
b) Expand Web Sites and right click and select Properties on the site which we done Mapping.
c) Then Click Advanced and Click Edit.
d) Then, In Ip Address column select the IP Address of the Server by default it will be (All Unassigned). TCP/Port Column Type the Port No. 80 Host header Value Column Type FQDN Created In DNS Server.
e) Then Click Ok and Reset the IIS once.
1. Central Administration:
a) open Centrl Administration In Moss2007 Server.
b) Go to Operations, Global Cofiguration and Click on Alternate Access mapping.
c) Then Click On Add internal URL, In Alternate Access mapping Collection Select the Web Application, Which We need to do Mapping and In Add Internal URL tab should like ex.(http://sample.test.com) and Zone Column Select Intranet.
Note: we have created Interanl URL http://sample.test.com. In this sample is the Alias(CNAME) name which we need to mention in DNS server.
2. DNS Server:
a) Open DNS Management console.
b) Expand Forward Lookup Zones.
c) Select appropriate Zone, Right click on that and select New Alias ( CNAME ).
d) New Resources Record type Alias name Sample, which we created in Internal URL. It will show FQDN.
e) Click browse and point the FQDN target host (Sharepoint server)
3. IIS on Web Server:
a) Open IIS Manager In the Webserver.
b) Expand Web Sites and right click and select Properties on the site which we done Mapping.
c) Then Click Advanced and Click Edit.
d) Then, In Ip Address column select the IP Address of the Server by default it will be (All Unassigned). TCP/Port Column Type the Port No. 80 Host header Value Column Type FQDN Created In DNS Server.
e) Then Click Ok and Reset the IIS once.
Friday, March 6, 2009
sharepoint 2007 showing System Account instead of Username / full name
When we login with our username & password into sharepoint site, it displays as a "System Account" instead of my username or my full name on the top right corner of the website. What ever changes i make inside the site, for example upload a file, post a comment, sharepoint marks it as a System account instead of my name.
To solve try the below
Method 1:
Go to Central Administration / Application Management. Click Policy for Web Application. Select your web app and click your account in the list. In the Edit Users page, clear the Account operates as System checkbox. That should fix this particular problem.
Method 2:
1. On the top navigation bar, click Operations.
2. On the Operations page, in the Security Configuration section, click Service accounts.
3. On the Service Accounts page, in the Credential Management section, under Select the component to update, select Web application pool.
4. In the Web service list, click a Web service.
5. In the Application pool list, click the application pool that you want associated with the Web application.
6. Under Select an account for this component, select one of the following:
Predefined Select this option to use a predefined account, such as the Network Service account or the Local Service account.
Configurable Select this option to specify a different account.
7. Click OK.
Method 3:
To fix this, you must run the following commands:
stsadm -o updatefarmcredentials -identitytype NetworkService
followed by:
iisreset
To solve try the below
Method 1:
Go to Central Administration / Application Management. Click Policy for Web Application. Select your web app and click your account in the list. In the Edit Users page, clear the Account operates as System checkbox. That should fix this particular problem.
Method 2:
1. On the top navigation bar, click Operations.
2. On the Operations page, in the Security Configuration section, click Service accounts.
3. On the Service Accounts page, in the Credential Management section, under Select the component to update, select Web application pool.
4. In the Web service list, click a Web service.
5. In the Application pool list, click the application pool that you want associated with the Web application.
6. Under Select an account for this component, select one of the following:
Predefined Select this option to use a predefined account, such as the Network Service account or the Local Service account.
Configurable Select this option to specify a different account.
7. Click OK.
Method 3:
To fix this, you must run the following commands:
stsadm -o updatefarmcredentials -identitytype NetworkService
followed by:
iisreset
Thursday, March 5, 2009
"HTTP Error 503. The service is unavailable.
When you browse the Central admin page or SharePoint sites you may get "HTTP Error 503. The service is unavailable.
To solve check the below things...
1. Please check SQL server services running in which user account, If user might have changed the password it will happen. In properties --> Log ON --> changes the password.
2. In IIS, check the under sites whether Central admin page or SharePoint site manage web service stop or start. (Should be Started).
3. In IIS, and also check the under Application pools whether Central admin page or SharePoint site task services status. (Should be Started).
To solve check the below things...
1. Please check SQL server services running in which user account, If user might have changed the password it will happen. In properties --> Log ON --> changes the password.
2. In IIS, check the under sites whether Central admin page or SharePoint site manage web service stop or start. (Should be Started).
3. In IIS, and also check the under Application pools whether Central admin page or SharePoint site task services status. (Should be Started).
Thursday, February 26, 2009
How to change the default database storage location in SQL?
"How do I set the default database file path"I keep seeing this question in many forums. When you fire "CREATE DATABASE " T-SQL command without any parameters. The database will get created and its file will be located in some path, lets say "C:\Program Files\MS SQL\Data". But if you want to have the files located else where, lets assume "D:\SQL_Data\" then there are two options that you can think of.
1 - specify the file path in the "CREATE DATABASE" command or
2- set the default path location in server configuration.
For option one refere to BOL, here is how to workout Option-II: again there are two ways to do this task.
one, using GUI (Management Studio/Enterprise manager) - right click on server node, select properties from pop-up menu, look for "Database Settings" in that section there two boxes - one for LOG and other for DATA file. Key in the appropriate values and save it. This change will effect after stop & start SQL server.
The other way to achieve this configuration change is using T-SQL, as show below,
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', REG_SZ, N'D:\SQL_Data'
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', REG_SZ, N'D:\SQL_Data'
GO
Yes, its instance specific registery entry that it takes to set this property. Here the command is using extended stored procedure "xp_instance_regwrite" to do the trick. This type of command can be used in cases where you want to standardise you SQL Server setup and you may want to add this step as a post installation procedure/batch file etc.
1 - specify the file path in the "CREATE DATABASE
2- set the default path location in server configuration.
For option one refere to BOL, here is how to workout Option-II: again there are two ways to do this task.
one, using GUI (Management Studio/Enterprise manager) - right click on server node, select properties from pop-up menu, look for "Database Settings" in that section there two boxes - one for LOG and other for DATA file. Key in the appropriate values and save it. This change will effect after stop & start SQL server.
The other way to achieve this configuration change is using T-SQL, as show below,
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultData', REG_SZ, N'D:\SQL_Data'
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'DefaultLog', REG_SZ, N'D:\SQL_Data'
GO
Yes, its instance specific registery entry that it takes to set this property. Here the command is using extended stored procedure "xp_instance_regwrite" to do the trick. This type of command can be used in cases where you want to standardise you SQL Server setup and you may want to add this step as a post installation procedure/batch file etc.
Wednesday, February 25, 2009
Failed to register SharePoint Services
When we run Windows SharePoint Products and Technologies Configuration Wizardduring installation, it failed and displayed error "Failed to registerSharePoint Services.An exception of the System.Runtime.InteropServices.COMException was thrown.Additional exception information: Could not access the Search serviceconfiguration database.
The cause and solution:
I looked at the log file, found that the process stopped at STEP 5Calling SPServiceInstance.Provision for instanceMicrosoft.SharePoint.Search.Administration.SPSearc hServiceInstance, serviceMicrosoft.SharePoint.Search.Administration.SPSearc hServiceI did this following steps and the configuration finished successfully.
1. On the Start menu, click Run. In the Open box, type regedit and thenclick OK.
2. In the Registry Editor, navigate to the following subkey, and then deleteit:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web ServerExtensions\12.0\WSS\Services\Microsoft.SharePoint. Search.Administration.SPSearchService
3. Run the SharePoint Products and Technologies Configuration Wizard again.
The cause and solution:
I looked at the log file, found that the process stopped at STEP 5Calling SPServiceInstance.Provision for instanceMicrosoft.SharePoint.Search.Administration.SPSearc hServiceInstance, serviceMicrosoft.SharePoint.Search.Administration.SPSearc hServiceI did this following steps and the configuration finished successfully.
1. On the Start menu, click Run. In the Open box, type regedit and thenclick OK.
2. In the Registry Editor, navigate to the following subkey, and then deleteit:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web ServerExtensions\12.0\WSS\Services\Microsoft.SharePoint. Search.Administration.SPSearchService
3. Run the SharePoint Products and Technologies Configuration Wizard again.
Tuesday, February 24, 2009
Backup / Restoring SharePoint 2007 Site from SQL Database
I got this excellent article on SharePointdogs for backup / restoring the SharePoint site from SQL DB :
http://sharepointdogs.wordpress.com/2008/07/30/content-migration-or-backuprestore-in-moss-2007/#comment-9
Here is one of defined approach which worked wonders for me :
USING SQL
Using SQL, Backup the SQL Content Databases which are required and Restore them to a new databases in the SQL and attach these databases to the new application.
(Briefly we can say that take your content db ‘Offline’ using the Central admin. Take the content database offline in SQL Studio (Take Offline context menu item). Copy your database mdf and ldf files to the new machine (the destination machine). Attach the copies on the new SQL server using SQL Studio. Add the copied content DB to the Web Application on the new machine using the Central Admin on the new web server.)
STEPS:
1)Find the content DatabaseThese are listed under Central Admin->Application Management->Site Collection List
2) Backup the content databaseYou could alternatively detach it, and copy it. Just doing a backup in SQL Server 2005 Management studio is easier.
3) Restore content database to new serverCopy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the “options” tabof the restore dialog to get it to work. (Overwrite db).
4) Create Web App on new ServerCentral Admin->Application Management->Create or extend Web App->Create New Web App.
5) Associate restored DB with new Web AppCentral Admin->Application Management->SharePoint Web Application Management->Content Databases->Remove Content Database from your new web app.
Now use STSADM to add restored DB to this web appc:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.run this command from there.
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
6) Run ISSRESET from command prompt
http://sharepointdogs.wordpress.com/2008/07/30/content-migration-or-backuprestore-in-moss-2007/#comment-9
Here is one of defined approach which worked wonders for me :
USING SQL
Using SQL, Backup the SQL Content Databases which are required and Restore them to a new databases in the SQL and attach these databases to the new application.
(Briefly we can say that take your content db ‘Offline’ using the Central admin. Take the content database offline in SQL Studio (Take Offline context menu item). Copy your database mdf and ldf files to the new machine (the destination machine). Attach the copies on the new SQL server using SQL Studio. Add the copied content DB to the Web Application on the new machine using the Central Admin on the new web server.)
STEPS:
1)Find the content DatabaseThese are listed under Central Admin->Application Management->Site Collection List
2) Backup the content databaseYou could alternatively detach it, and copy it. Just doing a backup in SQL Server 2005 Management studio is easier.
3) Restore content database to new serverCopy the BAK file to new server. Create an empty DB in Management Studio, restore from backup, you may need to change an option in the “options” tabof the restore dialog to get it to work. (Overwrite db).
4) Create Web App on new ServerCentral Admin->Application Management->Create or extend Web App->Create New Web App.
5) Associate restored DB with new Web AppCentral Admin->Application Management->SharePoint Web Application Management->Content Databases->Remove Content Database from your new web app.
Now use STSADM to add restored DB to this web appc:\program files\common files\microsoft shared\web server extentions\12\bin on new server is where you can find the STSADM.run this command from there.
stsadm -o addcontentdb -url http://yourwebapp:port -databasename yourcontentdb -databaseserver yoursqlserver
6) Run ISSRESET from command prompt
Delete a SSP (Shared Service Provider) in a farm
You can only delete a SSP (Shared Service Provider) when you have installed SharePoint as a Farm. There are two ways to delete a SSP:
1) Via a browser: http:///_admin/deletessp.aspx?ssiId=
2) Via Command line: stsadm –o deletessp –title
Also keep in mind when you use number 2 it will not remove the two databases created for the SSP and SSP Search. This means you have to go into SQL Server to remove them your self.
1) Via a browser: http:///_admin/deletessp.aspx?ssiId=
2) Via Command line: stsadm –o deletessp –title
Also keep in mind when you use number 2 it will not remove the two databases created for the SSP and SSP Search. This means you have to go into SQL Server to remove them your self.
Thursday, January 29, 2009
Send Email with HTTP File attachment
Send Email with HTTP File attachment
This activity allows sending emails with attachments retrieved using a web request . Executing Reporting Services report and sending it as an attachment from within SPD workflow would be one such example. Request url is fully customizable and can include workflow variables. Both http and https requests are supported .
This activity allows sending emails with attachments retrieved using a web request . Executing Reporting Services report and sending it as an attachment from within SPD workflow would be one such example. Request url is fully customizable and can include workflow variables. Both http and https requests are supported .
How to run inline code in SharePoint aspx pages....
How to run inline code in SharePoint aspx pages....
"An error occurred during the processing of test.aspx. Code blocks are not allowed in this file".To enable this you need to modify the web.config file for your SharePoint Site Collection.
"An error occurred during the processing of test.aspx. Code blocks are not allowed in this file".To enable this you need to modify the web.config file for your SharePoint Site Collection.
Modify the web.config file
1. Open the web.config file and make the following change:
The PageParserPaths xml tags will be there already you just need to add the line in between.
2. Save web.config.
2. Save web.config.
How to Display Created By and Modified By User names in Custom form.
You Just need to add the SharePoint control to the particular page.
Steps to create Content page layout
Steps to create Content page layout
From site protal .
On the site actions menu point to site setting->Modify all site settings
under galleries click on Site Content Types click create-> Enter the Name "****" in the Name textbox, from Select parent content type dropdown select page layout content Types and from parent content type dropdown select Aritcle Page, In Group create New Group "****" then click ok.
Open the site in Sharepoint Designer
1. From File Menu point to New and then click on sharepoint Content
2. In New dialog box click on Sharepoint Publishing
3. Click on page layout
4. Under options, in the content Type Group list, click "****"
5. In the Content Type Name,Click "****"
6.In the URL Box type a name for the page layout as "****.aspx"
7. In the Title Box type a title for the page layout as "****"
8. Click OkThis layout page saves Automcalliy under _catalogs/Masterpage/
From site protal .
On the site actions menu point to site setting->Modify all site settings
under galleries click on Site Content Types click create-> Enter the Name "****" in the Name textbox, from Select parent content type dropdown select page layout content Types and from parent content type dropdown select Aritcle Page, In Group create New Group "****" then click ok.
Open the site in Sharepoint Designer
1. From File Menu point to New and then click on sharepoint Content
2. In New dialog box click on Sharepoint Publishing
3. Click on page layout
4. Under options, in the content Type Group list, click "****"
5. In the Content Type Name,Click "****"
6.In the URL Box type a name for the page layout as "****.aspx"
7. In the Title Box type a title for the page layout as "****"
8. Click OkThis layout page saves Automcalliy under _catalogs/Masterpage/
Sharepoint Interview questions
1. What is Microsoft Windows SharePoint Services?
How is it related to Microsoft Office SharePoint Server 2007?Windows SharePoint Services is the solution that enables you to create Web sites for information sharing and document collaboration. Windows SharePoint Services -- a key piece of the information worker infrastructure delivered in Microsoft Windows Server 2003 -- provides additional functionality to the Microsoft Office system and other desktop applications, and it serves as a platform for application development.Office SharePoint Server 2007 builds on top of Windows SharePoint Services 3.0 to provide additional capabilities including collaboration, portal, search, enterprise content management, business process and forms, and business intelligence.
2. What is Microsoft SharePoint Portal Server?
SharePoint Portal Server is a portal server that connects people, teams, and knowledge across business processes. SharePoint Portal Server integrates information from various systems into one secure solution through single sign-on and enterprise application integration capabilities. It provides flexible deployment and management tools, and facilitates end-to-end collaboration through data aggregation, organization, and searching. SharePoint Portal Server also enables users to quickly find relevant information through customization and personalization of portal content and layout as well as through audience targeting.
3. What is Microsoft Windows Services?
Microsoft Windows Services is the engine that allows administrators to create Web sites for information sharing and document collaboration. Windows SharePoint Services provides additional functionality to the Microsoft Office System and other desktop applications, as well as serving as a plat form for application development. SharePoint sites provide communities for team collaboration, enabling users to work together on documents, tasks, and projects. The environment for easy and flexible deployment, administration, and application development.
4. What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?
Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible deployment and management tools. Windows SharePoint Services provides sites for team collaboration, while Share Point Portal Server connects these sites, people, and business processes—facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends the capabilities of Windows SharePoint Services by providing organizational and management tools for SharePoint sites, and by enabling teams to publish information to the entire organization.
5. Who is Office SharePoint Server 2007 designed for?
Office SharePoint Server 2007 can be used by information workers, IT administrators, and application developers. is designed
6. What are the main benefits of Office SharePoint Server 2007?
Office SharePoint Server 2007 provides a single integrated platform to manage intranet, extranet, and Internet applications across the enterprise.Business users gain greater control over the storage, security, distribution, and management of their electronic content, with tools that are easy to use and tightly integrated into familiar, everyday applications.Organizations can accelerate shared business processes with customers and partners across organizational boundaries using InfoPath Forms Services–driven solutions.Information workers can find information and people efficiently and easily through the facilitated information-sharing functionality and simplified content publishing. In addition, access to back-end data is achieved easily through a browser, and views into this data can be personalized.Administrators have powerful tools at their fingertips that ease deployment, management, and system administration, so they can spend more time on strategic tasks.Developers have a rich platform to build a new class of applications, called Office Business Applications, that combine powerful developer functionality with the flexibility and ease of deployment of Office SharePoint Server 2007. Through the use of out-of-the-box application services, developers can build richer applications with less code.
7. What is the difference between Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007?
Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007 have identical feature functionality. While the feature functionality is similar, the usage rights are different.If you are creating an Internet, or Extranet, facing website, it is recommended that you use Microsoft Office SharePoint Server 2007 for Internet sites which does not require the purchase client access licenses. Websites hosted using an “Internet sites” edition can only be used for Internet facing websites and all content, information, and applications must be accessible to non-employees. Websites hosted using an “Internet sites” edition cannot be accessed by employees creating, sharing, or collaborating on content which is solely for internal use only, such as an Intranet Portal scenario. See the previous section on licensing for more information on the usage scenarios.
8. What suites of the 2007 Microsoft Office system work with Office SharePoint Server 2007?
Office Outlook 2007 provides bidirectional offline synchronization with SharePoint document libraries, discussion groups, contacts, calendars, and tasks.Microsoft Office Groove 2007, included as part of Microsoft Office Enterprise 2007, will enable bidirectional offline synchronization with SharePoint document libraries.Features such as the document panel and the ability to publish to Excel Services will only be enabled when using Microsoft Office Professional Plus 2007or Office Enterprise 2007.Excel Services will only work with documents saved in the new Office Excel 2007 file format (XLSX).
9. How do I invite users to join a Windows SharePoint Services Site? Is the site secure?
SharePoint-based Web sites can be password-protected to restrict access to registered users, who are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles by assigning different permission levels to view post and edit.
10.Can I post any kind of document?
You can post documents in many formats, including .pdf, .htm and .doc. In addition, if you are using Microsoft Office XP, you can save documents directly to your Windows SharePoint Services site.
11.Can I download information directly from a SharePoint site to a personal digital assistant (PDA)?
No you cannot. However, you can exchange contact information lists with Microsoft Outlook.
12.How long does it take to set up the initial team Web site?
It only takes a few minutes to create a complete Web site. Preformatted forms let you and your team members contribute to the site by filling out lists. Standard forms include announcements, events, contacts, tasks, surveys, discussions and links.
13.Can I create custom templates?
Yes you can. You can have templates for business plans, doctor's office, lawyer's office etc.
14.How can I make my site public?
By default, all sites are created private.If you want your site to be a public Web site, enable anonymous access for the entire site. Then you can give out your URL to anybody in your business card, e-mail or any other marketing material. The URL for your Web site will be: http:// yoursitename.wss.bcentral.comHence, please take special care to name your site. These Web sites are ideal for information and knowledge intensive sites and/or sites where you need to have shared Web workspace. Remember: Under each parent Web site, you can create up to 10 sub-sites each with unique permissions, settings and security rights.
15.How do the sub sites work?
You can create a sub site for various categories. For example:Departments - finance, marketing, ITProducts - electrical, mechanical, hydraulicsProjects - Trey Research, Department of Transportation, FDATeam - Retention team, BPR teamClients - new clients, old clientsSuppliers - Supplier 1, Supplier 2, Supplier 3Customers - Customer A, Customer B, Customer CReal estate - property A, property BThe URLs for each will be, for example:http://yoursitename.wss.bcentral.com/financehttp://yoursitename.wss.bcentral.com/marketingYou can keep track of permissions for each team separately so that access is restricted while maintaining global access to the parent site.
16.How do I make my site non-restricted?
If you want your site to have anonymous access enabled (i.e., you want to treat it like any site on the Internet that does not ask you to provide a user name and password to see the content of the site), follow these simple steps:Login as an administratorClick on site settingsClick on Go to Site AdministrationClick on Manage anonymous accessChoose one of the three conditions on what Anonymous users can access:Entire Web siteLists and librariesNothingDefault condition is nothing; your site has restricted access. The default conditions allow you to create a secure site for your Web site.
17.Can I get domain name for my Web site?
Unfortunately, no. At this point, we don't offer domain names for SharePoint sites. But very soon we will be making this available for all our SharePoint site customers. Please keep checking this page for further update on this. Meanwhile, we suggest you go ahead and set up your site and create content for it.
18.What are picture libraries?
Picture libraries allow you to access a photo album and view it as a slide show or thumbnails or a film strip. You can have separate folder for each event, category, etc
19.What are the advantages of a hosted SharePoint vs. one that is on an in-house server?
No hardware investment, i.e. lower costsNo software to download - ready to start from the word goNo IT resources - Anyone who has used a Web program like Hotmail can use itFaster deployment
20.Can I ask users outside of my organization to participate in my Windows SharePoint Services site?
Yes. You can manage this process using the Administration Site Settings. Simply add users via their e-mail alias and assign permissions such as Reader or Contributor.
21.Are there any IT requirements or downloads required to set up my SharePoint site?
No. You do not need to download any code or plan for any IT support. Simply complete the on-line signup process and provide us your current and correct email address. Once you have successfully signed up and your site has been provisioned, we will send a confirmation to the email address you provided.
22.I am located outside of the United States. Are there any restrictions or requirements for accessing the Windows SharePoint Services?
No. There are no system or bandwidth limitations for international trial users. Additionally language packs have been installed which allow users to set up sub-webs in languages other than English. These include: Arabic, Danish, Dutch, Finnish, French, German, Hebrew, Italian, Japanese, Polish, Portuguese (Brazilian), Spanish and Swedish.
23.Are there any browser recommendations?
Yes. Microsoft recommends using the following browsers for viewing and editing Windows SharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2, Microsoft Internet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape Navigator 6.2 or later.
24.What security levels are assigned to users?
Security levels are assigned by the administrator who is adding the user. There are four levels by default and additional levels can be composed as necessary.Reader - Has read-only access to the Web site.Contributor - Can add content to existing document libraries and lists.Web Designer - Can create lists and document libraries and customize pages in the Web site.Administrator - Has full control of the Web site.
25.How secure are Windows SharePoint Services sites hosted by Microsoft?
Microsoft Windows SharePoint Services Technical security measures provide firewall protection, intrusion detection, and web-publishing rules. The Microsoft operation center team tests and deploys software updates in order to maintain the highest level of security and software reliability. Software hot-fixes and service packs are tested and deployed based on their priority and level of risk. Security related hot-fixes are rapidly deployed into the environment to address current threats. A comprehensive software validation activity ensures software stability through regression testing prior to deployment.
26.What is the difference between an Internet and an intranet site?
An internet site is a normal site that anyone on the internet can access (e.g., www.msn.com, www.microsoft.com, etc.). You can set up a site for your company that can be accessed by anyone without any user name and password. The internet is used for public presence and a primary marketing tool managed typically by web programmers and a system administrator.An intranet (or internal network), though hosted on a Web site, can only be accessed by people who are members of a specific network. They need to have a login and password that was assigned to them when they were added to the site by the site administrator. The intranet is commonly used as an internal tool for giving employees access to company information. Content is driven by business relevance, business rules and has increasingly become a common tool in larger organizations. An intranet is becoming more and more the preferred method for employees to interact with each other and the central departments in an organization, whether or not the organization has a Web presence.
27.What is a workspace?
A site or workspace is when you want a new place for collaborating on Web pages, lists and document libraries. For example, you might create a site to manage a new team or project, collaborate on a document or prepare for a meeting.
28.What are the various kinds of roles the users can have?
A user can be assigned one of the following rolesReader - Has read-only access to the Web site.Contributor - Can add content to existing document libraries and lists.Web Designer - Can create lists and document libraries and customize pages in the Web site.Administrator - Has full control of the Web site.
29.Can more than one person use the same login?
If the users sharing that login will have the same permissions and there is no fear of them sharing a password, then yes. Otherwise, this is discouraged.
30.How customizable is the user-to-user access?
User permissions apply to an entire Web, not to documents themselves. However, you can have additional sub webs that can optionally have their own permissions. Each user can be given any of four default roles. Additional roles can be defined by the administrator.
31.Can each user have access to their own calendar?
Yes there are two ways to do this,by creating a calendar for each user, orby creating a calendar with a view for each user
32.How many files can I upload?
There is no restriction in place except that any storage consumed beyond that provided by the base offering may have an additional monthly charge associated with them.
33.What types of files can I upload / post to the site?
The only files restricted are those ending with the following extensions: .asa, .asp, .ida, .idc, .idq. Microsoft reserves the right to add additional file types to this listing at any time. Also, no content that violates the terms of service may be uploaded or posted to the site.
34.Can SharePoint be linked to an external data source?
SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint can be referenced as an external data source. SharePoint itself cannot reference an external data source.
35.Can SharePoint be linked to a SQL database?
SharePoint 2007 Portal Server (MOSS2K7) allows connections to SQL based datasources via the Business Data Catalog (BDC). The BDC also allows connecting to data via Web Services.
36.Can I customize my Windows SharePoint Services site?
YES! Windows SharePoint Services makes updating sites and their content from the browser easier then ever.SharePoint includes tools that let you create custom lists, calendars, page views, etc. You can apply a theme; add List, Survey and Document Library Web Parts to a page; create personal views; change logos; connect Web Parts and more.To fully customize your site, you can use Microsoft FrontPage 2003. Specifically, you can use FrontPage themes and shared borders, and also use FrontPage to create photo galleries and top ten lists, utilize standard usage reports, and integrate automatic Web content.
37.Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of Microsoft Windows?
Windows SharePoint Services 3.0, Office SharePoint Server 2007, Office Forms Server 2007, and Office SharePoint Server 2007 for Search will support 64-bit versions of Windows Server 2003.
38.How Office SharePoint Server 2007 can help you?
Office SharePoint Server 2007 can help us:Manage content and streamline processes. Comprehensively manage and control unstructured content like Microsoft Office documents, Web pages, Portable Document Format file (PDF) files, and e-mail messages. Streamline business processes that are a drain on organizational productivity.Improve business insight. Monitor your business, enable better-informed decisions, and respond proactively to business events.Find and share information more simply. Find information and expertise wherever they are located. Share knowledge and simplify working with others within and across organizational boundaries.Empower IT to make a strategic impact. Increase responsiveness of IT to business needs and reduce the number of platforms that have to be maintained by supporting all the intranet, extranet, and Web applications across the enterprise with one integrated platform.Office SharePoint Server 2007 capabilities can help improve organizational effectiveness by connecting people, processes, and information.Office SharePoint Server 2007 provides these capabilities in an integrated server offering, so your organization doesn't have to integrate fragmented technology solutions itself.
39.What are the features that the portal components of Office SharePoint Server 2007 include?
The portal components of Office SharePoint Server 2007 include features that are especially useful for designing, deploying, and managing enterprise intranet portals, corporate Internet Web sites, and divisional portal sites. The portal components make it easier to connect to people within the organization who have the right skills, knowledge, and project experience.
40.What are the advanced features of MOSS 2007?
User Interface (UI) and navigation enhancementsDocument management enhancementsThe new Workflow engineOffice 2007 IntegrationNew Web PartsNew Site-type templatesEnhancements to List technologyWeb Content ManagementBusiness Data CatalogSearch enhancementsReport CenterRecords ManagementBusiness Intelligence and Excel ServerForms Server and InfoPathThe “Features” featureAlternate authentication providers and Forms-based authentication
41.What are the features of the new Content management in Office SharePoint 2007?
The new and enhanced content management features in Office SharePoint Server 2007 fall within three areas:Document managementRecords managementWeb content managementOffice SharePoint Server 2007 builds on the core document management functionality provided by Windows SharePoint Services 3.0, including check in and check out, versioning, metadata, and role-based granular access controls. Organizations can use this functionality to deliver enhanced authoring, business document processing, Web content management and publishing, records management, policy management, and support for multilingual publishing.
42.Does a SharePoint Web site include search functionality?
Yes. SharePoint Team Services provides a powerful text-based search feature that helps you find documents and information fast.
43.Write the features of the search component of Office SharePoint Server 2007?
The search component of Office SharePoint Server 2007 has been significantly enhanced by this release of SharePoint Products and Technologies. New features provide:A consistent and familiar search experience.Increased relevance of search results.New functions to search for people and expertise.Ability to index and search data in line-of-business applications andImproved manageability and extensibility.
44.What are the benefits of Microsoft Office SharePoint Server 2007?
Provide a simple, familiar, and consistent user experience.Boost employee productivity by simplifying everyday business activities.Help meet regulatory requirements through comprehensive control over content.Effectively manage and repurpose content to gain increased business value.Simplify organization-wide access to both structured and unstructured information across disparate systems.Connect people with information and expertise.Accelerate shared business processes across organizational boundaries.Share business data without divulging sensitive information.Enable people to make better-informed decisions by presenting business-critical information in one central location.Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise.
45.Will SharePoint Portal Server and Team Services ever merge?
The products will come together because they are both developed by the Office team.
46.What does partial trust mean the Web Part developer?
If an assembly is installed into the BIN directory, the code must be ensured that provides error handling in the event that required permissions are not available. Otherwise, unhandled security exceptions may cause the Web Part to fail and may affect page rendering on the page where the Web Part appears.
47.How can I raise the trust level for assemblies installed in the BIN directory?
Windows SharePoint Services can use any of the following three options from ASP.NET and the CLR to provide assemblies installed in the BIN directory with sufficient permissions. The following table outlines the implications and requirements for each option.Option Pros ConsIncrease the trust level for the entire virtual server. For more information, see "Setting the trust level for a virtual server" Easy to implement.In a development environment, increasing the trust level allows you to test an assembly with increased permissions while allowing you to recompile assemblies directly into the BIN directory without resetting IIS. This option is least secure.This option affects all assemblies used by the virtual server. There is no guarantee the destination server has the required trust level. Therefore, Web Parts may not work once installed on the destination server.Create a custom policy file for your assemblies. For more information, see "How do I create a custom policy file?" Recommended approach.This option is most secure.An assembly can operate with a unique policy that meets the minimum permission requirements for the assembly.By creating a custom security policy, you can ensure the destination server can run your Web Parts.Requires the most configuration of all three options. Install your assemblies in the GACEasy to implement. This grants Full trust to your assembly without affecting the trust level of assemblies installed in the BIN directory.This option is less secure.Assemblies installed in the GAC are available to all virtual servers and applications on a server running Windows SharePoint Services. This could represent a potential security risk as it potentially grants a higher level of permission to your assembly across a larger scope than necessaryIn a development environment, you must reset IIS every time you recompile assemblies.Licensing issues may arise due to the global availability of your assembly.
48.Does SharePoint work with NFS?
Yes and no. It can crawl documents on an NFS volume, but the sharepoint database or logs cannot be stored there.
49.How is SharePoint Portal Server different from the Site Server?
Site Server has search capabilities but these are more advanced using SharePoint. SPS uses digital dashboard technology which provides a nice interface for creating web parts and showing them on dashboards (pages). SS doesn't have anything as advanced as that. The biggest difference would be SPS document management features which also integrate with web folders and MS Office.
50.What would you like to see in the next version of SharePoint?
A few suggestions:SPS and STS on same machineTree view of Categories and FoldersGeneral Discussion Web PartPersonalization of DashboardsRole CustomizationEmail to say WHY a document has been rejected for ApprovalMore ways to customize the interfaceBackup and restore an individual WorkspacesFilter for VisioBetter way to track activity on SPSAbility to Save as from Adobe to space on My Network Places
51.Why Sharepoint is not a viable solution for enterprise wide deployments?
Planning an enterprise deployment using SharePoint features is a very difficult task unless you can establish a Service Oriented Architecture, using AD for managing security with well defined roles based information access(EISA). Sounds reasonable, although it seems difficult to deploy with the tools limitations in document storage.Document management does not scale beyond a single server, but scales great within a single server. For example, a quad Xeon machine with 4GB of RAM works great for a document management server that has about 900,000 - 1,000,000 document, but if you need to store 50,000,000 document and want to have them all in one single workspace then it does not scale at all. If you need a scenario like this, you need to plan your deployment right and it should scale for you, it just does not right out of the box. If you are using your server as a portal and search server most for the most part it scales great. You can have many different servers crawl content sources and have separate servers searching and serving the content.
If you have < 750,000 documents per server and fewer than 4 content sources and fewer than 50,000 users, SPS should scale just fine for your needs with the proper planning.
52.What are the actual advantages of SharePoint Portal Services (SPS) over SharePoint Team Services (STS)?
SharePoint Portal Services (SPS) has MUCH better document management. It has check-in, check-out, versioning, approval, publishing, subscriptions, categories, etc. STS does not have these features, or they are very scaled back. SharePoint team Services (SPS) has a better search engine, and can crawl multiple content sources. STS cannot. STS is easier to manage and much better for a team environment where there is not much Document Management going on. SPS is better for an organization, or where Document Management is crucial.
53.How Does SharePoint work?
The browser sends a DAV packet to IIS asking to perform a document check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the proprietary INVOKE command. Because of the existence of this command, the packet is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB to access the WSS, perform the operation and send the results back to the user in the form of XML.
54.How do I open an older version of a document?
Normally, all previous versions are located in the shadow, so if you right click a published document from within the web folders, go to properties and then the third tab, versions you can view older versions.If you want to do this in code: strURL = "url of the last published version"Set oVersion = New PKMCDO.KnowledgeVersionSet prmRs = oVersion.VersionHistory(strURL)Set oVersion = NothingprmRS will contain a recordset, which contains the url to the old versions in the shadow.
55.Why do the workspace virtual directories show the error “stop sign” symbol in the IIS snap-in?
If World Wide Web Publishing Service (W3SVC) starts before Microsoft Exchange Information Store (MSExchangeIS), “stop sign” symbols appear under the Default Web Site folder of the Internet Information Services console in Microsoft Management Console (MMC).There is a dependency between the local paths of the SharePoint Portal Server virtual directories and the MSExchangeIS. You must start MSExchangeIS first, followed by W3SVC.Complete the following steps to prevent the stop signs from appearing each time you restart:Change the Startup type for W3SVC to Manual.Restart the server. The MSExchangeIS service starts automatically.Start W3SVC.
56.What newsgroups are available?
There are two,microsoft.public.sharepoint.portalserver andmicrosoft.public.sharepoint.portalserver.development.
57.What is SharePoint from a Technical Perspective?
Technically SharePoint illustrates neatly what Microsoft's .net strategy is all about: integrating Windows with the Web. Microsoft has previously made accessing stuff on a PC easier, (Windows) then on a network (NT) and now on the web (.NET). SharePoint is an application written to let a user access a web accessible directory tree called the Web Storage System.SharePoint was written with a set of technologies that allow the programmer to pass data, functions, parameters over HTTP, the web's medium. These are XML, XSL and SOAP, to name a few I understand the basics of!To the user it looks easy, like Hotmail, but every time they click a button or a link, a lot has to happen behind the scenes to do what they want to do quickly and powerfully. Not as easy as you might think, but SharePoint does it for you. Accessing this Web storage system and the server itself is also done using technologies like ADO, CDO, PKMCDO, LDAP, DDSC, ADSC. More on these later. SharePoint is a great example of how the Internet Platform can be extended and integrated into an existing well adopted technology, Windows.
58.What is SharePoint from an Administration Perspective?
Administering SharePoint mainly consists of setting it up, which is much easier than you expect, adding the content, which can be just dragging and dropping in whole directory structures and files, and then organizing the files better by giving them categories or other metadata. This is done either through the Web interface or through the SharePoint Client: a program what means you can access SharePoint as a Web folder and then right-click files to select options like "edit profile". Or add files by dragging them in individually or in bulk.Setting the security is also important, using NT accounts, either NT4 or Active Directory (or both in mixed mode) you can give users access to files/folders the same way as you do in standard Windows. Users can be grouped and the groups given access privileges to help manage this better. Also SharePoint has 3 Roles that a User or Group can be given on a particular item. Readers can see the item (i.e. document/file or folder) but not change it, Authors can see and edit items and coordinators can set security privileges for the part of the system they have control over. Thus, you could set 12 different coordinators for 12 different folder trees, and they could manage who can do what within that area only.
59.What is SharePoint from a Users Perspective?
From a Users perspective SharePoint is a way of making documents and folders on the Windows platform accessible over the web. The user visits the SharePoint Portal web page, and from there they can add documents, change documents & delete documents. Through this Portal, these documents are now available for discussion, collaboration, versioning and being managed through a workflow. Hence the name "Share-Point". Details about the document can be saved too, such as: who wrote it, when, for whom, its size, and version, category or target audience. These can then be used to find the document through SharePoint's Search facility. Even documents not "in" SharePoint can be included in the search engine's index so they become part of the portal. All in all, it's a great way to get stuff up on the web for users with average technical skills, and for administrators to manage the content.
60.What are the various Sharepoint 2003 and Exchange integration points?
Link to OutlookThis is a button on contacts or events lists that lets Outlook 2003 add a pst file named Sharepoint Folders and it links to the data on the site. It’s read-only, but you could make the home page for that PST be the Sharepoint site for easier viewing. The link to outlook feature seems more to be where some can public a calendar, but not want too much collaboration. For example, a holiday schedule, company meeting schedule, etc, can be made available for people to be able to view from Outlook without having to go to a web browser. Another nice thing about OL2K3 is that you can compare these calendars with others side by side.
61.Searching Public Folders
With SPS you can index Exchange’s public folders with the search engine so that all that precious public folder content is searchable. You’ll want to look at content sources and indexing in Sharepoint administration.
62.Displaying Public Folders in a web partSince exchange web-enables public folders, you can create a web part that displays that content. IE, http://exchangeserver/Public/IT/Helpdesk will display the IT/Helpdesk public folder via OWA. So you add the Page Viewer web part to a page and point it at that URL. The key here is to add ?cmd=contents to the end of the url if you don’t want the navigator pane on the left.
63.Smart web parts
Some of the web parts that come with SPS allow you to add a web part to a page that actually takes the users outlook info (calendar, inbox, contacts, tasks) and put them into the page.The SmartPart Web Part project template for Visual Studio allows developers to create quickly a project which contains the base infrastructure to: * write a web user control (ASCX)* wrap the user control in a SmartPart instance* generate a SharePoint Solution file (WSP) for easy deployment* generate a setup package for a wizard driven installation]
64.Can SharePoint compare two document versions?
"In Word 2003, you can compare documents side by side. Open two documents. Then, from the Window menu of one of them, select the Compare Side By Side command. If you have only two documents open, the command will automatically choose to compare them. If you have three or more documents open, you'll have to select which document to compare with the current file.A floating toolbar with two buttons will open. If the button on the left is selected, Word will scroll both documents at the same time. Press the button on the right side of the toolbar to return to where the cursor was located when you started comparing."
65.What are the integration differences between SPS 2003 and the various Office versions?
SPS webpage can detect you have installed the Office 2003 and run local dll to implement some SPS function, e.g. multi-file upload only works when you have office 2003 installed.Integration with Office XP is gone.You will get guys telling you that you can integrate with SPSv2 if you install a backwards compatible document library - but that’s really just putting a bit of SPS 2001 on the server.Believe me, check-in, check-out, which are themselves very basic, are not available from inside Office XP, or even from the context menu in Windows Explorer.The ONLY option you have is to use the web interface to check-in or check-out.
How is it related to Microsoft Office SharePoint Server 2007?Windows SharePoint Services is the solution that enables you to create Web sites for information sharing and document collaboration. Windows SharePoint Services -- a key piece of the information worker infrastructure delivered in Microsoft Windows Server 2003 -- provides additional functionality to the Microsoft Office system and other desktop applications, and it serves as a platform for application development.Office SharePoint Server 2007 builds on top of Windows SharePoint Services 3.0 to provide additional capabilities including collaboration, portal, search, enterprise content management, business process and forms, and business intelligence.
2. What is Microsoft SharePoint Portal Server?
SharePoint Portal Server is a portal server that connects people, teams, and knowledge across business processes. SharePoint Portal Server integrates information from various systems into one secure solution through single sign-on and enterprise application integration capabilities. It provides flexible deployment and management tools, and facilitates end-to-end collaboration through data aggregation, organization, and searching. SharePoint Portal Server also enables users to quickly find relevant information through customization and personalization of portal content and layout as well as through audience targeting.
3. What is Microsoft Windows Services?
Microsoft Windows Services is the engine that allows administrators to create Web sites for information sharing and document collaboration. Windows SharePoint Services provides additional functionality to the Microsoft Office System and other desktop applications, as well as serving as a plat form for application development. SharePoint sites provide communities for team collaboration, enabling users to work together on documents, tasks, and projects. The environment for easy and flexible deployment, administration, and application development.
4. What is the relationship between Microsoft SharePoint Portal Server and Microsoft Windows Services?
Microsoft SharePoint Products and Technologies (including SharePoint Portal Server and Windows SharePoint Services) deliver highly scalable collaboration solutions with flexible deployment and management tools. Windows SharePoint Services provides sites for team collaboration, while Share Point Portal Server connects these sites, people, and business processes—facilitating knowledge sharing and smart organizations. SharePoint Portal Server also extends the capabilities of Windows SharePoint Services by providing organizational and management tools for SharePoint sites, and by enabling teams to publish information to the entire organization.
5. Who is Office SharePoint Server 2007 designed for?
Office SharePoint Server 2007 can be used by information workers, IT administrators, and application developers. is designed
6. What are the main benefits of Office SharePoint Server 2007?
Office SharePoint Server 2007 provides a single integrated platform to manage intranet, extranet, and Internet applications across the enterprise.Business users gain greater control over the storage, security, distribution, and management of their electronic content, with tools that are easy to use and tightly integrated into familiar, everyday applications.Organizations can accelerate shared business processes with customers and partners across organizational boundaries using InfoPath Forms Services–driven solutions.Information workers can find information and people efficiently and easily through the facilitated information-sharing functionality and simplified content publishing. In addition, access to back-end data is achieved easily through a browser, and views into this data can be personalized.Administrators have powerful tools at their fingertips that ease deployment, management, and system administration, so they can spend more time on strategic tasks.Developers have a rich platform to build a new class of applications, called Office Business Applications, that combine powerful developer functionality with the flexibility and ease of deployment of Office SharePoint Server 2007. Through the use of out-of-the-box application services, developers can build richer applications with less code.
7. What is the difference between Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007?
Microsoft Office SharePoint Server 2007 for Internet sites and Microsoft Office SharePoint Server 2007 have identical feature functionality. While the feature functionality is similar, the usage rights are different.If you are creating an Internet, or Extranet, facing website, it is recommended that you use Microsoft Office SharePoint Server 2007 for Internet sites which does not require the purchase client access licenses. Websites hosted using an “Internet sites” edition can only be used for Internet facing websites and all content, information, and applications must be accessible to non-employees. Websites hosted using an “Internet sites” edition cannot be accessed by employees creating, sharing, or collaborating on content which is solely for internal use only, such as an Intranet Portal scenario. See the previous section on licensing for more information on the usage scenarios.
8. What suites of the 2007 Microsoft Office system work with Office SharePoint Server 2007?
Office Outlook 2007 provides bidirectional offline synchronization with SharePoint document libraries, discussion groups, contacts, calendars, and tasks.Microsoft Office Groove 2007, included as part of Microsoft Office Enterprise 2007, will enable bidirectional offline synchronization with SharePoint document libraries.Features such as the document panel and the ability to publish to Excel Services will only be enabled when using Microsoft Office Professional Plus 2007or Office Enterprise 2007.Excel Services will only work with documents saved in the new Office Excel 2007 file format (XLSX).
9. How do I invite users to join a Windows SharePoint Services Site? Is the site secure?
SharePoint-based Web sites can be password-protected to restrict access to registered users, who are invited to join via e-mail. In addition, the site administrator can restrict certain members' roles by assigning different permission levels to view post and edit.
10.Can I post any kind of document?
You can post documents in many formats, including .pdf, .htm and .doc. In addition, if you are using Microsoft Office XP, you can save documents directly to your Windows SharePoint Services site.
11.Can I download information directly from a SharePoint site to a personal digital assistant (PDA)?
No you cannot. However, you can exchange contact information lists with Microsoft Outlook.
12.How long does it take to set up the initial team Web site?
It only takes a few minutes to create a complete Web site. Preformatted forms let you and your team members contribute to the site by filling out lists. Standard forms include announcements, events, contacts, tasks, surveys, discussions and links.
13.Can I create custom templates?
Yes you can. You can have templates for business plans, doctor's office, lawyer's office etc.
14.How can I make my site public?
By default, all sites are created private.If you want your site to be a public Web site, enable anonymous access for the entire site. Then you can give out your URL to anybody in your business card, e-mail or any other marketing material. The URL for your Web site will be: http:// yoursitename.wss.bcentral.comHence, please take special care to name your site. These Web sites are ideal for information and knowledge intensive sites and/or sites where you need to have shared Web workspace. Remember: Under each parent Web site, you can create up to 10 sub-sites each with unique permissions, settings and security rights.
15.How do the sub sites work?
You can create a sub site for various categories. For example:Departments - finance, marketing, ITProducts - electrical, mechanical, hydraulicsProjects - Trey Research, Department of Transportation, FDATeam - Retention team, BPR teamClients - new clients, old clientsSuppliers - Supplier 1, Supplier 2, Supplier 3Customers - Customer A, Customer B, Customer CReal estate - property A, property BThe URLs for each will be, for example:http://yoursitename.wss.bcentral.com/financehttp://yoursitename.wss.bcentral.com/marketingYou can keep track of permissions for each team separately so that access is restricted while maintaining global access to the parent site.
16.How do I make my site non-restricted?
If you want your site to have anonymous access enabled (i.e., you want to treat it like any site on the Internet that does not ask you to provide a user name and password to see the content of the site), follow these simple steps:Login as an administratorClick on site settingsClick on Go to Site AdministrationClick on Manage anonymous accessChoose one of the three conditions on what Anonymous users can access:Entire Web siteLists and librariesNothingDefault condition is nothing; your site has restricted access. The default conditions allow you to create a secure site for your Web site.
17.Can I get domain name for my Web site?
Unfortunately, no. At this point, we don't offer domain names for SharePoint sites. But very soon we will be making this available for all our SharePoint site customers. Please keep checking this page for further update on this. Meanwhile, we suggest you go ahead and set up your site and create content for it.
18.What are picture libraries?
Picture libraries allow you to access a photo album and view it as a slide show or thumbnails or a film strip. You can have separate folder for each event, category, etc
19.What are the advantages of a hosted SharePoint vs. one that is on an in-house server?
No hardware investment, i.e. lower costsNo software to download - ready to start from the word goNo IT resources - Anyone who has used a Web program like Hotmail can use itFaster deployment
20.Can I ask users outside of my organization to participate in my Windows SharePoint Services site?
Yes. You can manage this process using the Administration Site Settings. Simply add users via their e-mail alias and assign permissions such as Reader or Contributor.
21.Are there any IT requirements or downloads required to set up my SharePoint site?
No. You do not need to download any code or plan for any IT support. Simply complete the on-line signup process and provide us your current and correct email address. Once you have successfully signed up and your site has been provisioned, we will send a confirmation to the email address you provided.
22.I am located outside of the United States. Are there any restrictions or requirements for accessing the Windows SharePoint Services?
No. There are no system or bandwidth limitations for international trial users. Additionally language packs have been installed which allow users to set up sub-webs in languages other than English. These include: Arabic, Danish, Dutch, Finnish, French, German, Hebrew, Italian, Japanese, Polish, Portuguese (Brazilian), Spanish and Swedish.
23.Are there any browser recommendations?
Yes. Microsoft recommends using the following browsers for viewing and editing Windows SharePoint Services sites: Microsoft Internet Explorer 5.01 with Service Pack 2, Microsoft Internet Explorer 5.5 with Service Pack 2, Internet Explorer 6, Netscape Navigator 6.2 or later.
24.What security levels are assigned to users?
Security levels are assigned by the administrator who is adding the user. There are four levels by default and additional levels can be composed as necessary.Reader - Has read-only access to the Web site.Contributor - Can add content to existing document libraries and lists.Web Designer - Can create lists and document libraries and customize pages in the Web site.Administrator - Has full control of the Web site.
25.How secure are Windows SharePoint Services sites hosted by Microsoft?
Microsoft Windows SharePoint Services Technical security measures provide firewall protection, intrusion detection, and web-publishing rules. The Microsoft operation center team tests and deploys software updates in order to maintain the highest level of security and software reliability. Software hot-fixes and service packs are tested and deployed based on their priority and level of risk. Security related hot-fixes are rapidly deployed into the environment to address current threats. A comprehensive software validation activity ensures software stability through regression testing prior to deployment.
26.What is the difference between an Internet and an intranet site?
An internet site is a normal site that anyone on the internet can access (e.g., www.msn.com, www.microsoft.com, etc.). You can set up a site for your company that can be accessed by anyone without any user name and password. The internet is used for public presence and a primary marketing tool managed typically by web programmers and a system administrator.An intranet (or internal network), though hosted on a Web site, can only be accessed by people who are members of a specific network. They need to have a login and password that was assigned to them when they were added to the site by the site administrator. The intranet is commonly used as an internal tool for giving employees access to company information. Content is driven by business relevance, business rules and has increasingly become a common tool in larger organizations. An intranet is becoming more and more the preferred method for employees to interact with each other and the central departments in an organization, whether or not the organization has a Web presence.
27.What is a workspace?
A site or workspace is when you want a new place for collaborating on Web pages, lists and document libraries. For example, you might create a site to manage a new team or project, collaborate on a document or prepare for a meeting.
28.What are the various kinds of roles the users can have?
A user can be assigned one of the following rolesReader - Has read-only access to the Web site.Contributor - Can add content to existing document libraries and lists.Web Designer - Can create lists and document libraries and customize pages in the Web site.Administrator - Has full control of the Web site.
29.Can more than one person use the same login?
If the users sharing that login will have the same permissions and there is no fear of them sharing a password, then yes. Otherwise, this is discouraged.
30.How customizable is the user-to-user access?
User permissions apply to an entire Web, not to documents themselves. However, you can have additional sub webs that can optionally have their own permissions. Each user can be given any of four default roles. Additional roles can be defined by the administrator.
31.Can each user have access to their own calendar?
Yes there are two ways to do this,by creating a calendar for each user, orby creating a calendar with a view for each user
32.How many files can I upload?
There is no restriction in place except that any storage consumed beyond that provided by the base offering may have an additional monthly charge associated with them.
33.What types of files can I upload / post to the site?
The only files restricted are those ending with the following extensions: .asa, .asp, .ida, .idc, .idq. Microsoft reserves the right to add additional file types to this listing at any time. Also, no content that violates the terms of service may be uploaded or posted to the site.
34.Can SharePoint be linked to an external data source?
SharePoint data can be opened with Access and Excel as an external data source. Thus, SharePoint can be referenced as an external data source. SharePoint itself cannot reference an external data source.
35.Can SharePoint be linked to a SQL database?
SharePoint 2007 Portal Server (MOSS2K7) allows connections to SQL based datasources via the Business Data Catalog (BDC). The BDC also allows connecting to data via Web Services.
36.Can I customize my Windows SharePoint Services site?
YES! Windows SharePoint Services makes updating sites and their content from the browser easier then ever.SharePoint includes tools that let you create custom lists, calendars, page views, etc. You can apply a theme; add List, Survey and Document Library Web Parts to a page; create personal views; change logos; connect Web Parts and more.To fully customize your site, you can use Microsoft FrontPage 2003. Specifically, you can use FrontPage themes and shared borders, and also use FrontPage to create photo galleries and top ten lists, utilize standard usage reports, and integrate automatic Web content.
37.Will Microsoft Office SharePoint Server 2007 run on a 64-bit version of Microsoft Windows?
Windows SharePoint Services 3.0, Office SharePoint Server 2007, Office Forms Server 2007, and Office SharePoint Server 2007 for Search will support 64-bit versions of Windows Server 2003.
38.How Office SharePoint Server 2007 can help you?
Office SharePoint Server 2007 can help us:Manage content and streamline processes. Comprehensively manage and control unstructured content like Microsoft Office documents, Web pages, Portable Document Format file (PDF) files, and e-mail messages. Streamline business processes that are a drain on organizational productivity.Improve business insight. Monitor your business, enable better-informed decisions, and respond proactively to business events.Find and share information more simply. Find information and expertise wherever they are located. Share knowledge and simplify working with others within and across organizational boundaries.Empower IT to make a strategic impact. Increase responsiveness of IT to business needs and reduce the number of platforms that have to be maintained by supporting all the intranet, extranet, and Web applications across the enterprise with one integrated platform.Office SharePoint Server 2007 capabilities can help improve organizational effectiveness by connecting people, processes, and information.Office SharePoint Server 2007 provides these capabilities in an integrated server offering, so your organization doesn't have to integrate fragmented technology solutions itself.
39.What are the features that the portal components of Office SharePoint Server 2007 include?
The portal components of Office SharePoint Server 2007 include features that are especially useful for designing, deploying, and managing enterprise intranet portals, corporate Internet Web sites, and divisional portal sites. The portal components make it easier to connect to people within the organization who have the right skills, knowledge, and project experience.
40.What are the advanced features of MOSS 2007?
User Interface (UI) and navigation enhancementsDocument management enhancementsThe new Workflow engineOffice 2007 IntegrationNew Web PartsNew Site-type templatesEnhancements to List technologyWeb Content ManagementBusiness Data CatalogSearch enhancementsReport CenterRecords ManagementBusiness Intelligence and Excel ServerForms Server and InfoPathThe “Features” featureAlternate authentication providers and Forms-based authentication
41.What are the features of the new Content management in Office SharePoint 2007?
The new and enhanced content management features in Office SharePoint Server 2007 fall within three areas:Document managementRecords managementWeb content managementOffice SharePoint Server 2007 builds on the core document management functionality provided by Windows SharePoint Services 3.0, including check in and check out, versioning, metadata, and role-based granular access controls. Organizations can use this functionality to deliver enhanced authoring, business document processing, Web content management and publishing, records management, policy management, and support for multilingual publishing.
42.Does a SharePoint Web site include search functionality?
Yes. SharePoint Team Services provides a powerful text-based search feature that helps you find documents and information fast.
43.Write the features of the search component of Office SharePoint Server 2007?
The search component of Office SharePoint Server 2007 has been significantly enhanced by this release of SharePoint Products and Technologies. New features provide:A consistent and familiar search experience.Increased relevance of search results.New functions to search for people and expertise.Ability to index and search data in line-of-business applications andImproved manageability and extensibility.
44.What are the benefits of Microsoft Office SharePoint Server 2007?
Provide a simple, familiar, and consistent user experience.Boost employee productivity by simplifying everyday business activities.Help meet regulatory requirements through comprehensive control over content.Effectively manage and repurpose content to gain increased business value.Simplify organization-wide access to both structured and unstructured information across disparate systems.Connect people with information and expertise.Accelerate shared business processes across organizational boundaries.Share business data without divulging sensitive information.Enable people to make better-informed decisions by presenting business-critical information in one central location.Provide a single, integrated platform to manage intranet, extranet, and Internet applications across the enterprise.
45.Will SharePoint Portal Server and Team Services ever merge?
The products will come together because they are both developed by the Office team.
46.What does partial trust mean the Web Part developer?
If an assembly is installed into the BIN directory, the code must be ensured that provides error handling in the event that required permissions are not available. Otherwise, unhandled security exceptions may cause the Web Part to fail and may affect page rendering on the page where the Web Part appears.
47.How can I raise the trust level for assemblies installed in the BIN directory?
Windows SharePoint Services can use any of the following three options from ASP.NET and the CLR to provide assemblies installed in the BIN directory with sufficient permissions. The following table outlines the implications and requirements for each option.Option Pros ConsIncrease the trust level for the entire virtual server. For more information, see "Setting the trust level for a virtual server" Easy to implement.In a development environment, increasing the trust level allows you to test an assembly with increased permissions while allowing you to recompile assemblies directly into the BIN directory without resetting IIS. This option is least secure.This option affects all assemblies used by the virtual server. There is no guarantee the destination server has the required trust level. Therefore, Web Parts may not work once installed on the destination server.Create a custom policy file for your assemblies. For more information, see "How do I create a custom policy file?" Recommended approach.This option is most secure.An assembly can operate with a unique policy that meets the minimum permission requirements for the assembly.By creating a custom security policy, you can ensure the destination server can run your Web Parts.Requires the most configuration of all three options. Install your assemblies in the GACEasy to implement. This grants Full trust to your assembly without affecting the trust level of assemblies installed in the BIN directory.This option is less secure.Assemblies installed in the GAC are available to all virtual servers and applications on a server running Windows SharePoint Services. This could represent a potential security risk as it potentially grants a higher level of permission to your assembly across a larger scope than necessaryIn a development environment, you must reset IIS every time you recompile assemblies.Licensing issues may arise due to the global availability of your assembly.
48.Does SharePoint work with NFS?
Yes and no. It can crawl documents on an NFS volume, but the sharepoint database or logs cannot be stored there.
49.How is SharePoint Portal Server different from the Site Server?
Site Server has search capabilities but these are more advanced using SharePoint. SPS uses digital dashboard technology which provides a nice interface for creating web parts and showing them on dashboards (pages). SS doesn't have anything as advanced as that. The biggest difference would be SPS document management features which also integrate with web folders and MS Office.
50.What would you like to see in the next version of SharePoint?
A few suggestions:SPS and STS on same machineTree view of Categories and FoldersGeneral Discussion Web PartPersonalization of DashboardsRole CustomizationEmail to say WHY a document has been rejected for ApprovalMore ways to customize the interfaceBackup and restore an individual WorkspacesFilter for VisioBetter way to track activity on SPSAbility to Save as from Adobe to space on My Network Places
51.Why Sharepoint is not a viable solution for enterprise wide deployments?
Planning an enterprise deployment using SharePoint features is a very difficult task unless you can establish a Service Oriented Architecture, using AD for managing security with well defined roles based information access(EISA). Sounds reasonable, although it seems difficult to deploy with the tools limitations in document storage.Document management does not scale beyond a single server, but scales great within a single server. For example, a quad Xeon machine with 4GB of RAM works great for a document management server that has about 900,000 - 1,000,000 document, but if you need to store 50,000,000 document and want to have them all in one single workspace then it does not scale at all. If you need a scenario like this, you need to plan your deployment right and it should scale for you, it just does not right out of the box. If you are using your server as a portal and search server most for the most part it scales great. You can have many different servers crawl content sources and have separate servers searching and serving the content.
If you have < 750,000 documents per server and fewer than 4 content sources and fewer than 50,000 users, SPS should scale just fine for your needs with the proper planning.
52.What are the actual advantages of SharePoint Portal Services (SPS) over SharePoint Team Services (STS)?
SharePoint Portal Services (SPS) has MUCH better document management. It has check-in, check-out, versioning, approval, publishing, subscriptions, categories, etc. STS does not have these features, or they are very scaled back. SharePoint team Services (SPS) has a better search engine, and can crawl multiple content sources. STS cannot. STS is easier to manage and much better for a team environment where there is not much Document Management going on. SPS is better for an organization, or where Document Management is crucial.
53.How Does SharePoint work?
The browser sends a DAV packet to IIS asking to perform a document check in. PKMDASL.DLL, an ISAPI DLL, parses the packet and sees that it has the proprietary INVOKE command. Because of the existence of this command, the packet is passed off to msdmserv.exe, who in turn processes the packet and uses EXOLEDB to access the WSS, perform the operation and send the results back to the user in the form of XML.
54.How do I open an older version of a document?
Normally, all previous versions are located in the shadow, so if you right click a published document from within the web folders, go to properties and then the third tab, versions you can view older versions.If you want to do this in code: strURL = "url of the last published version"Set oVersion = New PKMCDO.KnowledgeVersionSet prmRs = oVersion.VersionHistory(strURL)Set oVersion = NothingprmRS will contain a recordset, which contains the url to the old versions in the shadow.
55.Why do the workspace virtual directories show the error “stop sign” symbol in the IIS snap-in?
If World Wide Web Publishing Service (W3SVC) starts before Microsoft Exchange Information Store (MSExchangeIS), “stop sign” symbols appear under the Default Web Site folder of the Internet Information Services console in Microsoft Management Console (MMC).There is a dependency between the local paths of the SharePoint Portal Server virtual directories and the MSExchangeIS. You must start MSExchangeIS first, followed by W3SVC.Complete the following steps to prevent the stop signs from appearing each time you restart:Change the Startup type for W3SVC to Manual.Restart the server. The MSExchangeIS service starts automatically.Start W3SVC.
56.What newsgroups are available?
There are two,microsoft.public.sharepoint.portalserver andmicrosoft.public.sharepoint.portalserver.development.
57.What is SharePoint from a Technical Perspective?
Technically SharePoint illustrates neatly what Microsoft's .net strategy is all about: integrating Windows with the Web. Microsoft has previously made accessing stuff on a PC easier, (Windows) then on a network (NT) and now on the web (.NET). SharePoint is an application written to let a user access a web accessible directory tree called the Web Storage System.SharePoint was written with a set of technologies that allow the programmer to pass data, functions, parameters over HTTP, the web's medium. These are XML, XSL and SOAP, to name a few I understand the basics of!To the user it looks easy, like Hotmail, but every time they click a button or a link, a lot has to happen behind the scenes to do what they want to do quickly and powerfully. Not as easy as you might think, but SharePoint does it for you. Accessing this Web storage system and the server itself is also done using technologies like ADO, CDO, PKMCDO, LDAP, DDSC, ADSC. More on these later. SharePoint is a great example of how the Internet Platform can be extended and integrated into an existing well adopted technology, Windows.
58.What is SharePoint from an Administration Perspective?
Administering SharePoint mainly consists of setting it up, which is much easier than you expect, adding the content, which can be just dragging and dropping in whole directory structures and files, and then organizing the files better by giving them categories or other metadata. This is done either through the Web interface or through the SharePoint Client: a program what means you can access SharePoint as a Web folder and then right-click files to select options like "edit profile". Or add files by dragging them in individually or in bulk.Setting the security is also important, using NT accounts, either NT4 or Active Directory (or both in mixed mode) you can give users access to files/folders the same way as you do in standard Windows. Users can be grouped and the groups given access privileges to help manage this better. Also SharePoint has 3 Roles that a User or Group can be given on a particular item. Readers can see the item (i.e. document/file or folder) but not change it, Authors can see and edit items and coordinators can set security privileges for the part of the system they have control over. Thus, you could set 12 different coordinators for 12 different folder trees, and they could manage who can do what within that area only.
59.What is SharePoint from a Users Perspective?
From a Users perspective SharePoint is a way of making documents and folders on the Windows platform accessible over the web. The user visits the SharePoint Portal web page, and from there they can add documents, change documents & delete documents. Through this Portal, these documents are now available for discussion, collaboration, versioning and being managed through a workflow. Hence the name "Share-Point". Details about the document can be saved too, such as: who wrote it, when, for whom, its size, and version, category or target audience. These can then be used to find the document through SharePoint's Search facility. Even documents not "in" SharePoint can be included in the search engine's index so they become part of the portal. All in all, it's a great way to get stuff up on the web for users with average technical skills, and for administrators to manage the content.
60.What are the various Sharepoint 2003 and Exchange integration points?
Link to OutlookThis is a button on contacts or events lists that lets Outlook 2003 add a pst file named Sharepoint Folders and it links to the data on the site. It’s read-only, but you could make the home page for that PST be the Sharepoint site for easier viewing. The link to outlook feature seems more to be where some can public a calendar, but not want too much collaboration. For example, a holiday schedule, company meeting schedule, etc, can be made available for people to be able to view from Outlook without having to go to a web browser. Another nice thing about OL2K3 is that you can compare these calendars with others side by side.
61.Searching Public Folders
With SPS you can index Exchange’s public folders with the search engine so that all that precious public folder content is searchable. You’ll want to look at content sources and indexing in Sharepoint administration.
62.Displaying Public Folders in a web partSince exchange web-enables public folders, you can create a web part that displays that content. IE, http://exchangeserver/Public/IT/Helpdesk will display the IT/Helpdesk public folder via OWA. So you add the Page Viewer web part to a page and point it at that URL. The key here is to add ?cmd=contents to the end of the url if you don’t want the navigator pane on the left.
63.Smart web parts
Some of the web parts that come with SPS allow you to add a web part to a page that actually takes the users outlook info (calendar, inbox, contacts, tasks) and put them into the page.The SmartPart Web Part project template for Visual Studio allows developers to create quickly a project which contains the base infrastructure to: * write a web user control (ASCX)* wrap the user control in a SmartPart instance* generate a SharePoint Solution file (WSP) for easy deployment* generate a setup package for a wizard driven installation]
64.Can SharePoint compare two document versions?
"In Word 2003, you can compare documents side by side. Open two documents. Then, from the Window menu of one of them, select the Compare Side By Side command. If you have only two documents open, the command will automatically choose to compare them. If you have three or more documents open, you'll have to select which document to compare with the current file.A floating toolbar with two buttons will open. If the button on the left is selected, Word will scroll both documents at the same time. Press the button on the right side of the toolbar to return to where the cursor was located when you started comparing."
65.What are the integration differences between SPS 2003 and the various Office versions?
SPS webpage can detect you have installed the Office 2003 and run local dll to implement some SPS function, e.g. multi-file upload only works when you have office 2003 installed.Integration with Office XP is gone.You will get guys telling you that you can integrate with SPSv2 if you install a backwards compatible document library - but that’s really just putting a bit of SPS 2001 on the server.Believe me, check-in, check-out, which are themselves very basic, are not available from inside Office XP, or even from the context menu in Windows Explorer.The ONLY option you have is to use the web interface to check-in or check-out.
Adding validation to a custom list control in Sharepoint
Adding validation to a custom list control in Sharepoint
You should know how to create a Sharepoint list and how to open the site in Sharepoint designer.
1. Following is a list with Email fields. Let's say we have to validate so that only a valid email can be entered. If not valid then the Error Message appears next to the field
2. Now open the site in the sharepoint designer and then expand the list and open the Newform.aspx of the list to be validated
3. As you can see in the image above the Newform.aspx of Validation list is being opened in the sharepoint Designer.
4. Now right click on this Validation list web part in sharepoint Designer and choose Web Part properties.
5. The properties dialog box will open for the Validation list here. Choose Hidden under layout and say ok. (This web part can be deleted as well, but due to some Known problems because of deletion it is best to hide this).
6. Now click exactly underneath the hidden list web part and go to Insert->Sharepoint Controls-> Custom List Form… and Wizard will ask to choose a List or Document Library form on based Of existing list. Choose your Validation list and select New item form under type of from to create option and hit Ok.
7. You will get the Validation List underneath the hidden list as shown as selected image below.
8. Now from here we can customize all the controls based on requirement. As we are customizing the E-Mail Field, right click on the email field box and choose Show common control tasks from the context menu.
9. This will give you Common Formfield tasks option as shown below next to Email field. Here we can change. The format of the data field selected (default is List form field). As we need Email field to be textbox where validation can be applied Choose Textbox from Format as dropdown instead of List form field.
10.After the above step, List will look like this (custom formatted)
11.Now drop a RegularExpressionValidator control from the Validation option under ASP.Net controls from the toolbar .
12.Now specify the required properties (such as ControlToValidate, ErrorMessage, SetFocusOnError to true, Validate Expression) of the RegularExpressionValidator from the Tag Properties toolbar. For ControlToValidate choose the ID of the Email fieldAfter selecting it and getting the ID from the Tag Properties toolbar as you do in Visual Studio. See below the set attributes in blue For the Email Field .
13.Now Save the changes and go back to the list in IE and try to type in invalid email id and you will get following .
You should know how to create a Sharepoint list and how to open the site in Sharepoint designer.
1. Following is a list with Email fields. Let's say we have to validate so that only a valid email can be entered. If not valid then the Error Message appears next to the field
2. Now open the site in the sharepoint designer and then expand the list and open the Newform.aspx of the list to be validated
3. As you can see in the image above the Newform.aspx of Validation list is being opened in the sharepoint Designer.
4. Now right click on this Validation list web part in sharepoint Designer and choose Web Part properties.
5. The properties dialog box will open for the Validation list here. Choose Hidden under layout and say ok. (This web part can be deleted as well, but due to some Known problems because of deletion it is best to hide this).
6. Now click exactly underneath the hidden list web part and go to Insert->Sharepoint Controls-> Custom List Form… and Wizard will ask to choose a List or Document Library form on based Of existing list. Choose your Validation list and select New item form under type of from to create option and hit Ok.
7. You will get the Validation List underneath the hidden list as shown as selected image below.
8. Now from here we can customize all the controls based on requirement. As we are customizing the E-Mail Field, right click on the email field box and choose Show common control tasks from the context menu.
9. This will give you Common Formfield tasks option as shown below next to Email field. Here we can change. The format of the data field selected (default is List form field). As we need Email field to be textbox where validation can be applied Choose Textbox from Format as dropdown instead of List form field.
10.After the above step, List will look like this (custom formatted)
11.Now drop a RegularExpressionValidator control from the Validation option under ASP.Net controls from the toolbar .
12.Now specify the required properties (such as ControlToValidate, ErrorMessage, SetFocusOnError to true, Validate Expression) of the RegularExpressionValidator from the Tag Properties toolbar. For ControlToValidate choose the ID of the Email fieldAfter selecting it and getting the ID from the Tag Properties toolbar as you do in Visual Studio. See below the set attributes in blue For the Email Field .
13.Now Save the changes and go back to the list in IE and try to type in invalid email id and you will get following .
Custom Theme in SharePoint
1. 1. On the SharePoint Server go to the Themes folder
e.g. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\THEMES
2. Copy any one of the theme folders from there and paste it in the same directory and give the folder a unique name, say "MyCustomTheme".
3. Find the .inf file in the copied folder, and rename it with the name given to the folder i.e. in this example rename that .inf file with MyCustomTheme.INF.
4. Open the .inf file and assign the same name i.e. MyCustomTheme to the title in the [info] section of the file, and in the [titles] section replace the previous names with your new name.
5. There is one theme.css file in that MyCustomTheme folder, open that, delete all the classes from that file and place your own css classes in that file.
6. Open “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\SPTHEMES.XML” file with notepad
7. Add the following lines under tag
MyCustomTheme
MyCustomTheme
This is custom theme.
images/MyCustomTheme.gif
images/MyCustomTheme.gif
8. Where Template ID must be that of same name as that of the folder.
9. In order to display thumbnail and preview correctly, you will need to capture the screen and save the file in "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES" folder with MyTheme.gif name. You can change the .gif file name if you change the thumbnail and preview file names in tag.
10. Do an iisrest for the server to recognize the new theme.
11. Open your SharePoint site and go to the theme page by typing following URL in address bar: http://***/_layouts/themeweb.aspx
12. Select the theme and apply it to your site by clicking the Apply button
1. 1. On the SharePoint Server go to the Themes folder
e.g. C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\THEMES
2. Copy any one of the theme folders from there and paste it in the same directory and give the folder a unique name, say "MyCustomTheme".
3. Find the .inf file in the copied folder, and rename it with the name given to the folder i.e. in this example rename that .inf file with MyCustomTheme.INF.
4. Open the .inf file and assign the same name i.e. MyCustomTheme to the title in the [info] section of the file, and in the [titles] section replace the previous names with your new name.
5. There is one theme.css file in that MyCustomTheme folder, open that, delete all the classes from that file and place your own css classes in that file.
6. Open “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033\SPTHEMES.XML” file with notepad
7. Add the following lines under tag
MyCustomTheme
MyCustomTheme
This is custom theme.
images/MyCustomTheme.gif
images/MyCustomTheme.gif
8. Where Template ID must be that of same name as that of the folder.
9. In order to display thumbnail and preview correctly, you will need to capture the screen and save the file in "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES" folder with MyTheme.gif name. You can change the .gif file name if you change the thumbnail and preview file names in tag.
10. Do an iisrest for the server to recognize the new theme.
11. Open your SharePoint site and go to the theme page by typing following URL in address bar: http://***/_layouts/themeweb.aspx
12. Select the theme and apply it to your site by clicking the Apply button
Restoring the Closed Web parts on a Sharepoint Page
Restoring the Closed Web parts on a Sharepoint Page
1. Go to is Site Actions and then to Edit Page
2. Now Clck add a web part link
3. Go to Advanced Web part Gallery and options
4. On top of this pane you will see Closed Web Parts. Once you click this it will show all the web part which are closed on this page
5. Now Drag closed web part onto the page
1. Go to is Site Actions and then to Edit Page
2. Now Clck add a web part link
3. Go to Advanced Web part Gallery and options
4. On top of this pane you will see Closed Web Parts. Once you click this it will show all the web part which are closed on this page
5. Now Drag closed web part onto the page
Create a Feature: Add Custom Master Pages to your Site Collections
Create a Feature: Add Custom Master Pages to your Site Collections
One way master pages can be stored and used in MOSS 2007 sites is through creation in SharePoint Designer and storage in the Master Page Gallery. This method will create a master page in the content database. But what if you need to use one or two master page across multiple site collections? For ease of updates and maintenance, we don't necessarily want to store a copy of the master page in each site collection. Instead we can create and store master pages on the file system as a SharePoint Feature and make it available for new and existing site collections.
http://heathersolomon.com/blog/articles/servermstpageforsitecollect_feature.aspx
One way master pages can be stored and used in MOSS 2007 sites is through creation in SharePoint Designer and storage in the Master Page Gallery. This method will create a master page in the content database. But what if you need to use one or two master page across multiple site collections? For ease of updates and maintenance, we don't necessarily want to store a copy of the master page in each site collection. Instead we can create and store master pages on the file system as a SharePoint Feature and make it available for new and existing site collections.
http://heathersolomon.com/blog/articles/servermstpageforsitecollect_feature.aspx
How to hide the New! icon or control how long the icon is displayed.
How to hide the New! icon or control how long the icon is displayed.
The New! icon displays for 2 days by default, but you can use the command line to set that:
[C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN]
stsadm.exe -o setproperty -propertyname days-to-show-new-icon -propertyvalue [Days to Display] -url [Your Virtual Server's URL]
The New! icon displays for 2 days by default, but you can use the command line to set that:
[C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN]
stsadm.exe -o setproperty -propertyname days-to-show-new-icon -propertyvalue [Days to Display] -url [Your Virtual Server's URL]
Add a site template to Central Administration
Add a site template to Central Administration so it's available when you create a new site collection
When you create a new site collection, Central Administration creates a top level site and offers you the standard set of templates for that top level site.If you want to add a custom template to the list of templates offered by Central Administration,
simply:
From the command prompt, use STSADM -O ADDTEMPLATE:
stsadm.exe -o addtemplate -filename "filename" -title "friendly name" -description "description"
Type stsadm -help addtemplate for details.
Then restart IIS by typing iisreset.
When you create a new site collection, Central Administration creates a top level site and offers you the standard set of templates for that top level site.If you want to add a custom template to the list of templates offered by Central Administration,
simply:
From the command prompt, use STSADM -O ADDTEMPLATE:
stsadm.exe -o addtemplate -filename "filename" -title "friendly name" -description "description"
Type stsadm -help addtemplate for details.
Then restart IIS by typing iisreset.
Fixing Publishing Pages Page Layout URL
Fixing Publishing Pages Page Layout URL
If we open the publishing page in Sharepoint Designer and Detach from Page Layout, when you modify the page then save and check-in the page, the URL ref to http://dev09.4444/_catalogs/masterpage/BlankWebPartPage.aspx? rather than refering to /_catalogs/masterpage/BlankWebPartPage.aspx.
Soultion is Reattcah the page layout then check-in and publish.
If we open the publishing page in Sharepoint Designer and Detach from Page Layout, when you modify the page then save and check-in the page, the URL ref to http://dev09.4444/_catalogs/masterpage/BlankWebPartPage.aspx? rather than refering to /_catalogs/masterpage/BlankWebPartPage.aspx.
Soultion is Reattcah the page layout then check-in and publish.
Favicon's in a SharePoint Master Page
Favicon's in a SharePoint Master Page
Favicon's are 'Custom Icon for your websites'.
A Favicon is a multi-resolution image included on nearly all professional developed sites.
I have always preferred to call out favicons specifically with a link tag in the html head tag this way I ensure that my code, not the server, is handling the file. So now, how do you do this in SharePoint?
Here are my stepsDrag a favicon.ico file to the Images directory of your MOSS site with SharePoint designer.
Add the following line to your Master Page at the bottom of the head section right before the /head tag:
(link rel="shortcut icon" href="/images/favicon.ico")
Check-in, publish, and approve your Master Page so that anonymous folks can see the change.
Refresh the site, and you should see the favicon
For more details:http://www.chami.com/html-kit/services/favicon/
Favicon's are 'Custom Icon for your websites'.
A Favicon is a multi-resolution image included on nearly all professional developed sites.
I have always preferred to call out favicons specifically with a link tag in the html head tag this way I ensure that my code, not the server, is handling the file. So now, how do you do this in SharePoint?
Here are my stepsDrag a favicon.ico file to the Images directory of your MOSS site with SharePoint designer.
Add the following line to your Master Page at the bottom of the head section right before the /head tag:
(link rel="shortcut icon" href="/images/favicon.ico")
Check-in, publish, and approve your Master Page so that anonymous folks can see the change.
Refresh the site, and you should see the favicon
For more details:http://www.chami.com/html-kit/services/favicon/
Configuring Alternate access Mapping Settings
Alternate access settings provide a mechanism for server farm administrators to identify the different ways in which users access portal sites, ensuring that URLs are displayed appropriately for the manner in which the user accesses the portal site.
1. Administrators often deploy portal sites that users can access by using different URLs. It is important that functionality, such as search results for portal site and document library (Web Storage System-based) content, be appropriate for the URL that was used to access the portal site. External URLs must be provided to the user in a form that is appropriate for how the user is currently accessing the portal site.
2. Without alternate access settings, search results might be displayed in a way that would make them inaccessible to users. Users might receive search results that they cannot access whenever they access the portal site by using a URL that is different from the original URL used for crawling the content.
Steps to create AAM.
1. Open Central adminstration tool
2. Go to Operations
3. On AAM -> click on the portal to which you want to configure AAM.For ex: http://dev:8585/.
4. Change the URL you see to http://XXX.domainname:8585/.
5. Click OK.
6. Go to IIS ( Run inetmgr).
7. Right Click on Portal name ->right click -> properties -> Advanced.
8. Click on default -> Edit.
9. Change the host header to "Dev04.domainname".
10. Click OK and its DONE.
11. Now you can access http://xxx:8585/ as http://XXX.domainname:8585/
http://raogorpade.blogspot.in/2008/03/configuring-alternate-access-settings.html
Removing Footer from SharePoint List Items Display...
Removing Footer from SharePoint List Items Display...
1. Open the site in SharePoint Designer.
2. Click on your list folder. Usually under the Site Address/Lists
3. Make a copy of DispForm.aspx Name it something like: MyDispForm.aspx
4. Open the new MyDispForm.aspx
5. Select the ListFormWebPart, and delete it.
6. Click Insert -> SharePoint Controls -> Custom List Form…
7. Choose you list or document library from the drop down list.
8. Choose Type of form to create: Display item form (used to view list items)
9. A new Data Form Web Part will be created.
10. Delete the CreatedModifiedInfo control, using either:
a. Design mode: click the control that shows the Created By and Modified By text, and delete.
b. Code Mode: create the following tag:
11. Save the page.
1. Open the site in SharePoint Designer.
2. Click on your list folder. Usually under the Site Address/Lists
3. Make a copy of DispForm.aspx Name it something like: MyDispForm.aspx
4. Open the new MyDispForm.aspx
5. Select the ListFormWebPart, and delete it.
6. Click Insert -> SharePoint Controls -> Custom List Form…
7. Choose you list or document library from the drop down list.
8. Choose Type of form to create: Display item form (used to view list items)
9. A new Data Form Web Part will be created.
10. Delete the CreatedModifiedInfo control, using either:
a. Design mode: click the control that shows the Created By and Modified By text, and delete.
b. Code Mode: create the following tag:
11. Save the page.
Backup / Restore using STSADM command.
Backup / Restore using STSADM command.
Command to take Backup of a sharepoint site:
Go To :
1. \program files\common files\Microsoft shared\web server extensions\12\bin.
2. Run stsadm -o backup -url -filename.
For ex: stsadm -o backup -url http://dev:8585/ -filename file://dev/filename.dat.
Command to restore backup of a sharepoint site:
1.\program files\common files\microsoft shared\web server extensions\12\bin.
2. Run stsadm -o restore-url -filename .
For ex: stsadm -o restore -url http://dev:8585/ -filename file://dev/filename.dat.
3. If you want to overwrite the existing site, use -overwrite command.
For ex : stsadm -o restore -url http://dev:8585/ -filename file://dev/filename.dat - overwrite.
Command to take Backup of a sharepoint site:
Go To :
1. \program files\common files\Microsoft shared\web server extensions\12\bin.
2. Run stsadm -o backup -url -filename.
For ex: stsadm -o backup -url http://dev:8585/ -filename file://dev/filename.dat.
Command to restore backup of a sharepoint site:
1.\program files\common files\microsoft shared\web server extensions\12\bin.
2. Run stsadm -o restore-url -filename .
For ex: stsadm -o restore -url http://dev:8585/ -filename file://dev/filename.dat.
3. If you want to overwrite the existing site, use -overwrite command.
For ex : stsadm -o restore -url http://dev:8585/ -filename file://dev/filename.dat - overwrite.
Hiding sign in control from anonymous users....
Hiding sign in control from anonymous users....
Hiding the sign in link, copy and past this code in the Head tag of your master page
And then within the body tag put..
(wssuc:Welcome id="signIn" runat="server" Visible="false"/)
Hiding the sign in link, copy and past this code in the Head tag of your master page
And then within the body tag put..
(wssuc:Welcome id="signIn" runat="server" Visible="false"/)
Subscribe to:
Posts (Atom)