Security - SimonS Blog on SQL Server Stuff

Browse by Tags

All Tags » Security (RSS)

Creating service accounts should setup do it for you?

How many people actually create accounts for the SQL Server services to use? I would expect that once you step out of the enterprise the majority wouldn't be. Even though its bet practice. Why do I think that? Because its generally a pain. If installing...

How to access SQL Server when you've forget the password

There is a little known feature of SQL Server 2005 is that when you start SQL Server in single user mode local administrators of the server have sysadmin access to the sql server. You may feel this a security concern, but if a user can get local admin...