Sunday 20 May 2012

Configuring User Profile Service Application in SharePoint Server 2010

we referred the below blog for sorting issues related to user profile sync and configuring directory service connections to import AD users. 

http://blogs.msdn.com/b/alimaz/archive/2009/11/09/configuring-user-profile-service-application-in-sharepoint-server-2010.aspx


I successfully implemented Three-Tier SharePoint 2010 Architecture
..no hassles.. we could swiftly achieve the upgrade from MOSS2007 to SharePoint 2010 in April 2012.

Quick Fix: user profile service application error in SharePoint 2010


SharePoint 2010: User Profiles - You receive an error - "An unexpected error has occurred." when you try to browse to the page to Manage a newly created User Profile Service Application
You create a new User Profile Service Application and try browsing to the Manage link for the User Profile Service Application, this page might fail with the following error,

Sharepoint 2010 User profile service application error could be resolved by updating the below hotfix.

we could fix the above nature of error by applying the below hot fix of SharePoint 2010.
----------------------------------------------------------
KB Article Number(s): 2597150
Language: All (Global)
Platform: x64

Database attach method to upgrade to a new farm

ADDCONTENTDB


stsadm -o addcontentdb -url  http://intranet  -databasename wss_content_hr -databaseserver yoursqlservername\instancename

if you have multiple subsites then you can very well include all of those stsadm database attach command in a batch file and execute it at one stretch.
ex:
save the below in a execute.bat file:
'----
stsadm -o addcontentdb -url http://intranet -databasename wss_content_hr -databaseserver yoursqlservername\instancename >> result.txt


stsadm -o addcontentdb -url  http://intranet/sites/hr -databasename wss_content_hr -databaseserver yoursqlservername\instancename >> result.txt


stsadm -o addcontentdb -url  http://intranet/sites/it -databasename wss_content_hr -databaseserver yoursqlservername\instancename >> result.txt

'----
the above file execute.bat once executed will append result.txt with the upgrade status.

dealing with user password credential manager


i .   login with the current user account.
ii.   Click Start and type run in the search and hit Enter .

iii.    type "control userpasswords2 " in the run window and hit Enter

iv.    check if the check box which says Users must enter a user name and password to use is checked. If the check box is checked then uncheck the check box, click on apply and ok tab and hit enter.

v.    Restart the system.
vi.    You will be able to see different users in the logon screen.

 delete stored passwords from your machine..(win 7)

     click Manage Password

if you are not sure which application is using your credential please feel free to remove it. :)

exciting office web apps for SharePoint 2010

No need of office installation on client machines, instead integrate web app bunch with Sharepoint 2010.
saves client licensing (CALs) cost or for those who needs to extend the office feature on the web browser. Clients can open office documents from anywhere outside office network like from Airport or from public internet zone using authorized connection. For better performance install Silverlight on client computers.
installation reference:

How to change SQL Server Name or Instance Name

applies to all SQL ver including Denali.
i. Open SQL Server Management Studio and click New Query.
ii. Type Select @@ServerName to verify that the server name. In this example, Windows 2003 from WIN2K3R2EE to SQL Server is used. If windows hostname is changed doesn't mean that SQL Server 2005 name will be automatically changed. It will still return the old name. Let's fix it.
3. Next, type sp_dropserver 'WIN2K3R2EE'
4. You are now ready to add the correct name by typing sp_addserver 'SQLSERVER'. local
at this point if you need to change instance name, execute the below query:
sp_dropserver 'Server Name\old_Instance_name'
go 
sp_addserver 'ServerName\New Instance Name','local'
go


5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver. To stop and start the sql server agent, type net stop or start sqlserveragent.
6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

high availability moss 2007 development and production environment

I attained the below infrastructure from scratch (a mix of windows 2003 R2 Ent 32bit and 64bit) for our team during mid of 2010
2 Tier MOSS 2007 network diagram
2 Tier MOSS2007 Architecture for both development and production environment