question

AmitTewari-9063 avatar image
1 Vote"
AmitTewari-9063 asked KUL-5412 commented

unable to connect on SSMS with sql server username and password

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-general
sql-issue2.png (25.8 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @AmitTewari-9063 ,

We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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.





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SeeyaXi-msft avatar image
1 Vote"
SeeyaXi-msft answered KUL-5412 commented

Hi @AmitTewari-9063 ,

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your help! The server allows to add users for local verification, but it may not be configured for a mixed mode of checking these local users ...

0 Votes 0 ·