Jul 16 2010

SharePoint 2010 Online Hosting Poll

In light of the Microsoft WPC and the big push for Cloud computing, I thought it would be intresting in find out peoples reactions to Hosting SharePoint 2010 in the cloud rather than On-Premise  (and also to see how many people read my blog)

Are you looking at Implementing SharePoint 2010?

View Results

Loading ... Loading ...

Are you considering cloud hosting options for SharePoint 2010?

View Results

Loading ... Loading ...

What type of access to SharePoint 2010 would you require?

View Results

Loading ... Loading ...

Would you require Vanity URLs?

View Results

Loading ... Loading ...

What would be the maximum contract term you would agree to?

View Results

Loading ... Loading ...

Would you want your organisations domain to be integrated into SharePoint 2010 for authentication?

View Results

Loading ... Loading ...

Thinking about the platform support of the environment what would you expect to be the minimum?

View Results

Loading ... Loading ...

Thinking about SharePoint support what would you expect to be the minimum?

View Results

Loading ... Loading ...

How would you expect to license SharePoint Users?

View Results

Loading ... Loading ...

How much Bandwidth would you expect to have at the minimum?

View Results

Loading ... Loading ...

What would be the minimum Disaster Recovery Separation you would expect?

View Results

Loading ... Loading ...

Jul 14 2010

FIM – Forefront Identity Manager Failed to Connect to SQL Server

FIM – Forefront Identity Manager Failed to Connect to SQL Server

ISSUE
=====
SharePoint 2010 connects to a SQL Instance
In SharePoint 2010 FIM is used for importing and synchronising user profiles by the User Profile Service Application. Starting the User Profile Synchronising Service (from Central Admin – System Settings – Mange Service on Server) Fail’s. Reviewing the Event log you receive the following error message:

Log Name:      Application
Source:        FIMSynchronizationService
Date:          13/07/2010 15:19:37
Event ID:      6324
Task Category: Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      <SP2010NAMEE>.<DOMAINNAME>
Description:
The server encountered an unexpected error and stopped.

 “ERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1804): sql.cpp(5601): Error retrieving error
BAIL: MMS(1804): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on <SQLSERVERNAME>
BAIL: MMS(1804): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 0.
ERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1804): sql.cpp(5601): Error retrieving error
BAIL: MMS(1804): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on <SQLSERVERNAME>
BAIL: MMS(1804): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 1.
ERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1804): sql.cpp(5601): Error retrieving error
BAIL: MMS(1804): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on <SQLSERVERNAME>
BAIL: MMS(1804): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 2.
ERR: MMS(1804): sql.cpp(5580): Query (CSession::Open()) performed with error
ERR: MMS(1804): sql.cpp(5601): Error retrieving error
BAIL: MMS(1804): sql.cpp(568): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(384): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): sql.cpp(256): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): storeimp.cpp(272): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): server.cpp(294): Failed to connect to the database User Profile Service Application_SyncDB_2404860889364cf2a021eccb509327fd on <SQLSERVERNAME>
BAIL: MMS(1804): server.cpp(295): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): server.cpp(3518): 0×80230406 (An error has occurred at the store)
BAIL: MMS(1804): service.cpp(1528): 0×80230406 (An error has occurred at the store)
ERR: MMS(1804): service.cpp(977): Error creating com objects. Error code: -2145188858. This is retry number 3.
BAIL: MMS(1804): service.cpp(991): 0×80230406 (An error has occurred at the store)
Forefront Identity Manager 4.0.2450.5″

Resolution
=========

Somehow the SQL Instance information for the FIM Synchronising Service is missing

To resolve the issue add the SQLInstance name to the following Reg key:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\services\FIMSynchronizationService\Parameters]
"SQLInstance"="<InstanceName>"


May 20 2010

SharePoint 2010 Edition Information

SharePoint 2010 Edition Information can be found here: http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx