<div>
What account is the service configured to run under? You'll find it in SQL Server Configuration Manager.
</div>


<div>
Have tried Network Service and local administrator and domain admin
</div>


<div>
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.
</div>


<div>
I found the answer to the question, which was not in the same ballpark as the experts comments.
</div>


<div>
<div class="content wysiwyg-content">
at 5:48 AM this morning (CST) the MIP database exited and could not restart. &nbsp;The SQL server reports that access is denied with an error #17058 and a source of MSSQL$MIP. &nbsp;Have been working on it for a couple of hours. &nbsp;Tried using local admin credentials...no dice. &nbsp;Tried network creds, .....nope. &nbsp;There are two other instances on the Sql Server 2005 that are running fine.
</div>
</div>


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.

What account is the service configured to run under? You&#39;ll find it in SQL Server Configuration Manager.

Have tried Network Service and local administrator and domain admin

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&#39;t have the file permissions.

I found the answer to the question, which was not in the same ballpark as the experts comments.

MIP database will not start...access denied.

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.