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: 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: SQL server rename
    ... Execute a update statistics for all tables ... Execute a DBCC CHECKDB on the database and analyze the log ... > I had to rename the server that I am running sql server 2000 on. ... > If I use query analyser I can connect to the database no problem. ...
    (microsoft.public.sqlserver.setup)
  • DENY table SELECT, GRANT stored proc EXEC, but EXECUTE a string
    ... I am trying to prevent access to a SQL Server 2000 database from other ... I wrote a script that GRANTS EXECUTE to ... So members of the cps_ilp global group are able to run our web app ... Access is denied because SQL Server thinks we are SELECTing directly. ...
    (microsoft.public.sqlserver.security)
  • Re: DENY table SELECT, GRANT stored proc EXEC, but EXECUTE a string
    ... You mentioned 'programmmer' - is this a case for using application roles? ... > I am trying to prevent access to a SQL Server 2000 database from other ... > Access is denied because SQL Server thinks we are SELECTing directly. ... > were using static statements in our stored procs instead of EXECUTE, ...
    (microsoft.public.sqlserver.security)