Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

windows authenctication not working 1

Status
Not open for further replies.

miscluce

MIS
Oct 4, 2007
149
US
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?
 
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
 
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)
 
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.
 
yes, it isnt logging in to the domain. how can I fix that
 
ok I got it but I have to log on as other user everytime. its not like xp where its my default logon username
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top