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.

Advertisements

One thought on “Keeping track of the SQL User Provisioning Tool

  1. 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 – http://www.lw.com.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s