?
Solved

Cannot access Sharepoint Central Administration - Cannot open database "SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b" requested by the login. The login failed. Login failed for user

Posted on 2010-09-09
24
Medium Priority
?
1,725 Views
Last Modified: 2012-05-10
This happened after we were forced to change the admin login for the domain and I have run : stsadm -o updatefarmcredentials -userlogin... but I keep getting a login failed error:

Cannot open database "SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b" requested by the login. The login failed.Login failed for user 'Domain\Administrator'.

We have some funky characters in our domain admin password...can this be the cause or am I missing something else here? The rest of the Sharepoint site works fine.
0
Comment
Question by:Britt Thompson
  • 15
  • 8
24 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33638530
shouldnt matter.  to test, you could script it and use variables, make sure you run on your Central Admin server.....

set s="%commonprogramfiles%\microsoft shared\web server extensions\12\bin\stsadm.exe"
set user="domain\account"
set Pass="password"

%s% -o updatefarmcredentials -identitytype configurableid -userlogin %user% -password %password%
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638675
Still doesnt work....even tried a newly created domain admin by copying the administrator account that's typically used for the Sharepoint administration. All i get is access denied with the new user and I get Login Failed with the old user.

stsadm -o updatefarmcredentials -userlogin Domain\Administrator -password password

Cannot open database "SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b" requested by the login. The login failed.Login failed for user 'Domain\Administrator'.

0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638692
I should say that I can easily access the database from the SQL Management Console using the Administrator login
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 38

Expert Comment

by:Justin Smith
ID: 33638704
are you logged into the box as a farm admin?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33638756
the logged in account must also be an admin on the server.

also, are you getting the login failed button right after you run the stsadm command?  or is the command completing successfully?
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638822
I'm logged in as the farm admin and the command fails immediately...I also logged in as the newly created full access user and I also get the Login Failed.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638840
In the event logs I can see where my DOMAIN\Administrator is getting a login failed error for the SQL server:

Event Type:      Failure Audit
Event Source:      MSSQLSERVER
Event Category:      (4)
Event ID:      18456
Date:            9/9/2010
Time:            12:42:05 PM
User:            DOMAIN\administrator
Computer:      SPSERVER
Description:
Login failed for user 'DOMAIN\Administrator'. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 07 00 00 00 57 00 52 00   ....S.P.
0010: 49 00 47 00 48 00 54 00   S.E.R.V.
0018: 00 00 07 00 00 00 6d 00   ......m.
0020: 61 00 73 00 74 00 65 00   a.s.t.e.
0028: 72 00 00 00               r...    
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33638868
was domain\admin the previous account used?  does it run the Windows SharePoint Timer Service right now?

also, being a farm admin doesn't mean you're a local admin on the server.  the account you are running this command with needs to be a local admin and a farm admin.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638917
Yes. This is a Small Company and they have a single domain controller running WSS. I am logged in as DOMAIN\Administrator which was the original user configured to access the Sharepoint Admin. This domain administrator is the Enterprise admin...see the group memberships below.
Screen-shot-2010-09-09-at-12.54..png
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638931
I've discovered that when you are not logged in as the user when running the command you get "Access Denied" as opposed to "Cannot open database "SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b" requested by the login. The login failed.Login failed for user 'Domain\Administrator'."
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33638987
you will get access denied if the account you are logged in as is not a local admin and farm admin.

it soudns to me as if the password is being mistyped or it's not being accepted.  can you just reset the password temporarily to something simple just to test?
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33638989
Ok...well, I got the command to run by adding the "-local" to the end of it but it still will not authenticate/find the Sharepoint_Admincontent_... database:

Event Type:      Error
Event Source:      Windows SharePoint Services 3
Event Category:      Database
Event ID:      3760
Date:            9/9/2010
Time:            12:59:53 PM
User:            N/A
Computer:      SPSERVER
Description:
SQL Database 'SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b' on SQL Server instance 'spserver' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_AdminContent_30523b30-497d-4007-94ac-11ef3534419b" requested by the login. The login failed.
Login failed for user 'DOMAIN\Administrator'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33639025
if you add -local at the end, it won't update the config db....bad.

can you verify in sql that the domain\administrator has rights to the database?  i dont see why it wouldnt if it was the previous account....but just double checkign.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33639141
In the SQL manager there is a user called "dbo" whose "Login Name" is DOMAIN\Administrator and it's the "db_owner"
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33639169
strange.  i would reset the password to something easy just to test.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 33639274
you might also try to delete the update farm credentials timer job from the job definitions page.  then try running again.

take a look towards the bottom of this page:  http://www.wijix.com/post/Updating-SharePoint-Farm-Credentials-(Associated-to-Error-Code-997).aspx
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33639357
Changed it to something much simpler and I'm still getting login failed.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33639422
Here's an additional error logged after the IIS restart and the restart of the SQL service:

Event Type:      Error
Event Source:      Windows SharePoint Services 3
Event Category:      Database
Event ID:      5586
Date:            9/9/2010
Time:            1:38:39 PM
User:            N/A
Computer:      WRIGHT
Description:
Unknown SQL Exception 233 occured. Additional error information from SQL Server is included below.

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33639537
Tried setting it back to the old password to no avail. Can still only make the change with the -local switch
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33639785
Even the configuration wizard runs successfully.
0
 
LVL 9

Expert Comment

by:irinuc
ID: 33647179
One suggestion if I may: try checking the identity that is running the SQL service on the SQL box.
I saw something similar when the account running the SQL service was started with an identity of an expired account.
0
 
LVL 30

Author Comment

by:Britt Thompson
ID: 33647866
Good idea but same result. It was running under the local system and I switched it to the main admin user...makes no sense unless there's somewhere I'm missing that the password needs to be edited. Still says it can't find the database and the login failed.
0
 
LVL 30

Accepted Solution

by:
Britt Thompson earned 0 total points
ID: 33689859
I discovered that the previous admin had slightly renamed the database within the SQL management console after deciding to copy and paste the name of the database from the errors I was receiving to the database name within the console. As soon as I did that I was able to run the stsadm command to update the credentials. Now it works perfectly. Thanks for the help.
0
 
LVL 30

Author Closing Comment

by:Britt Thompson
ID: 34317123
Solution was found on my own accord.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question