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 removedAnonymous
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 removedAnonymous
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 removedAnonymous
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 removedAnonymous
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, JamesAnonymous
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 youAnonymous
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)