Cannot use Windows Authentication to connect to local Sql 2005

Hi,
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.
Any ideas?
Thanks
AndyAndy (andyj@.med-associates.com) 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@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Jul 12, 6:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> 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.
Yes, I ran the provisioning tool. I added my user specifically and
granted connect and control server, that seems to have worked. I
thought I had tried something similar by adding domain admins, but
that didn't seem to work.
Thanks for the tip.
Andy