Re: Not allowed to switch authentication modes

From SSMS - connect to your database in Object Explorer. Open the folder for Security, logins, select the sa account's properties and set the password.

Or, you can open a query and execute sp_password (see BOL).

Jeff

Ken wrote:
Thanks!! That worked!

Do you know what the password for sa is, or how I can set it? I did not install SQL so I did not set one.

"Jeffrey Williams" wrote:

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

  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: xp_cmdshell, ownership chaining, sql 2000
    ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
    (microsoft.public.sqlserver.programming)
  • xp_cmdshell, ownership chaining, sql 2000
    ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
    (microsoft.public.sqlserver.programming)
  • Re: Data migration questions?
    ... Use SSIS or the SqlBulkCopy class to import the data into SQL Server. ... Anyone who has read my books knows that I'm not in favor of including BLOBs in the database. ... "Mervin Williams" wrote in message ... should I use a DataSet to bring the data down to the local machine that will run the code and execute the transformation logic from it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with bulk load security.
    ... Then I defined the procedure using 'with execute as self'. ... database is trustworthy, you cannot get rights outside the database. ... One is to make the database trustworthy, ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.security)