Archive for the cateroy Database

   Newer Entries »

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 [...]

Automatically granted permission to connect to SQL Server

Automatically granted permission to connect to SQL Server, and they are not automatically granted administrative privileges.
 
Resolution: Grant rights to the administrator. Follow these steps:
 
Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.
 
Step 2: Click on ‘Add New Administrator’.
 
Step 3: In the ‘SQL Server User Provisioning on [...]