unable to connect on SSMS with sql server username and password

Amit Tewari 6 Reputation points


I am Amit and want to connect to sql server through SSMS on my PC. I have get a error "login failed for user".

This user working fine when I have connect to into our server. and also when take server on Remote Desktop it is working fine. but when connect through SSMS with local ip and public ip it is not working. for this is any configuration in sql server? for reference screenshot Attached.115425-sql-issue2.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,026 questions
{count} vote

3 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,306 Reputation points

    Hi @Amit Tewari ,

    Refer to this, which describe the error states in ‘Show details‘.

    You are trying to connect using SQL Server Authentication, verify that SQL Server is configured in Mixed Authentication Mode. For more information on changing SQL Server authentication mode review Change server authentication mode.
    Verify that SQL Server login exists and that you have spelled it properly as well.

    If your error indicates state 1, contact your SQL Server administrator.

    Best regards,

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

  2. Erland Sommarskog 88,856 Reputation points

    I would guess the answer is that your username and password is not valid on the SQL Server instance you are connected to. You will need to talk to the DBA who is responsible for if you can get access.

    Keep in mind that username+password is specific per instance, so just because it works on one machine, it does not mean that it works on another.

    0 comments No comments

  3. Olaf Helper 34,591 Reputation points

    This user working fine when I have connect to into our server. and also when take server on Remote Desktop it is working fine

    You use Windows credentials to logon to Windows server / via RDP. Windows credentials <> SQL credentials.

    In SSMS use option "Authentication" = "Windows" to logon; no need to enter your Windows credentials again.

    0 comments No comments