Solved

Why is a content db showing failed service logins in Sql Server 2008r2?

Posted on 2011-03-14
7
519 Views
Last Modified: 2012-05-11
We had an old content db that was not mounted and tried to take it offline.  When we did it returned service account login errors.  I am wondering why these errors are happening because this content db is not attached to a site collection.

The only other thing is that our current web app uses the same service account name but I don't see how that would have any bearing on a completely different content db with a different name.  We want to take the db offline and see then see if we need to keep it however it is throwing these errors.  
0
Comment
Question by:swtjen1
[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
  • 3
  • 3
7 Comments
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35132352
Well, when you create a content database,  you specify which web application it will be created under...so if all of your content databases are under the same web application, it will use the access account that the web application uses.

Have you tried moving the content database to a new, empty web application?
You could go and create a new web application, and then attach the database there.  

Moving it this way might solve the issue, or at least bring other issues to light.  If possible, make the service account that runs on the 2nd web application different than your 1st web application, so that you can differentiate the errors that (may/most probably will) show up.
0
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35132687
You know what, I misread the fact that it wasn't mounted!  Sorry about that!  The access account for that database will still be the same, I believe, as the account that created it.  Even though it is not mounted, the permissions within SQL Server Management Studio on that database are going to be the same.

A quick thing to check would to open up the SQL Server Management Studio, log in, expand databases, expand the database that you're looking for, and check out the security, logins, and roles on it.  You can change the accounts there (removing or adding, etc).  If it's not mounted, you should be fine.

And since it's not mounted into SharePoint, you can back the LDF and MDF and logs to a file share somewhere, and then remove the database completely from your SQL server...which should get rid of pretty much all of your errors.  You still have the LDF/MDF/Logs, so you can re-attach the database to the SQL server if needed, and from there attach it to a site collection if needed.

But if you're looking to just completely remove this database from the picture to see if your farm is ok without it, then do what I suggested with backing up the database, and then removing it from the database.  You can always restore later, and since nobody is using it, it shouldn't cause any problems.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 35136740
Not sure what version of SharePoint you are on, but I've seen this issue in multiple 2010 farms.  Random SQL login failures to databases that are attached to apps.  I'm starting to think it's a bug in 2010.
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:swtjen1
ID: 35138263
Yeah this database is not mounted to any site collection and it is a 2007 db that we moved over to a 2008 sql r2.  It was a temporary content db we used to move over information into our 2010 environment.

We ran a trace and it appears to be coming from a test server (Sharepoint 2007) we don't even use any more.  I went to look at the web application list and site collections and that content db is not listed anywhere.  So that confuses me more.  

Maybe it could be attached to an app somewhere?  I will look and see if that could be the case but I'm not sure how.  Thank you for your suggestions.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 35138281
So, is SharePoint and SQL on different servers?  Or all on one?  if different, where are you seeing the errors (what log)?
0
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 500 total points
ID: 35138722
Well, you'll know it's attached to a web application by just looking at your list of databases.
Central Administration > Application Management > Manage Databases > select your Web App from the drop down > view content databases associated with that.

Have you tried removing it completely (after backing up your transaction logs, ldf, and mdf files)?  I was under the impression that you wanted to find out if you needed that database or not, so if you're trying to test that out, I believe removal to be the best way (since you'll also have a backup).

You could also run this script, located here http://sharepointpsscripts.codeplex.com/releases/view/53114, to enumerate through all of your content databases (through all web applications, as well), to see if it might give you an idea if it's being ran somewhere in your 2010 farm.  You'll need Powershell on the 2007 machines in order to run this on those, though.
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 35242857
update please.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 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