Re: Search services not available

Let me clarify that our SQL server uses Windows Authentication, and I have
"assigned" the same windows user account to the search service as the one
that runs the IIS application pool. I thought that by using the same
account, even if it was just for now to get it working, that would be easier
since I only have one user account to worry about all of sharepoint.

I have four databases in my SQL server:
SP_TEST_GMSNET (which is the config database)
SP_TEST_GMSNET_CONTENT (which is one and only content database)
WSS_SEARCH_GMSDEV (which is the database created by sharepoint for the
search services)
WSS_AdminContent (not sure what this is, but obviously something to do
with the administration console for sharepoint because when I took it
offline, I couldn't connect to the Central Administration. :).

I have one windows account, called SPService, which is a db_owner of all 4
dbs listed, and has 2 SQL server roles: dbcreator and securityadmin.

In Central Administration, I have configured the Search service to use this
account for the search services (Service Account and Content Access
Account). When I type in the password for this service and click OK, it
appears to accept it. But when I go back to this page, the password fields
are blank. I don't know if that's because it doesn't retain the password
for security sake or if it didn't actually accept the password in the first
place. Nevertheless, when I switch back to the "Services on Server" page,
the service called "Windows SharePoint Services Search" has the comment
"Required on Farm, not running" and under the status column, it says
"Starting" and there is no value in the action column (i.e. I can't start or
stop the service).

When I check the actual Windows Sharepoint Search Service in the windows
control panel admin tools, I can start it, stop it, whatever. The Log On As
field is the SPService user account I created in Active Directory for
running the Sharepoint services with.

I have tried rebooting the server, but when I go into the Sharepoint Central
Administration, it lists it as "Starting".

Any advice?


"Luke Zhang [MSFT]" <lukezhan@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:tso4cDOGHHA.2488@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello Dave,

Do you mean the service's status is still "starting"? If you perform a
reboot on the server and check the service's status, will it be started
correctly?

Sincerely,

Luke Zhang

Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no
rights.




.

Relevant Pages

  • Re: VS2005: SQL Debugging "T-SQL execution ended without debugging. You may not have sufficient
    ... > account also must be a member of the sysadmin role in the target SQL ... and the Windows firewall is disabled on both client & server. ... to the remote SQL Server 2005. ... But I'm still getting the "T-SQL execution ended without debugging. ...
    (microsoft.public.vsnet.debugging)
  • Re: Utter madness!
    ... It is just Windows security stuff. ... You can get a trusted connection back to SQL server. ... ASP.NET account (either processModel or app pool identity depending on ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Passthrough authenication w/ SQL trusted connection
    ... separate connection will be used for each security context (each user ... account will have it's own pool). ... if you are using a Windows 2000 Domain, ... backend SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • connecting to sql server with windows authentication
    ... using windows authentication. ... Use delegation to leverage the current user's account. ... development machine, a live machine, and local installs of IIS for all your ... our DBA wants to keep SQL Server authentication ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Permissions!
    ... This account is used because your web ... application is configured for anonymous access instead of integrated ... The details on how to use Windows ... SQL Server MVP ...
    (microsoft.public.sqlserver.security)