Connecting to a remote database using Visual studio

I have domain , database name, database user and password

I want to connect to my database remotely using visual studio 2010, How can I do this ?

  • A good way to encrypt database fields?
  • In SQL Server, should I create an index for an identity column, or is it created automatically?
  • How can I create a custom Box application to move content directly into an MS-Access database?
  • Finding Unknown XML Grandchildren Using SQL
  • SQL Server not configured for data access
  • How to connect to SQL Server from Red Hat 6.4 via Node.js
  • thanks in advance

  • Authentication in SSIS SMTP Connection Manager?
  • Stored procedure output parameter c#
  • Unable to compare the columns in SqlBulkCopy
  • ASP.NET Core - Application not connecting to database after publishing
  • Asp.Net, SQL and TimeZones
  • Convert TextBox value to DateTime SQL Server
  • 2 Solutions collect form web for “Connecting to a remote database using Visual studio”

    there are many diffrent ways to do it depending on the database type your using

    if you are looking for a wizer like way you can use visual studio toolbox and add a datasource.

    it easier to do it with connection string but in order to achive this when you want to open add new sql server connection either with server explorer or just by writing the connection string since server ui still creates the connection sttring you need to know

    Data Source=SERVER the ip adress of the server where sql server is istalled
    Replace Integrated Security with User ID and Password if you are using
    SQL Authentication.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.