unable to connect on SSMS with sql server username and password

Amit Tewari 16 Reputation points
2021-07-16T10:25:00.643+00:00

Hi,

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.
14,479 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,571 Reputation points
    2021-07-19T05:42:16.063+00:00

    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,
    Seeya


    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 117.1K Reputation points MVP
    2021-07-16T12:01:21.393+00:00

    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 192.168.240.6 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 46,041 Reputation points
    2021-07-16T12:49:04.887+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.