14
How to Grant Administrative Rights on SQL Express 2005?
1. Log in to Windows Vista using your administrative account
2. Open SQL Server Surface Area Configuration Application ( Start –> All Programs –> Microsoft SQL Server 2005 –> Configuration Tools –>SQL Server Surface Area Configuration)
3. Click on Add New Administrator (pointed in the image) link
4. A new window with title ‘SQL Server User Provisioning on Vista‘ popup and displays the permissions on the left panel.
5. Select the permission ‘Member of SQL Server SysAdmin role on SQLEXPRESS’ available on the left panel and add it to the right panel with the help of add button( button with > text) available in the window.
6. Click on OK button to save the changes.
7. That’s all now your Windows
login has administrative privileges on SQL Server.
That’s all really nice and helpful; and I thank you for that; however, the issue is that if you go back to the SQL Server 2005 Surface Area Configuration to Add New Administrator, any user other than the Windows login user will not get granted Admin priviledges in the SQL no matter how we approach it. I’ve tried the above and works fine for my Vista admin account; I have created a user for SQL Server Admin only and tried to add it through the above method to no joy… The Priviledges are there but do not get granted to this user for some unknown reason. Any guidance you may be able to provide would be most welcome.
Kindest regards,
P. Adamus