Login to SQL Server 2005 with Administration Privileges on Windows Vista OS you need to explicitly login as Administrator to perform administration task on sql server 2005 objects.
Look in figure for how to login explicitly as administrator privileges on windows vista OS
So now you can able to avoid many errors like Database creation, etc
Example:
Create failed for Database 'SampleDB'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
No comments:
Post a Comment