Solved

MIP database will not start...access denied.

Posted on 2013-05-28
6
297 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
  • 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
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

930 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now