Creating new user for MSSQL database

You can login to the IP address, but you must create a user to connect to that database, you can create a user as follows:-

Select SQL Server Management Studio >> Connect To your server >> Expand Your server >> Expand Security >> Logins >> Right Click >> New login

Give login name >> give username >> select SQL Server Authentication (By default windows authentication) >> Select your database in the “default database field”

Select Server Roll tab >> give proper rolls (dbcreator)

Select User mappings tab >> select your database >> give proper database roll memberships (select all)

This will create a user who can connect remotely, but due to some bug you need to do some more things.

Expand Databases >> select your database >> Expand Security >> select Users >> delete the created user

Right click >> New User >> Give user name >> For login name browse >> Select the username that we created in the main server security tab >> Select all member rolls.

Now you are able to login using your IP address and the newly created username and password.

Note:- Select SQL server Authentication when connecting not windows authentication.