SharePoint 2013 SQL Server 2014
I've been trying to create a new Search Service Application and I've having problems. I've tried to create the Search Service Application both by using Powershell and using the Central Admin interface. The creation fails and issues the same exception/message (listed below). I'm following the Powershell template listed on Todd Klindt's site, which has worked for me on other SharePoint Farms in the past. I believe this may be SQL Mail related but I haven't had any luck finding any information linking SQL Mail and this issue. If it's not SQL Mail what "profile" is the error referencing?
I've been bashing my head for a few days now and any help (especially diagnostic help) would be appreciated. If you have questions, please ask. I would be more than happy to clarify.
Thanks,
Matt
error listing below
Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904): profile name is not valid at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjec>t 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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSourc>e
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Administration.SPDatabase.EnsureSqlDatabase(SqlConnecti>onStringBuilder connectionString) at Microsoft.SharePoint.Administration.SPDatabase.SetDatabaseOptions(SqlConnect>ionStringBuilder connectionString, Dictionary
2 optionsOld, Dictionary2 optionsNew) at Microsoft.SharePoint.Administration.SPDatabase.Provision(SqlConnectionString>Builder connectionString, TextReader provisioningScriptStream, Dictionary
2 options) at Microsoft.Office.Server.Search.Administration.SearchDatabase.Provision(Boole>an sqlRestore) at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.Creat>e(String name, SearchQueryAndSiteSettingsService service, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool, SPDatabaseParameters adminDBParameters, SPDatabaseParameters propertyStoreDBParameters, SPDatabaseParameters crawlStoreDBParameters, SPDatabaseParameters analyticsReportingStoreDBParameters, SPDatabaseParameters linksStoreDBParameters, SPPartitionOptions partitionOptions, Boolean cloudIndex) at Microsoft.Office.Server.Search.Administration.SearchService.c__DisplayClass3>.b__2() at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplicatio>n(String name, CreateSearchApplicationDelegate createSearchAppDelegate) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplicatio>n(String name, SPDatabaseParameters adminDBParameters, SPDatabaseParameters propertyStoreDBParameters, SPDatabaseParameters crawlStoreDBParameters, SPDatabaseParameters analyticsReportingStoreDBParameters, SPDatabaseParameters linksStoreDBParameters, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool, SPPartitionOptions partitionOptions, Boolean cloudIndex) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplicatio>n(String name, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool, Boolean cloudIndex) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplicatio>nWithDefaultTopology(String name, Type serviceApplicationType, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool searchAdminApplicationPool, Boolean cloudIndex) at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.CreateSearc>hApp() at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.ProvisionSe>archServiceApplication() at Microsoft.Office.Server.Search.Administration.SearchConfigurationJobDefiniti>on.ExecuteTimerJob() ClientConnectionId:8f84d5c4-e8f6-4b71-83e0-561792cb7c2e Error Number:14607,State:1,Class:16