Insert data in SQL Server without being installed on my computer


I want to know if there is any way to insert data in a database that is in SQL Server without having any of the versions of this installed or have Visual Studio installed e my team.

These are the data I have:

  • server = tcp: "Link to connect to the DB", 1433
  • user = username
  • pass = password
asked by Pedro Miguel Pimienta Morales 23.02.2017 в 18:01

4 answers


That is possible, both computers / servers where the system will run and where the SQL Server will be installed must belong to the same network.

In case you do not go on the same network, a VPN is a possible solution: D

Now, if what you are referring to is software to manage and / or execute queries, I recommend the same SQL Server Management Studio link and if you are looking for a good alternative to it, use this: link

answered by 23.02.2017 / 18:03
Set cnn = New Adodb.Connection
            cnn.Provider = "SQLOLEDB"
            cnn.ConnectionString = "driver={SQL Server};" & _
                                   "server=195.248.589.11; " & _
                                   "database=Basedatos; " & _
answered by 23.02.2017 в 18:51

Also, you have this option

Toad Sql Server

answered by 10.03.2017 в 01:15

You could connect using Navicat is a database manager.

answered by 23.02.2017 в 18:03