Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MIP database will not start...access denied.

Posted on 2013-05-28
6
Medium Priority
?
317 Views
Last Modified: 2013-12-16
at 5:48 AM this morning (CST) the MIP database exited and could not restart.  The SQL server reports that access is denied with an error #17058 and a source of MSSQL$MIP.  Have been working on it for a couple of hours.  Tried using local admin credentials...no dice.  Tried network creds, .....nope.  There are two other instances on the Sql Server 2005 that are running fine.
0
Comment
Question by:jeb-sb
[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
  • 4
  • 2
6 Comments
 
LVL 4

Expert Comment

by:rlog
ID: 39202677
What account is the service configured to run under? You'll find it in SQL Server Configuration Manager.
0
 

Author Comment

by:jeb-sb
ID: 39202916
Have tried Network Service and local administrator and domain admin
0
 
LVL 4

Expert Comment

by:rlog
ID: 39203652
Ok - but open Services and look at SQL Server service. Can you see what account it runs under (NT Authority)? The errormessage indicates that the account you want to start SQL Server under doesn't have the file permissions.
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

Accepted Solution

by:
jeb-sb earned 0 total points
ID: 39233656
Don't know what to do with this question. I was able to solve it finally by reading the PDCE firewall log and found for an unknown reason the PDCE was clocking any request from the MIP server.
0
 

Author Comment

by:jeb-sb
ID: 39418137
How do I close a question?
0
 

Author Closing Comment

by:jeb-sb
ID: 39721052
I found the answer to the question, which was not in the same ballpark as the experts comments.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

730 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