Re: Not allowed to switch authentication modes

Thanks!! That worked! I really appreciate all of your help.

Ken

"Ekrem Önsoy" wrote:

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: SharePoint Portal search is not working after changing admin paasw
    ... Just a thought but it could be the access account to the actual SQL server. ... Query on SQL and see if it lets you in as the Administrator. ... > Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
  • MS SQL Server Administrator / Hessen
    ... Projektaufgabe: MS SQL Server Administrator ... Für unseren Kunden in FFM suchen wir einen Datenbank ...
    (de.markt.arbeit.vermittler)
  • MS SQL Server Administrator / Hessen
    ... Projektaufgabe: MS SQL Server Administrator ... Für unseren Kunden in FFM suchen wir einen Datenbank ...
    (de.markt.arbeit.vermittler)
  • Re: Can not access Search and Indexing page
    ... your SQL Server by clicking "Configure Server Topology." ... also check your configuration under Component Configuration (again on ... please see your network administrator. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: OK - Im stupid....How do you create a user?
    ... not a Windows login, you'll need to change the authentication mode SQL ... Server uses from "Windows Authentication" to "SQL Server and Windows ... Windows authentication mode if at all possible. ...
    (microsoft.public.sqlserver.security)