Поделиться через

SQL Server User Provisioning Tool for Vista

  • Статья

After installing SQL Server 2005 or Express on Windows Vista you may have noticed, that your user accounts (even though being in the local computer's administrators group) are not allowed to connect to the SQL Server. Which is bad if you're not running in Mixed Mode...

With the newly released Service Pack 2 for SQL Server and SQL Express there is a new tool available called "User Provisioning Tool for Vista"
(%ProgramFiles%\Microsoft SQL Server\90\Shared\sqlprov.exe).

This tool is automatically launched on upgrade (but can be started manually as well, if any errors occur at the first time). The small app tells us that, even if users are in the local administrator group, the don't have admin access to SQL Server for security reasons under Vista. You can use this tool to explicitly grant admin permissions to the current user (if it is in the local admin group).

God bless this tool :-) Now I am able to login again...

Comments

  • Anonymous
    March 02, 2007
    The comment has been removed

  • Anonymous
    November 14, 2007
    I m having one problem when i run the above tool that list of priviliges appears on the left list is blank. I do not have proviliges in left side that i can assign on right side. can you help me on this?

  • Anonymous
    February 27, 2008
    The comment has been removed

  • Anonymous
    June 16, 2008
    Thanks a lot. This post helped me find SqlProv after it had exited with an error at the first launch.

  • Anonymous
    June 26, 2008
    Thanks! The path to SqlProv was a useful information in above post.

  • Anonymous
    July 02, 2008
    Thanks - its a shame the tool isn't put on the start menu under configuration, its a little tricky to find!

  • Anonymous
    July 07, 2008
    The comment has been removed

  • Anonymous
    August 19, 2008
    Thanks from Texas - saved me a ton of stress...

  • Anonymous
    September 23, 2008
    Just a note: I had to follow the same procedure (with the SQL Server User Provisioning Tool for Vista) even though my system is Win XP Pro SP3. This solved my problem on accessing a database on SQL Server 2005 (which I restored form an SQL Server 2000 backup). I currently have SQL Server 2005 Developer edition. This post really helped me. Thanks a lot.

  • Anonymous
    October 03, 2008
    Thanks a lot for the path to sqlprov. This tool was a real help. Had the same issue as Jocko above.  sqlprov does not indicate that sql service is down (after instaling sp2) and gives some other curt error message. Restarting the service and running sqlprov fixed the issue.

  • Anonymous
    December 19, 2008
    The comment has been removed

  • Anonymous
    February 05, 2009
    Thanks for the info, it is nice to know the location of this file to add into scripts and other automated installation methods! There is a shortcut provided for this tool; it's just not directly within the programs folders of SQL Server 2005. You can find the shortcut on your Surface Area Configuration (SAC) tool. On the opening screen you will see a link that says "Add New Administrator". This link will start the SQLProv.exe file. Just FYI for those that think MS was completely lazy...they were just really lazy in the programming of the tool itself (if that's really any more comforting at all). It would've been nice if they included something during the SQLProv startup procedures that verifies there is an instance already running, or if they tell you during the SP installation at the end to start the instance prior to adding the administrator, or even better if they actually handled the error in SQLProv and have it NOT immediately exit upon failure of adding a new administrator!!! Thanks, James

  • Anonymous
    February 19, 2009
    Note that if you're running 64-bit OS, the SQLPro.exe tool is located in the Program Files (x86) folder.

  • Anonymous
    May 20, 2009
    Hello, there is a laptop pc with Windows Vista Home Premium . We installed SQL Server2005 Developer Ed and, then, SQL Server 2005 SP2, but the sqlprov.exe file didn't appear. That was just not installed with the service pack. Actually, after that, we tried installing the SQL Server 2005 SP3 but it still doesn't appear. What you think is the cause of this issue? Thank you

  • Anonymous
    January 04, 2010
    If you have a 64-bit os, you'll have to look under 'Program Files x86' instead... (same path for the rest)