Browse by Tags

SSMS Restore backup error
14 September 2007 15:31

We had a requirement to allow someone to create and restore databases on a test server today and i thought to myself "Thats easy, i`ll just grant the "Create Any Database" right to the appropriate user, thats when the pain began! The user was using SSMS connecting using a SQL login to restore a database and when they went to specify the backup location they got... Read More...

by ACALVETT | with no comments

Filed under: SQL 2005, SSMS, Security

Configuring a secure domain account for ASP.NET on Windows 2000
26 January 2006 18:01

I recently had to enable the ASP.NET account on a Windows 2000 machine to use a domain account so we could use NT Authentication to the SQL backend and the implementation of the domain account had to be secure. The hardest bit was securing the account, I wanted to give the account as few privileges as possible and make sure the account details could not be easily... Read More...

by ACALVETT | with no comments

Filed under: Tips, Security