How to work with SQL server

Question

If I downloaded and installed MySQL server into my personal computer, how do I access or use it from a different computer and is it possible or not.

Answer 1

Yes you can for pretty much any database server. For Microsoft SQL Server, you'd want to download and run SQL Management Studio https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16, and for MySql, download and run MySql Workbench https://www.mysql.com/products/workbench/ Using the tooling on the same machine as the database service, should be fine. To access the database from a different computer you'd also need to ensure that they are networked and firewall on the database server allows inbound connections on specific ports, see https://learn.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver16#SnippetTab and for MySql https://dev.mysql.com/blog-archive/mysql-guide-to-ports/

Answer 2

Hi @Mange,Leo Phodiso,

Please check if you are using Microsoft SQL Server or MySQL.

MySQL is a widely used relational database management system (RDBMS).

If you are using SQL Server, you may follow the tutorial to use it.

Tutorial: Getting Started with the Database Engine

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @Mange,Leo Phodiso

If you are questioning about SQL Server. Yes, it is possible to access SQL Server installed on your personal computer from a different computer. To do so, you need to configure your SQL Server to accept remote connections and create at least one SQL Server authentication login. Here are the steps to follow:

1. Configure your SQL Server to accept remote connections.
2. Launch SQL Server Configuration Manager. Expand SQL Server Network Configuration for the instance you want, and select Protocols for MSSQLSERVER. You should see protocols in the right-pane. Enable TCP/IP by right-clicking TCP/IP and clicking Enable.
3. Create at least one SQL Server authentication login. To connect to the Database Engine from another computer, you must create at least one SQL Server authentication login. In SQL Server Management Studio Object Explorer, expand the folder of the server instance in which you want to create the new login. Right-click the Security folder, point to New, and select Login. In the Login - New dialog box, on the General page, enter the name of the new user in the Login name box. Select SQL Server authentication. In the Password box, enter a password for the new user. Enter that password again into the Confirm Password box. From the Default database list, select a default database for the login. master is the default for this option. If you have not yet created a user database, leave this set to master.

Once you have completed these steps, you should be able to access your SQL Server from a different computer by using SQL Server Management Studio and the SQL Server authentication login you created.

Thank You!