Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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,702 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

618 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