Enable TCP/IP remote connections for SQL server and give user permission

1)  Open Microsoft SQL Server Management Studio and create a new user Security -> Logins -> New Login

2)  Grant privileges to the newly created user

3)  Right click server instance and go to Server Properties and make sure that remote connections are allowed to this server.

4)  Now open up SQL Server Configuration Manager

5)  In SQL Server Services make sure the SQL Server is running

Note: Some times when you select SQL Server Services, right hand side shows an error server threw an exception [0x80010105]. Solution for this is, go to Services and scroll down to Windows Management Instrumentation service and Restart it. Now when you close and reopen the Server Configuration Manager, you will see the full list of SQL Server Services.

6)  Next select Protocols for the server instance and make sure the TCP/IP is enabled

7)  Finally go to TCP/IP properties. In localhost(in this instance IP9) and in IP All, remove all dynamic ports and add default port 1433 as TCP port