Re: Not allowed to switch authentication modes

Ken wrote:
i can't seem to get it to believe that I am an admin. I think I need to uninstall the entire sql server, and reinstall from scratch. I have built in/user but no built in/admin.

"Ken" wrote:

I have a copy of SQL that comes with MS Vista, and downloaded SQL Server mgmt studio express to work with it.

I want to change the authentication mode to SQL Server and Windows, and create an sa account. I have a database I then want to restore into this new system.

I go into Server Properties, and change the server authentication mode, but receive an error when I hit OK. The error is

An Exception occured while executing a Transact-SQL statement of batch:
Microsoft.SqlServer.Express.Connectioninfo)

the Execute permission was denied on the object 'exp_instance_reqwrite''

Do you know why I am getting this?
In Vista - to run as admin you have to tell Vista that you want to run that program as an Administrator. Right-click on the short-cut that you are using to launch the management studio and there will be an option to Run As Administrator.
.

Relevant Pages