Re: SharePoint Portal search is not working after changing admin paasw

Just a thought but it could be the access account to the actual SQL server.
Have you verified the Administrator can access the SQL box ? try to run a
Query on SQL and see if it lets you in as the Administrator.


Steve Smith

UK Sharepoint Training
http://www.combined-knowledge.com



"Curious_2k3" <Curious2k3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC27884B-BFE2-4AED-A7FD-BADE3039EE04@xxxxxxxxxxxxxxxx
> Hi Everyone,
>
> Everything with our Portal was working fine until we changed the
> Administrator password and now we cannot search the portal.
>
> I had the original existing content databases as well as a content
> database
> I had created for our extranet. I have verified the username /password for
> the following services:
>
> Services on Portal Server
> MS SharePointPS Search Service
> SharePoint Portal Administration
> SharePoint Portal Alert
> SharePoint Timer Service
>
> All Application pools have been verified, as well as the IUSR_SERVERNAME
> password.
>
> Verified Password for services on our Database Server
> MSSQLServer
> SharePoint Timer Service
> SQLSERVERAGENT
>
> The Portal Server has been restarted and IIS has been reset numerous
> times.
> When I enter the information for the Configuration Database Administration
> Account
> I receive the following error:
>
> Error accessing database. Verify that the database server name and the
> instance name (if present) are correct. Also, ensure the configuration
> database administration account has sufficient permissions on the server
> or
> instance and the service corresponding to your SQL Server instance is
> running.
>
> I can enter the information into the Default Content Access Account
> successfully. However I cannot enter information into the Portal Site
> Application Pool Identity or I receive the same error as stated above.
>
> Also, when I click on Configure Search and Indexing I get the following
> error:
> The gatherer index was not initialized. The content index must be
> remounted.
> If the index is still not initialized, remove it.
>
> I have included a clip from one of the W3WP Logs. Some information has
> been
> changed:
>
> 12/29/05 11:24:53:828 UNK 00000000 00001E8C Adding user
> 'DOMAIN\ADMINISTRATOR' to 'db_owner' role in configuration database.
> (ourserver.SPS01_Config_db)
> 12/29/05 11:24:53:844 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'discuss'.
> (OURSERVER.Discuss)
> 12/29/05 11:24:53:875 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'OurPortalPor2_PROF'.
> (OURSERVER.OurPortalPor2_PROF)
> 12/29/05 11:24:53:906 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'OurPortalPor2_Serv'.
> (OURSERVER.OurPortalPor2_Serv)
> 12/29/05 11:24:53:937 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'OurPortalPor2_Site'.
> (OURSERVER.OurPortalPor2_Site)
> 12/29/05 11:24:53:937 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'Ext'. (OURSERVER.Ext)
> 12/29/05 11:24:53:969 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'Out'. (OURSERVER.Out)
> 12/29/05 11:24:53:984 UNK 00000000 00001E8C Granting user
> 'DOMAIN\ADMINISTRATOR' 'db_owner' role in database 'IT'. (OURSERVER.IT)
> 12/29/05 11:24:54:015 UNK 00000000 00001E8C
> System.Data.SqlClient.SqlException: Cannot open database requested in
> login
> 'IT'. Login fails. Login failed for user 'DOMAIN\Administrator'. at
> System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction) at
> System.Data.SqlClient.SqlConnection.Open() at
> Microsoft.SharePoint.Portal.Data.a.c()
> 12/29/05 11:24:54:015 UNK 00000000 00001E8C SqlError: 'Cannot open
> database
> requested in login 'IT'. Login fails.' Source: '.Net SqlClient Data
> Provider'
> Number: 4060 State: 1 Class: 11 Procedure: '' LineNumber: 0 Server: ''
> 12/29/05 11:24:54:015 UNK 00000000 00001E8C SqlError: 'Login failed for
> user
> 'DOMAIN\Administrator'.' Source: '.Net SqlClient Data Provider' Number:
> 18456
> State: 1
>
> When it complains that it cannot login to the IT database, that is because
> it was deleted over a month ago. This database and one other show up in
> the
> event log as if they "still existed".
>
> All of this just for changing the Administrator password...
>
> All assistance is greatly appreciated.
>
> Thank you,
>
> Curious


.

Relevant Pages