添加搜索管理员会中断搜索 [英] adding Search Administrator breaks Search
问题描述
嗨
搜索工作正常-控制台中的一切正常-但我需要添加服务帐户作为Search Administrator，并且每当执行此操作时(以设置帐户登录)-搜索中断-管理控制台中显示的所有错误和没有返回结果-
Search is working fine - all healthy in the console - but I need to add a service account as a Search Administrator and whenever I do this (logged in as the setup account) - Search breaks - All Errors showing in Admin console and no results returned -
注意-用户会显示在GUI的管理员"列表中，并且一旦我删除该用户，搜索就会重新开始工作，并且管理控制台中的所有错误都消失了
我需要该帐户为Search Admin-这是我正在安装的applicationj的先决条件.我已将其添加为服务器场管理员-这还会使它成为搜索管理员吗?
我还已将它添加到SQL中的Search DB中，并授予了它SPSearchAdmin权限-我希望这足够了，但是当我使用Powershell查询Search管理员时，它没有列出
Note - the user shows up in the list of Admins in the GUI and as soon as I remove that user Search starts working again and all the errors in the Admin console go away
I need this account to be Search Admin - it's a pre-req for an applicationj I am installing. I have added it as a Farm Admin - will this also make it Search Admin?
I have also added it to the Search DB in SQL and granted it SPSearchAdmin permission - and I hope this is enough however when I query the Search admins using Powershell it is not listed
https://technet.microsoft.com/en-us/library/ee704546.aspx
如果有人能帮上忙，那就太好了
If anyone can help that would be great
在ULS中，我得到:
添加用户< setup acct>到数据库"AG1.IntranetSearchDB"中的角色"SPSearchDBAdmin".
Adding user <setup acct> to role 'SPSearchDBAdmin' in database 'AG1.IntranetSearchDB'.
添加了用户< setup acct>到数据库"AG1.IntranetSearchDB"中的角色"SPSearchDBAdmin".
Added user <setup acct> to role 'SPSearchDBAdmin' in database 'AG1.IntranetSearchDB'.
授予用户<b; user>登录到服务器"AG1"的权限.
Granting user <user> login access to server 'AG1'.
授予用户的用户<b; user>登录到服务器"AG1"的权限.
Granted user <user> login access to server 'AG1'.
授予用户<b; user>访问数据库"AG1.IntranetSearchDB".
Granting user <user> access to database 'AG1.IntranetSearchDB'.
###
System.Data.SqlClient.SqlException(0x80131904):用户无权执行此操作.
System.Data.SqlClient.SqlException (0x80131904): User does not have permission to perform this action.
在System.Data.SqlClient.SqlConnection.OnError(SqlException异常，布尔值breakConnection，Action`1 wrapCloseInAction)中
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj，布尔调用程序HasConnectionLock，布尔asyncClose)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj，Boolean& dataReady)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds，RunBehavior runBehavior，String resetOptionsString)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior，RunBehavior runBehavior，Boolean returnStream，Boolean异步，Int32超时，Task& Task，Boolean asyncWrite，SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior，RunBehavior runBehavior，布尔值returnStream，字符串方法，TaskCompletionSource`1完成，Int32超时，Task&任务，布尔值asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
在System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1完成，字符串methodName，布尔sendToPipe，Int32超时，布尔asyncWrite)中
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
，位于Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand命令) ClientConnectionId:92276325-c3fb-40cb-8bb2-6f1001940aae错误号:15247，状态:1，类:16
at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) ClientConnectionId:92276325-c3fb-40cb-8bb2-6f1001940aae Error Number:15247,State:1,Class:16
###
SqlError:用户无权执行此操作."源:.Net SqlClient数据提供程序"编号:15247状态:1类:16过程:"sp_grantdbaccess"行号:22服务器:"AG1"
SqlError: 'User does not have permission to perform this action.' Source: '.Net SqlClient Data Provider' Number: 15247 State: 1 Class: 16 Procedure: 'sp_grantdbaccess' LineNumber: 22 Server: 'AG1'
jonj
推荐答案
该错误明确指出，您用于登录中央管理员以更改搜索管理员的帐户对'AG1.IntranetSearchDB"没有足够的权限.请授予用户sysadmin/dbowner权限，然后重试
The error clearly states that the account you have used to login to central admin for changing the search administrator does not have sufficient permissions on "'AG1.IntranetSearchDB' . Please grant the user sysadmin/dbowner rights, and then try again
此致
授予
这篇关于添加搜索管理员会中断搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
