Here’s a tool I find myself looking for over and over again. After installing SP2 or SP3 on an installation of SQL 2005 you have the option to run the User Provisioning Tool for Vista”, allowing you to set proper access permission.
However if you haven’t restarted SQL services before running it, it fails to connect to the database and then closes. There isn’t a shortcut anywhere to restart it, so it can be a mystery as to how to locate it again. The path to the tool is:
%ProgramFiles%\Microsoft SQL Server\90\Shared\sqlprov.exe
For more information about why this tool exists, check out this msdn blog post.