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?

[Webinar] Streamline your web hosting managementRegister Today

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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
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
All Courses

From novice to tech pro — start learning today.