Wednesday, April 18, 2012

Error Connecting to a Database when configuring a farm setting in Sharepoint 2010

Whenever are you creating a new Farm server connection for Sharepoint 2010 and hit up with following error:

Nothing to worry,
1.Login in to your database server and launch your "Microsoft SQL Manangement Studio"
3.Expand Security-->Logins and select the Server role for the user and check-in the following permissions:
  1.DBCREATOR  
  2.SECURITY ADMIN

  these are the permissions that are required for the user to configure the Sharepoint Server 2010 .
   Reference: 

http://www.khamis.net/blog/Lists/Posts/Post.aspx?List=6c8a23d1%2D47ea%2D47e5%2Db56f%2D2bc57cb95b93&ID=48&Web=d64cd8b3%2Da3f4%2D40d8%2D8d93%2D6aa6dc82fcda


If the problem even persists after you have given permission for the user
2.Create a firewall rule in Application Server(where your Central Administration is installed)
   1.Click Firewall advanced configuration
   2.Click "Inbound rule:
   3.Click "New Rule" on the right side
   4.Select Port ,On the port and protocol wizard -select TCP port and enter 1433 in the below .
   .......................Proceed and fill the following wizard(  I think just enter the name it would do)

  It should work .

The reason behind:
 
   Microsoft SQL listens to to port 1433.

No comments:

Post a Comment