SharePoint 2007 and WSS 3.0 SP2 is here….
The long awaited SP2 for MOSS and WSS is here!! Download them from here:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b7816d90-5fc6-4347-89b0-a80deb27a082
Description is available here - http://support.microsoft.com/kb/953334
This file has all the changes that has been made in SP2 - Download the 2007 Office servers Service Pack 2 Changes.xlsx package now
For how to deploy software updates on a MOSS Server Farm (or WSS Server Farm as the case may be) keep this link handy - http://technet.microsoft.com/en-us/library/cc263467.aspx . Note : additional steps are required if there are multiple servers. Do read the whole article.
For comprehensive lift of WSS 3.0 SP2 visit the following links:
Windows SharePoint Services 3.0 Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en)
953338 (http://support.microsoft.com/kb/953338)
Windows SharePoint Services 3.0 Service Pack 2, 64-bit edition
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=79BADA82-C13F-44C1-BDC1-D0447337051B&displaylang=en)
953338 (http://support.microsoft.com/kb/953338)
Windows SharePoint Services 3.0 Language Pack Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=085E5AC8-58F6-4CF9-8012-33B95EE36C0F&displaylang=en)
953338 (http://support.microsoft.com/kb/953338)
Windows SharePoint Services 3.0 Language Pack Service Pack 2, 64-bit edition
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=2C2B6CAF-B46D-45EB-AC4D-DEAAA48C3A2C&displaylang=en)
953338 (http://support.microsoft.com/kb/953338)
Windows SharePoint Services 3.0 with Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=EF93E453-75F1-45DF-8C6F-4565E8549C2A&displaylang=en)
-
Windows SharePoint Services 3.0 x64 with Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=9FB41E51-CB03-4B47-B89A-396786492CBA&displaylang=en)
For comprehensive list of MOSS 2007 SP2 visit the following links:
The 2007 Microsoft Office servers Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082&displaylang=en)
953334 (http://support.microsoft.com/kb/953334)
The 2007 Microsoft Office servers Service Pack 2, 64-bit edition
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=B7816D90-5FC6-4347-89B0-A80DEB27A082&displaylang=en)
953334 (http://support.microsoft.com/kb/953334)
The 2007 Microsoft Office servers Language Pack Service Pack 2
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=01C6A3E8-E110-4956-903A-AD16284BF223&displaylang=en)
953334 (http://support.microsoft.com/kb/953334)
The 2007 Microsoft Office servers Language Pack Service Pack 2, 64-bit edition
Download (http://www.microsoft.com/downloads/details.aspx?FamilyId=66C5026F-9F47-4642-8378-2526918009FA&displaylang=en)
953334
This posting is provided "AS IS" with no warranties, and confers no rights
Thursday, June 4, 2009
Sunday, May 3, 2009
SharePoint 2007 URL Quick List
SharePoint 2007 URL Quick List
The following is a list of SharePoint URLs to get to commonly used administrative functions on a MOSS or WSS v3 site. Not all links listed on this page are accessible to all user levels of a site. This is a quick list for speedy reference as compared to tracking down links through the admin screens or for faster jumping around sites within a site collection.
Function Add to the URL Notes
Add Web Parts Pane ?ToolPaneView=2 Add to the end of the page URL; WILL ONLY WORK IF THE PAGE IS ALREADY CHECKED OUT
Create New Site Content /_layouts/create.aspx
List Template Gallery /_catalogs/lt
Manage Site Collection Administrators /_layouts/mngsiteadmin.aspx
Manage Sites and Workspaces /_layouts/mngsubwebs.aspx
Manage People /_layouts/people.aspx
Manage User Permissions /_layouts/user.aspx
Master Page Gallery /_catalogs/masterpage Also includes Page Layouts
Modify Navigation /_layouts/AreaNavigationSettings.aspx
Recycle Bin /_layouts/AdminRecycleBin.aspx
Site Column Gallery /_layouts/mngfield.aspx
Site Content Types /_layouts/mngctype.aspx
Site Content and Structure Manager /_layouts/sitemanager.aspx
Site Settings /_layouts/settings.aspx
Site Template Gallery /_catalogs/wt
Site Usage Summary /_layouts/SpUsageWeb.aspx
User Alerts /_layouts/sitesubs.aspx
View All Site Content /_layouts/viewlsts.aspx
Web Part Gallery /_catalogs/wp
Web Part Page Maintenance ?contents=1 Add to the end of the page URL
Workflows /_layouts/wrkmng.aspx
The following is a list of SharePoint URLs to get to commonly used administrative functions on a MOSS or WSS v3 site. Not all links listed on this page are accessible to all user levels of a site. This is a quick list for speedy reference as compared to tracking down links through the admin screens or for faster jumping around sites within a site collection.
Function Add to the URL Notes
Add Web Parts Pane ?ToolPaneView=2 Add to the end of the page URL; WILL ONLY WORK IF THE PAGE IS ALREADY CHECKED OUT
Create New Site Content /_layouts/create.aspx
List Template Gallery /_catalogs/lt
Manage Site Collection Administrators /_layouts/mngsiteadmin.aspx
Manage Sites and Workspaces /_layouts/mngsubwebs.aspx
Manage People /_layouts/people.aspx
Manage User Permissions /_layouts/user.aspx
Master Page Gallery /_catalogs/masterpage Also includes Page Layouts
Modify Navigation /_layouts/AreaNavigationSettings.aspx
Recycle Bin /_layouts/AdminRecycleBin.aspx
Site Column Gallery /_layouts/mngfield.aspx
Site Content Types /_layouts/mngctype.aspx
Site Content and Structure Manager /_layouts/sitemanager.aspx
Site Settings /_layouts/settings.aspx
Site Template Gallery /_catalogs/wt
Site Usage Summary /_layouts/SpUsageWeb.aspx
User Alerts /_layouts/sitesubs.aspx
View All Site Content /_layouts/viewlsts.aspx
Web Part Gallery /_catalogs/wp
Web Part Page Maintenance ?contents=1 Add to the end of the page URL
Workflows /_layouts/wrkmng.aspx
Wednesday, April 15, 2009
Thing that should or should not be done to SharePoint admin account
Thing that should or should not be done to SharePoint admin account
Here is a short list of most common scenarios that people should be aware of regarding SP admin account on AD:
1. When the account initially is created, set "Password never expires" account property to true. This is not a regular user account hence it should comply with service account settings rules. If the password changes, reset passwords to reflect the new password in the Application pool identity.
2. If you are not happy with you "spappadmin" or "spadmin" (fill in the blanks) farm admin account name, DO NOT DELETE IT AND CREATE NEW ONE with the desired name. just rename this account in AD, this will make sure that the SID remains the same and the security settings do not have to be recreated for this account EVERYWHERE.
this applies to any other account in AD, but admins do know it.
3. if your farm admin account without password change suddenly looses connection to the DB and in the log you see account "[blank]" could not be authenticated to the SQL. most likely your account got corrupted in AD.
Another scenario, Farm is still functioning fine, but when you try to connect to the SQL remotely using farm admin account connection fails.
You will still be able to access you farm since the trusted connection had been established before the AD account got corrupted, but you will not be able to establish any new connections with it.
In this case just recreate admin account in AD and go through the pain of recreating security settings or changing SIDs.
Enjoy :-)
Here is a short list of most common scenarios that people should be aware of regarding SP admin account on AD:
1. When the account initially is created, set "Password never expires" account property to true. This is not a regular user account hence it should comply with service account settings rules. If the password changes, reset passwords to reflect the new password in the Application pool identity.
2. If you are not happy with you "spappadmin" or "spadmin" (fill in the blanks) farm admin account name, DO NOT DELETE IT AND CREATE NEW ONE with the desired name. just rename this account in AD, this will make sure that the SID remains the same and the security settings do not have to be recreated for this account EVERYWHERE.
this applies to any other account in AD, but admins do know it.
3. if your farm admin account without password change suddenly looses connection to the DB and in the log you see account "[blank]" could not be authenticated to the SQL. most likely your account got corrupted in AD.
Another scenario, Farm is still functioning fine, but when you try to connect to the SQL remotely using farm admin account connection fails.
You will still be able to access you farm since the trusted connection had been established before the AD account got corrupted, but you will not be able to establish any new connections with it.
In this case just recreate admin account in AD and go through the pain of recreating security settings or changing SIDs.
Enjoy :-)
Monday, March 30, 2009
How to change service accounts and service account passwords in SharePoint Server 2007 and in Windows SharePoint Services 3.0
Note If the SQL Server service uses a domain account, and the password for that domain account is either expired or invalid, make sure that you update the password for the domain account before you perform this procedure.
Update the password for the account that is used by the Central Administration application pool. To do this, follow these steps:
On all servers in the server farm, open a command prompt, type the following line, and then press ENTER:
cd %commonprogramfiles%\Microsoft Shared\Web server extensions\12\Bin
On the server that hosts the Central Administration Web site, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword
On all other servers in the server farm, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword -local
Restart Microsoft Internet Information Services (IIS) 6.0. To do this, type the following line at the command prompt, and then press ENTER:
iisreset /noforce
Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps:
Open SharePoint 3.0 Central Administration, click Operations, and then click Timer job definitions under Global Configuration.
Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list.
Note If the Administration Application Pool Credential Deployment job definition is displayed in the list, wait until it disappears from the list.
Update the password for the application pool account that is used by Web applications on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin
Update the password for the account that is used to run the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword
If you are running SharePoint Server 2007, you must also follow these steps:
Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword
Update the password for the account that is used to run the Office SharePoint Server Search service. To do this, type the following line at the command prompt, and then press ENTER:
stsadm.exe -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
If the server farm is configured to use single sign-on, update the password for the account that is used by the Microsoft Single Sign-On Service. To do this, follow these steps:
Click Operations in SharePoint 3.0 Central Administration, and then click Service accounts under Security Configuration.
Under Windows service, click Single Sign-On Service.
Under Configurable, specify the password, and then click OK.
Update the password for the default content access account that is used by the Office SharePoint Server Search service. To do this, follow these steps:
Open SharePoint 3.0 Central Administration, and then click the link to the SSP Web application under Shared Services Administration.
Under Search, click Search settings, and then click Default content access account.
Specify the password to use for the content access account, and then click OK.
Sample script
The following script is an example of how you can use the previous procedure to create a batch file that automates password changes. Use the following syntax to run the script:
FileName.bat DomainName\UserName NewPassword
@echo off
rem other app pools
echo *** Updating app pool passwords
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updateaccountpassword -userlogin %1 -password %2 -noadmin
rem central admin
echo *** Updating Central Admin password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updatefarmcredentials -userlogin %1 -password %2
rem ssp - new
echo *** Updating ssp password for new installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "SharedServices1" -ssplogin %1 -ssppassword %2
rem ssp - upgrade
echo *** Updating ssp password for upgraded installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "Default Web Site" -ssplogin %1 -ssppassword %2
rem osearch
echo *** Updating osearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o osearch -farmserviceaccount %1 -farmservicepassword %2
echo *** MANUAL UPDATE NEEDED. To update the password, visit the SSP Web application page, click Search Settings, and then click Default Content Access Account.
rem spsearch
echo *** Updating spsearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o spsearch -farmserviceaccount %1 -farmservicepassword %2
echo *** Updating spsearch content access account
"%commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN\stsadm.exe" -o spsearch -farmcontentaccessaccount %1 -farmcontentaccesspassword %2
rem restarting IIS
echo *** Doing soft restart of IIS
iisreset /noforce
echo on
Modify the script to include the correct names of each SSP in the server farm. If the server farm is configured to use single sign-on, you must also use the sc config command.
Back to the top
How to update the SharePoint Server 2007 password when SharePoint Server 2007 is installed in a least-privileges configuration
Method 1: Start the SPAdmin service
Start the SPAdmin service on all computers in the farm before you update the password. Stop the service when the operation is complete.
Method 2: Add the database access account to the local administrators group
Add the database access account to the local administrators group of each computer in the farm that has an online search instance. Log on by using that account, and then update the password by using the stsadm command.
When this operation is complete, remove the database access account from the local administrators group of each computer.
Update the password for the account that is used by the Central Administration application pool. To do this, follow these steps:
On all servers in the server farm, open a command prompt, type the following line, and then press ENTER:
cd %commonprogramfiles%\Microsoft Shared\Web server extensions\12\Bin
On the server that hosts the Central Administration Web site, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword
On all other servers in the server farm, type the following line at the command prompt, and then press ENTER:
stsadm -o updatefarmcredentials -userlogin DomainName\UserName -password NewPassword -local
Restart Microsoft Internet Information Services (IIS) 6.0. To do this, type the following line at the command prompt, and then press ENTER:
iisreset /noforce
Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed on the Timer Job Definitions page of SharePoint 3.0 Central Administration. To do this, follow these steps:
Open SharePoint 3.0 Central Administration, click Operations, and then click Timer job definitions under Global Configuration.
Verify that the Administration Application Pool Credential Deployment job definition is no longer displayed in the list.
Note If the Administration Application Pool Credential Deployment job definition is displayed in the list, wait until it disappears from the list.
Update the password for the application pool account that is used by Web applications on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm -o updateaccountpassword -userlogin DomainName\UserName -password NewPassword -noadmin
Update the password for the account that is used to run the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
Update the password for the default content access account that is used by the Windows SharePoint Services Help Search service. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o spsearch -farmcontentaccessaccount DomainName\UserName -farmcontentaccesspassword NewPassword
If you are running SharePoint Server 2007, you must also follow these steps:
Update the password for the account that is used by every Shared Services Provider (SSP) on the server farm. To do this, type the following line at a command prompt on every server on the server farm, and then press ENTER:
stsadm.exe -o editssp -title SharedServicesProviderName -ssplogin DomainName\UserName -ssppassword NewPassword
Update the password for the account that is used to run the Office SharePoint Server Search service. To do this, type the following line at the command prompt, and then press ENTER:
stsadm.exe -o osearch -farmserviceaccount DomainName\UserName -farmservicepassword NewPassword
If the server farm is configured to use single sign-on, update the password for the account that is used by the Microsoft Single Sign-On Service. To do this, follow these steps:
Click Operations in SharePoint 3.0 Central Administration, and then click Service accounts under Security Configuration.
Under Windows service, click Single Sign-On Service.
Under Configurable, specify the password, and then click OK.
Update the password for the default content access account that is used by the Office SharePoint Server Search service. To do this, follow these steps:
Open SharePoint 3.0 Central Administration, and then click the link to the SSP Web application under Shared Services Administration.
Under Search, click Search settings, and then click Default content access account.
Specify the password to use for the content access account, and then click OK.
Sample script
The following script is an example of how you can use the previous procedure to create a batch file that automates password changes. Use the following syntax to run the script:
FileName.bat DomainName\UserName NewPassword
@echo off
rem other app pools
echo *** Updating app pool passwords
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updateaccountpassword -userlogin %1 -password %2 -noadmin
rem central admin
echo *** Updating Central Admin password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o updatefarmcredentials -userlogin %1 -password %2
rem ssp - new
echo *** Updating ssp password for new installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "SharedServices1" -ssplogin %1 -ssppassword %2
rem ssp - upgrade
echo *** Updating ssp password for upgraded installs
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o editssp -title "Default Web Site" -ssplogin %1 -ssppassword %2
rem osearch
echo *** Updating osearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o osearch -farmserviceaccount %1 -farmservicepassword %2
echo *** MANUAL UPDATE NEEDED. To update the password, visit the SSP Web application page, click Search Settings, and then click Default Content Access Account.
rem spsearch
echo *** Updating spsearch password
"%commonprogramfiles%\Microsoft Shared\Web server extensions\12\BIN\Stsadm.exe" -o spsearch -farmserviceaccount %1 -farmservicepassword %2
echo *** Updating spsearch content access account
"%commonprogramfiles%\Microsoft Shared\web server extensions\12\BIN\stsadm.exe" -o spsearch -farmcontentaccessaccount %1 -farmcontentaccesspassword %2
rem restarting IIS
echo *** Doing soft restart of IIS
iisreset /noforce
echo on
Modify the script to include the correct names of each SSP in the server farm. If the server farm is configured to use single sign-on, you must also use the sc config command.
Back to the top
How to update the SharePoint Server 2007 password when SharePoint Server 2007 is installed in a least-privileges configuration
Method 1: Start the SPAdmin service
Start the SPAdmin service on all computers in the farm before you update the password. Stop the service when the operation is complete.
Method 2: Add the database access account to the local administrators group
Add the database access account to the local administrators group of each computer in the farm that has an online search instance. Log on by using that account, and then update the password by using the stsadm command.
When this operation is complete, remove the database access account from the local administrators group of each computer.
Friday, August 29, 2008
SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Datasheet
SQL SERVER - 2005 - Export Data From SQL Server 2005 to Microsoft Excel Datasheet
January 8, 2008 by pinaldave
Enable Ad Hoc Distributed Queries. Run following code in SQL Server Management Studio - Query Editor.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
Create Excel Spreadsheet in root directory c:\contact.xls (Make sure you name it contact.xls). Open spreadsheet, on the first tab of Sheet1, create two columns with FirstName, LastName. Alternatively you can download sample Spreadsheet from here.
Run following code in SQL Server Management Studio - Query Editor.
USE [AdventureWorks];
GO
INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\contact.xls;',
'SELECT * FROM [Sheet1$]')
SELECT TOP 5 FirstName, LastName
FROM Person.Contact
GO
Open contact.xls spreadsheet you will see first five records of the Person.Contact inserted into the first two columns.
Make sure your spreadsheet is closed during this operation. If it is open it may thrown an error. You can change your spreadsheet name as well name of the Sheet1 to your desired name.
Reference : Pinal Dave (http://www.SQLAuthority
January 8, 2008 by pinaldave
Enable Ad Hoc Distributed Queries. Run following code in SQL Server Management Studio - Query Editor.
EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO
Create Excel Spreadsheet in root directory c:\contact.xls (Make sure you name it contact.xls). Open spreadsheet, on the first tab of Sheet1, create two columns with FirstName, LastName. Alternatively you can download sample Spreadsheet from here.
Run following code in SQL Server Management Studio - Query Editor.
USE [AdventureWorks];
GO
INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\contact.xls;',
'SELECT * FROM [Sheet1$]')
SELECT TOP 5 FirstName, LastName
FROM Person.Contact
GO
Open contact.xls spreadsheet you will see first five records of the Person.Contact inserted into the first two columns.
Make sure your spreadsheet is closed during this operation. If it is open it may thrown an error. You can change your spreadsheet name as well name of the Sheet1 to your desired name.
Reference : Pinal Dave (http://www.SQLAuthority
Subscribe to:
Posts (Atom)