Re: Not allowed to switch authentication modes

Ken (Ken@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I just thought abour what you meant, I only have one login on Vista, and
I am an admin. But for some reason, I am not an admin with SQL.

But you are on Vista, and unless you have disabled UAC, you are only
Admin if you request to be.

How do I "Run As Administrator from the context menu"

As you always run things from the context menu in Windows: you right-
click and there is the context menu for you.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Registry
    ... If you use FTS you need to add a login for ... there's nothing stopping a domain admin adding ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • RE: local admin account password
    ... Subject: local admin account password ... > 4) Only use domain accounts so delete the local ones. ... > The DB file would be encrypted with EFS so only the limited user SQL ... > backup user can make a zip backup of the DB whenever it gets changed ...
    (Focus-Microsoft)
  • RE: local admin account password
    ... Say you have more then 1000 systems, how do you handle the local admin ... Only use domain accounts so delete the local ones. ... The DB file would be encrypted with EFS so only the limited user SQL ... There would be basically two stored procs, ...
    (Focus-Microsoft)
  • Re: New install, login not accepted
    ... I tried to upgrade the site, which was running with MSDE, to SQL ... install SPS. ... I got through the install following the steps in the Admin. ... a admin account, that account needs admin rights to SQL and the local ...
    (microsoft.public.sharepoint.portalserver)
  • Re: user wants access
    ... I would strongly recommend you read Books Online for this information. ... the db_securityadmin fixed database role. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.server)