Monday, December 21, 2009

Keeping track of the SQL User Provisioning Tool

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.
Posted by at
Labels:

1 comment:

  1. AnonymousDecember 22, 2009 at 7:54 AM

    Hi (John here) Merry Christmas & Happy New Year

    Thanks for your support throughout the year!

    Hey - the Pacific IT Pros site has some errors on the pages and contact us page. They don't load or send comments properly. Stray characters even.

    Sending you more jobs this year. Los Angeles area mostly. We have 23 current openings. 7 in IT - www.lw.com.

    ReplyDelete

Subscribe to: Post Comments (Atom)

MS ITPro Evangelists Blogs

More Great Blogs