[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sharepoint 2010 configuration

Posted on 2010-09-06
5
Medium Priority
?
2,520 Views
Last Modified: 2012-05-10
I installed sharepoint 2010 on a 2008 R2 server. I used SQL Express R2. The problem is that after I start  the User Profile Synchronization Service  in Sharepoint, I get the following event in the application log:

 - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="Microsoft.ResourceManagement.ServiceHealthSource" />
  <EventID Qualifiers="0">22</EventID>
  <Level>2</Level>
  <Task>0</Task>
  <Keywords>0x80000000000000</Keywords>
  <TimeCreated SystemTime="2010-09-06T16:25:18.000000000Z" />
  <EventRecordID>9209</EventRecordID>
  <Channel>Application</Channel>
  <Computer>QTMAIL1.QTTechnologies.local</Computer>
  <Security />
  </System>
- <EventData>
  <Data>The Forefront Identity Manager Service cannot connect to the SQL Database Server. The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly. Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, verify the connection information has been configured properly. This configuration is stored in the Windows Registry.</Data>
  </EventData>
  </Event>

The other applications in Sharepoint seem to find the SQL server just fine. Is there supposed to be a "FIM Service" datatebase in SQl? If so, I don't have one.

How can I get  the FIM service to connect to SQL?

Thanks,

Charles
0
Comment
Question by:cwconley
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 51

Expert Comment

by:Keith Alabaster
ID: 33612518
Have you bought FIM? Or have you had a trial version of FIM installed in your environment previously?
0
 
LVL 9

Expert Comment

by:SharePointGirl
ID: 33612539
Are you using SharePoint Foundation?
The user profile synch service does not work with foundation.
0
 

Author Comment

by:cwconley
ID: 33612652
I installed SharePoint Server 2010 Enterprise Client Access License features trail version, that I got from  the Microsoft  Sharepoint site. I installed it as a farm. This is a clean install on this server. This server is not a Domain Controller. I followed the install instructions at:
http://blogs.msdn.com/b/mtc/archive/2009/12/08/how-to-setup-sharepoint-2010-public-beta-user-profile-synchronization-with-active-directory-on-windows-server-2008-r2.aspx.
I also instalIed Project server 2010 on this server. It requires Sharepoint Enterprise. Is there a way to determine if I am useing the right Sharepoint version?
0
 

Accepted Solution

by:
cwconley earned 0 total points
ID: 33613154
I was able to resolve the issue. I had to run the configuration wizard again after I had enabled the user profile synronization service.
0
 
LVL 51

Expert Comment

by:Keith Alabaster
ID: 33613159
Interesting - not sure I have ever had to do that. Nice work though if it is now sorted.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question