Post reply

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

  • 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?

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply