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.
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