windows authenctication not working 1

[miscluce]

I just installed SQL 2005 developer on a vista machine and my windows authentciation is not working? SQL server is configured for mix mode and I have shared memory, tcp/ip and named pipes enabled. The problem to me is when I log in to the server it has my
username: "computer name\username"
but it should be
username "domain1\username" and this is grayed out. I cant chnage it. anybody know how I can fix this?

 

[mrdenny]

What's the error that it gives you?

Have you installed SQL Service Pack 2 yet? You'll need to in order to get the SQL Server working correctly on Vista.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[miscluce]

the error I am getting is:
Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
View products that this article applies to.

it wont let me update with the service pack2 it tells me:

my account could be verified because it is using the wrong username("computername\username") which should be (domain1\username)

 

[yelworcm]

When you log into the Vista machine, do you log in as a local account, or a domain account? If there is no choice there, either, you may be able to get around this by temporarily making the local account a local admin for the install, and demote the user after you are done.

 

[miscluce]

yes, it isnt logging in to the domain. how can I fix that

 

[miscluce]

ok I got it but I have to log on as other user everytime. its not like xp where its my default logon username

 

[miscluce]

actually i fixed.. thankx. a simple oversight