Instructions for SQL Server 2005:
Open SQL Server Management Studio from your desktop (you don’t need to log
onto the server) and instead of logging in as Windows Authentication, select
SQL Server Authentication and enter SA as the log in and then the SA password.
Once logged in, go to Security/Logins and you should see your AD account in
there as .
Right click on your account and select Properties, and click on Server Roles. If
you are comfortable with full access, I would just check them all.
Click OK, then close SQL Server Management Studio and then open it again and log
on as you and see if you still get your error. You shouldn’t.
Since you do not know how to do this basic SQL Server admin task, be careful in
SQL Server as you now also have full rights to screw up everything now! J Where
your previous account permissions might have been just read only on a few