Thanks Manu, the State is 11 (its also mentioned in the error post earlier). I have been to that link many times even Jeff referred me the same. But the...

Let tell u that the same user were able to access before but all of the sudden they are not. i used following script to create windows login in SQL

--...

Thanks, i have already been through those links but nothing seems to work. i also have the SP3 installed but everything is same.

It only allows user to login if...

But i am using windows authentication not Kerberos.

but it works if i give user sysadmin but in that case the user wil be admin which i dont want.

I also have a similar kind of problem, http://www.sqlservercentral.com/Forums/Topic865240-146-1.aspx#bm865288

my super users are not able to connect to SQL via Windows login untill i give them sysadmin 🙁

Yes the SQL Browser Services are running. It Not Express edition but Enterprise 64bit and yes its a server machine.

Yes my frined i know that i dont need to give...