Home Forums SQL Server 2008 SQL Server 2008 Administration DEEP Deep TROUBLE!!! MSSQL Services not starting and TCP Actively Denying connection errors. PLEASE HELP RE: DEEP Deep TROUBLE!!! MSSQL Services not starting and TCP Actively Denying connection errors. PLEASE HELP

  • Perry Whittle (5/29/2015)


    open explorer and find the data folder then right click and select properties. On the security tab you'll see details of permissions applied

    for the master.mdf permissions are as follows

    everyone- full control

    system-full control

    service administrator-full control

    SQLServerMSSQLUser$SQL$MSSQLSERVER- Full Control

    Administrators[servername\Administrators]-Full Control

    Same Permissions are applied to the mastlog.ldf