Solved

MIP database will not start...access denied.

Posted on 2013-05-28
6
303 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

861 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