i can not login to SQL SERVER by a certain user name

Abdalla Elawad

hi guys

pls help me

i have problem in login in database engine , failed login what is problem but when i install sql as administrator the user is login , but by below user shows in photo itsn't login , may be this user name relate to domain (APSG-SA\aabdullah) this user name connect with domain .

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdalla Elawad9y ago
Thank you to all guys . now logim my SQL SERVER
0
Asma Khalid9y ago
You need to contact your administrator who is handling SQL server as you won't be able to login with Windows Authentication if you are trying to access remote SQL server. He/She may reset your target username/password. Also, do ensure that your remote SQL server is accessible from location other than your offiice (if applicable)
-1
Nilesh Shah9y ago
of course, you should be already logged into windows with same user name otherwise it will not work.

e.g. let's say currently I'm logged in on my PC as domain name is RN and my name is NileshS i.e.RN\Nileshs, then only when I want to login to SQL server with windows login then it will work.
0
Abdalla Elawad9y ago
Hi nilesh shah

but i try to login with windows authentication same problem

my user name connect with specific domain . is this problem ?
0
Nilesh Shah9y ago
yes by the user name patter having "\" it seems to be a windows user

first make sure this user has the necessary rights to login to SQL server.

while login you have to select windows authentication in the drop down:

+1