Re: Cannot use Windows Authentication to connect to local Sql 2005

Andy (andyj@xxxxxxxxxxxxxxxxxx) writes:
I am building my workstation again, freshly installing everything.
The OS is Vista Business, 32 bit. I've installed Sql Server 2005
Developer Edition fine and applied service pack 2 successfully. It
seems to run fine, with one exception.

I can't logon using Windows Authentication. I'm a member of the Local
administrators group (as well as a Domain admin), but my domain
\username gets a logon denied error. I can logon just fine with the
sa account, but I prefer Windows Authentication.

Did you run the special Vista thing at the end of the SP2 setup? Keep in
mind that on Vista you are normally not admin, only if you request and
confirm. Either start Mgmt Studio with Run As Administrator, or - better -
add your Windows user as a long and grant it CONTROL SERVER.


--
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: Visual Studio 2005 on Vista
    ... I have Vista on my home computer, ... and I have easily migrated my SQL Server 2000 databases to the new ... I have successfully migrated SQL Server 2000 ... not dictated by software vendors, but by the nature of the technology. ...
    (microsoft.public.vstudio.general)
  • Re: Connection Manager + Remote SQL Clients
    ... This error is typical of a SQL Server configuration where you are using ... Windows Authentication to connect to your backend database whereas your ... Vista machines. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL2005 Development Edition in Vista Ulitmate
    ... The message I received was that there were "known compatibilty problems with Vista and SQL 2005". ... Microsoft SQL Server 2005 on Microsoft Windows Server 2008 or Microsoft Windows Vista ... SQL Server 2005 SP2 is not supported in production environments. ...
    (microsoft.public.sqlserver.setup)
  • Re: Protecting Against Hacking Threats
    ... vista ultimate and changed the security settings of my USB hard drive. ... I need to protect my Windows Vista Ultimate server & SQL Server 2005 ... Is there a way for a VB.Net client to SQL Server 2005 to authenticate ... Vista comes with a quite few security features: ...
    (microsoft.public.sqlserver.security)
  • RE: MSDE Running on Two Computers in Workgroup Mode
    ... There are a number of reasons why this error may occur: ... Most probably you may not be able to logon on to the sql server using ... Try using windows authentication over named pipes instead fo tcp/ip to ...
    (microsoft.public.sqlserver.msde)