MIP database will not start...access denied.

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.
jeb-sbAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jeb-sbConnect With a Mentor Author Commented:
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
 
rlogCommented:
What account is the service configured to run under? You'll find it in SQL Server Configuration Manager.
0
 
jeb-sbAuthor Commented:
Have tried Network Service and local administrator and domain admin
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
rlogCommented:
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
 
jeb-sbAuthor Commented:
How do I close a question?
0
 
jeb-sbAuthor Commented:
I found the answer to the question, which was not in the same ballpark as the experts comments.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.