mail notification to task assign person

Problem: enable mail notification to task assign person on SharePoint 2007

Solution: in SharePoint project page go to settings – list setings -advenced settings – e-mail notification

Advertisements

Vista startup services report

wmic startup get /format:hform > statuppreport.htm

sql 2005 detach database

use master

   go

   sp_detach_db ‘databaseName’

   go

sql 2005 delete records older than 7 days

Delete From tableName where field  < GetDate() – 7

setup mirroring databases on SQL 2005

Problem: Not able to set up database mirroring through management studio

Getting error 1418
Resolution:
Changed  SQL startup account from Local system to Domain account
for Principal, Mirror ,Witness

Tried to set up mirroring through management studio

Ran the following command on Principal and Mirror:

ALTER ENDPOINT Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022)
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS NTLM,
ENCRYPTION = DISABLED,
ROLE=PARTNER)

Now Its failing with Error 1456
Provided sysadmin privileges to domain user on principal ,Mirror, Witness.

But still getting the same error

Ran the following command on witness also:

ALTER ENDPOINT Mirroring
STATE = STARTED
AS TCP (LISTENER_PORT = 5022)
FOR DATABASE_MIRRORING (
AUTHENTICATION = WINDOWS NTLM,
ENCRYPTION = DISABLED,
ROLE=PARTNER)

(for SQL exspress:

ALTER ENDPOINT MirroringSTATE = STARTEDAS TCP (LISTENER_PORT = 5022)FOR DATABASE_MIRRORING (AUTHENTICATION = WINDOWS NTLM,ENCRYPTION = DISABLED,ROLE=WITNESS)     )

Setup Database Mirroring successfully.

 

-- Grant the user access to the endpoint 
GRANT CONNECT ON ENDPOINT::Mirroring_Endpoint TO [SQLSrv2_mirroring_login]
GO

 

SQL 2005 memory configuration

–Enable the Lock Pages in Memory Option:

  On the Start menu, click Run. In the Open box, type gpedit.msc. The Group Policy dialog box opens. 
 On the Group Policy console, expand Computer Configuration, and then expand Windows Settings.
Expand Security Settings, and then expand Local Policies.
 Select the User Rights Assignment folder.  The policies will be displayed in the details pane.
In the pane, double-click Lock pages in memory.
In the Local Security Policy Setting dialog box, click Add.
In the Select Users or Groups dialog box, add an account with privileges to run sqlservr.exe.
 

–Activate AWE:

 

sp_configure ‘show advanced options’, 1

RECONFIGURE

GO

 

sp_configure ‘awe enabled’, 1

RECONFIGURE

GO

After SQL Server restarts, the following message is written to the SQL Server error log: “Address Windowing Extensions enabled.”
–Change min and max memory on server:

 sp_configure ‘min server memory’, 512
RECONFIGURE
GO
sp_configure ‘max server memory’, 3096
RECONFIGURE
GO

 

–Change Min memory per query from 1024 to 2048 Kb

Sharepoint 2007 indexing issue

Problem: Access is denied. Check that the Default Content Access Account has access to this content, or add a crawl rule to crawl this content.   (0x80041205) 

Solution: you need to extend your SharePoint web application to run on an additional port, configure NTLM for the site and have crawler to follow NTLM site to build index. 

  1.  Go to SharePoint Central administration -> Application management. 
  2. Choose “Create or extend Web application”. 
  3. Choose “Extend an existing Web application”. 
  4. Choose your “basic” web application from the list. 
  5.  Set other parameters as needed. Suppose we configure it to run at http://server:1234. 
  6. From Zone list, choose a zone other than Default. i.e. Custom. 
  7. After the mapped site is created, go to Application Management -> Authentication Providers. 
  8. Find and click the zone (for the mapped site) we just created. Set “Windows integrated” authentication. 
  9. Go to Operations -> Alternate access mappings. 
  10. Change the alternate access mapping collection to our web application. 
  11. Click Edit Public URLs, and exchange the URL in the list. Make sure that the new URL http://server:1234 is in Default URL while the original URL can be set at any other zone.