A Software Engineer in the Bay Area. Living Life, Learning Software and Loving Both. RSS Feed


SQL Server User Provisioning in Windows Vista

On Microsoft Windows Vista, you may find yourself unable to access your SQL Server instance, even if the user is in the local admin group.  This is due to new security concerns in Windows Vista.  In SQL Server 2005 Service Pack 2, Microsoft released a tool called the User Provisioning Tool for Vista.

Untitled

This tool allows you to give administrative permissions to users.  The tool should launch when you upgrade to Service Pack 2, however if it encounters an error or for some reason you find yourself unable to access your SQL Server, give them rights in the User Provisioning Tool by opening the SQL Server 2005 Surface Area Configuration tool (usually found under Microsoft SQL Server 2005 >> Configuration Tools on the start menu), and clicking Add New Administrator. 

image

After that, simply add each user/server to the granted rights box on the right to give that user admin rights.

 
Posted by Brian Ellis | 2 Comments | Trackback Url | Bookmark with:        
Tags: Work

Links to this Post

Comments

Thursday, 2 Aug 2007 11:36 by Thaks
Thaks a lot, i was broking my head trying to access to User Provisioning Tool.

Thursday, 15 Nov 2007 03:53 by Do not have Permission
Hey brain, I have same problem but the thing is on the first image you have list of available permissions No list of privileges appears for me on my vista machine? can you help me on this ? tech2hard@gmail.com

Name:
URL:
Email:
Comments:

CAPTCHA Image Validation