Error when creating service application (search) appears to be the sql account [closed]

Question

I'm logged in as the sp_farm account for all testing. Local admin on the sharepoint server. It also has all the SQL rights up to SA.

IE enhanced security is disabled.

I'm right clicking and running IE as admin.

When I go to create the search application get 'ketech\sql-db-svc' not found. That account does exist in AD and its display name matches the name on its account properties tab. ketech\sql-db-svc is a local admin on the sharepoint server.

BUT that login doesn't exist in SQL studio. When I go to re-create that login I get 'The server principal 'ketech\sql-db-svc' already exists. So it looks like my DB access accounts are confused.

Help much appreciated - I really need this rig up in the next 2-3 days.

Answer 1

Where are you trying to create the account? Under server logins or logins for a specific database? I've got this message before when attempting to create a new login for an account that already has access to a specific DB (e.g. if restoring from another environment).

I am also assuming that this is a development environment - if not, I should probably mention that you shouldn't be logging in with the farm account unless absolutely necessary. In my experience it's required occasionally but best practice states that you should NEVER login with the farm account.

You might also want to try creating your search service application using PowerShell - I personally wouldn't use the UI to do this.