Fortunately my current company giving me so much work in every area for example support to user for their newly created SharePoint (Cloud and On Premise) environment, Leading a Performance Test project or Work as Administrator in their huge environment (right because there are more than 80 VMs including Development, QA, Staging and Production environment) .Although I am developer but I am glad and enjoying this work.
Last week i got work to add user user as FAST search admin and After some goggling I got some knowledge, what is necessary to give user specific permission .
Steps that I followed
Add user in VM administrator group :- log in VM click right click on compute name and select Manage . Here you will find user and Group. Now find user name by Domain name/User ID (because we have multiple trusted ADs) and add it.
Now Open SharePoint Power shell script: Log in front end server and run power shell script now first I want to make sure that user is able to access power shell or not so I hit my first cmdlet
Get-SPShellAdmin
This cmdlet let me know about all users who can access Power shell script
Add-SPShellAdmin [-UserName]
This cmdlet help me to add user in power shell admin group make sure format of user name is
Domain name/user id or name here I am adding yf5764s
Now again user Get –SPShellAdmin and make sure it is added.
Now user can access Power shell script so we come half way but if this time user wants to perform some action from power shell script he will get error
Form this error you come to know now you need to give permission on FAST Search related database. To complete this task log in SQL server VM and first add user with sufficient Privileged on database, now I suggest you please try to achieve this by creating some AD group for easier but for this article I am giving direct access to user.
Login in SQL Server VM
Open SQL Management Studio
Connect with Server now and expand security from left pane.
Add New Login Now search user by Login Name Test box. After success find user click on User Mapping and select data base related to FAST Search and make him dbowner don’t forget to check box to mark,
Two most important services that use by fast search are FAST content SSA and FAST Query SSA
FAST Content SSA – this service is responsible to communicate from SharePoint central administrator to Fast Search Farm
FAST Query SSA – This service is responsible to take back result from FAST Farm to SharePoint Farm so results could be serve to end user.
If you visit to SharePoint configuration db you will find many databases like FASTContentSSA_crawlerStore************ and FASTQuerySSA_*************
so we need to keep in mind that that user must have owner rights on these database .
Click ok and ask user to make sure he can perform his action.
