Access Denied issue after creating new configuration database

This is one of the rare issues I was facing with my farm.

Scenario

Due to domain crash I have created a new domain with the same name and created all users which were there in old domain.

Issue

• After creating a new domain I have tried to connect with the old configuration database which failed with invalid user credentials issue.
  
• So I have created a new Configuration Database as I have Content DB of the site with me.
  
• PSConfig was completed successfully and attach content DB worked fine.
  
• Now the main issue occurred, site was accessible fine if I use farm admin credentials but it gave "Access Denied" error for all other users which I have added to the site earlier.
  

Resolution

• From my research I found it was due to Schema mismatch, so when I delete and re add that user it worked fine.
  
• Or you can use STSADM -o migrateuser command
  

The document could not be opened for editing. A Windows SharePoint Services compatible application could not be found to edit the document.

This is very common issue with office documents.(Excel , Word)
Most of the time issue has been resolved by hot fixes provided by Microsoft
This issue I found with MS Office Project documents and this works for me.
Please follow below steps to resolve MS Office Project document compatibility issue with SharePoint


1. On the local computer, install Windows SharePoint Services Support from the Office installation media.(It is listed under Office Tools.)


2. The following registry keys must be added to the local machine.


[HKEY_CLASSES_ROOT\MSProject.Project]
@="Microsoft Office Project Document"


[HKEY_CLASSES_ROOT\MSProject.Project\CLSID]
@="{74B78F3A-C8C8-11D1-BE11-00C04FB6FAF1}"


[HKEY_CLASSES_ROOT\MSProject.Project\CurVer]
@="MSProject.Project.9"


[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App
Paths\Winproj.exe]
@="\"C:\Program Files\Softricity\SoftGrid for Windows Desktops\sfttray.exe" /launch
"Microsoft Office Project 2003 projecpm.311""
"UseUrl"="1"
"SaveUrl"="1"
--note that "Microsoft Office Project 2003 projecpm.311" refers to the actual name
of the package. The name will be different for every case.


[HKEY_CLASSES_ROOT\.mpp]
@="MSProject.Project.9"
"Content Type"="application/vnd.ms-project"
"SoftGridSource"="{C5F5D9DD-0FE3-4421-A2BE-F8203F53EAD9}"

Quickly create a custom template in MOSS 2007 using SPD 2007

This is very easy and very quick way to create a custom template in MOSS 2007
Please follow below steps

>> Open SharePoint site in SharePoint designer
>> Then go to Catalogs folder
>> Take a copy of default.master and DefaultLayout.aspx pages
>> Now open these two pages to edit them
>> Actually we have to edit Default.Master page , DefaultLayout.aspx is just a result page of our changes on default.master
>> Import all images you have to publish on site
>> Now start doind changes on default.master page
>> Periodically check DefaultLayout.aspx page to verify results of modification
>> This works for me.

Enjoy !!