Made a big mistake

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

homebrew01 SSC Guru Points: 55548 More actions · Answer 1

Just change the account that MSSQLSERVER & SQLSERVERAGENT uses to another account.

Xavier Cabezas SSC Rookie Points: 46 More actions · Answer 2

I have tried that but when I try to start the service again I get the following error message.

Error 5: Access denied to start the MSSQLSERVER service

ram4tech Hall of Fame Points: 3140 More actions · Answer 3

1.) Try login as admin on the Windows box.

2.) Run --> services.msc (Will get you to services window)

3.) Look for MSSQLSERVER service, right click and select properties.

4.) In properties window, select LogOn tab, pick "Local system account" for Log on as: & apply and close the window.

5.) Go to the services window and try starting the service.

HTH

-R

Xavier Cabezas SSC Rookie Points: 46 More actions · Answer 4

SSC Rookie

Points: 46

August 19, 2005 at 9:16 am

Thanks! That worked.

homebrew01 SSC Guru Points: 55548 More actions · Answer 5

Why would Local Account work, but another account didn't work ? Did your other Windows account not have any permissions ?

Xavier Cabezas SSC Rookie Points: 46 More actions · Answer 6

The other account did have permissions, I just didn't want to log as the admin of the machine.

Is there any tools I can use to test my security? I have used the MS Baseline Security Analyzer.

Thanks for all your help.

XC

Jo Pattyn SSC-Dedicated Points: 32341 More actions · Answer 7

although not a security tester, microsoft released a tool to report how properly your sql server is configured.

xblondel Right there with Babe Points: 768 More actions · Answer 8

Hi!

Although not a software, the NSA published a guide on how to secure SQL Server:

BTW, they also publish guide on securing Windows (because a hardened SQL Server on a non-secured Windows box is pointless! )

Bye,

Xavier