Link to home
Start Free TrialLog in
Avatar of jeb-sb
jeb-sb

asked on

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.
Avatar of rlog
rlog
Flag of Norway image

What account is the service configured to run under? You'll find it in SQL Server Configuration Manager.
Avatar of jeb-sb
jeb-sb

ASKER

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't have the file permissions.
ASKER CERTIFIED SOLUTION
Avatar of jeb-sb
jeb-sb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jeb-sb

ASKER

How do I close a question?
Avatar of jeb-sb

ASKER

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