How to connect to sqlserver instance installed on a computer in another network

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  July 16, 2008 at 2:38 am

  #154532

  Hi,

  I need help on how to Connect to SQL Server Instance installed on a computer in another Network.

  Take for example, I need to access a database on a pc in an internet network. What do i need to do to achieve this?

• Paresh Randeria

  Ten Centuries

  Points: 1150

  More actions

  July 16, 2008 at 2:47 am

  #843605

  Window Authentication will not work. SQL Server instance should be Mixed Authentication.

  Provision a login id and grant proper database access to the login id.

  Now you can connect using this login id.

• alimcitp

  SSC Eights!

  Points: 930

  More actions

  July 16, 2008 at 3:29 am

  #843629

  You can either Remote Desktop the SQL Server machine OR Use SQL Authentication.

  Basit Ali Farooq
  MCITP Database Administrator
  Microsoft Certified Professional Developer (Web Applications)
  Microsoft Certified Database Administrator
  Microsoft Certified Systems Engineer
  Microsoft Certified Systems Administrator
  CIW Security Analyst
  Cisco Certified Network Associate