Re: Not allowed to switch authentication modes

It would not be enough to set a password to make the "sa" Login work. Because as I already mentioned in my first reply it's disabled by default. You'll have to enable it from its properties.

And to be able to connect using "sa" account you must change the authentication mode to Mixed Mode from Windows Authentication. You can do this from the Server Properties\Security.

--
Ekrem Önsoy



"Ken" <Ken@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A9BEFE61-D0C7-471F-BEFA-837CBA7D46A3@xxxxxxxxxxxxxxxx
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: SQL 2008 remote Management Studio connection
    ... can you recommend some good books for SQL 2008? ... Rick Byham, SQL Server Books Online ... is SQL Server and Windows Authentication mode ...
    (microsoft.public.sqlserver.connect)
  • SQL Service Pack doesnt upgrade SQL Server
    ... For the Authentication mode I used SQL authentication and gave the sa password. ... The server is a W2k Domain Controller on Windows service pack 3. ...
    (Focus-Microsoft)
  • newbie connection problem
    ... Authentication Mode = SQL, and ... On the server, I can connect to it fine, both via my app and the configure ... SQLState 8001 error 17: serber does not exist or connection denied. ...
    (microsoft.public.sqlserver.msde)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)