Re: Locked out again?

In Vista by default you are not an admin and as such not part of the
sysadmins group. You need to make yourself an admin, create an account for
yourself in SQL Server and then you can log in without being an admin. This
wasn't an issue with XP because you were generally always an admin on the
box when you logged in. Vista changed this default because running as an
admin made viruses much more nasty. I think that SP2 is supposed to create
this user for you automatically but I don't know if that part of it works in
the current CTP.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"brett" <account@xxxxxxxxx> wrote in message
news:1167501829.564730.89250@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm running this on Vista. I always turn off account access control.
After installing SP1 for SQL Server and rebooting, access control was
reenabled. This prevented me from logging into SQL Server. I've once
again turned access control. Now I can log in.

Brett



.

Relevant Pages

  • Re: Vista Bus to SBS2003R2 connectcomputer problems . . .
    ... On the Vista Workstation, right click on the IE icon on the desktop and choose run as Adminstrator ... protected mode also add the server FQDN or IP to the list of trusted sites. ... Also tried all flavours of running the procedure with admin rights. ... Small Business Server Network Configuration Wizard: ...
    (microsoft.public.windows.server.sbs)
  • Re: XP SP2 uograde to Vista - Access denied to SQL 2005
    ... I upgraded XP to Vista. ... I log in with the default admin account ( ... and then add your login to SQL Server and then add it ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Interrupted download SP1 for Vista Business - fix error too!
    ... My Vista Ultimate can't go to real Admin mode. ... But i manage to start regedit in safe mode as real admin. ... Like upgrade and install. ... MS MVP-IE, Mail, Security, Windows Desktop Experience - since 2002 ...
    (microsoft.public.windowsupdate)
  • Re: Compiling DLL & Vista: Follow up
    ... running as an Admin or setting a program to run as Admin will ... The biggest problem I've found in my cool little registry hack to register ... Try reading the Vista newsgroups....lots of complaining about the UAC. ...
    (microsoft.public.vb.general.discussion)
  • Re: Vista Bus to SBS2003R2 connectcomputer problems . . .
    ... gone over every nook and cranny including the Intranet settings which by ... protected mode also add the server FQDN or IP to the list of trusted sites. ... When you connect your Vista machine to the LAN, and it gets an IP from the ... Also tried all flavours of running the procedure with admin rights. ...
    (microsoft.public.windows.server.sbs)