In this video, we are going to cover how to create a database and connect to it using SQL Management Studio. In this video, we will show you how easy it is to get started using SQL Management Studio and create a database. We will also walk you through connecting that database to other applications in order to make use of its features. So if you are looking to master SQL Management Studio, then watch this video and learn everything that you need to know!
How to allow a user to connect to Microsoft SQL Server from Outside Network:
Step 1: Enable SQL Authentication (Very Important)
- In SSMS → Right-click server → Properties
- Go to Security
-
Select:
SQL Server and Windows Authentication mode - Click OK
- Restart SQL Server service
Step 2 : Create a SQL Login for Remote Access
Create Login
CREATE LOGIN remoteuser WITH PASSWORD = 'Strong@Password123';USE YourDatabaseName;CREATE USER remoteuser FOR LOGIN remoteuser;ALTER ROLE db_owner ADD MEMBER remoteuser;Note: Make sure that port 1433 is allowed in windows firewall.
To get affordable server management services and server solutions visit: https://activeservers.in/security/serversolutions.aspx
