Post reply

Remote connection

  • December 6, 2009 at 8:51 pm

    #136739

    Hi Everyone,

    Can you plz let me know that anyone experienced any impact by allowing remote connection to sql server.. any impact on application ect..

    This will be more helpful to me to decide wether to allow remote connection on my sql server 2005,sp3

    Thanks..

  • December 6, 2009 at 9:15 pm

    #1088346

    CANCER (12/6/2009)

    This will be more helpful to me to decide wether to allow remote connection on my sql server 2005,sp3

    Thanks..

    If you disallow remote connections on your SQL Server, how is the application going to connect to SQL Server?

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 6, 2009 at 9:32 pm

    #1088351

    If you have a local application, like IIS, Dynamics, etc. on the same server, this is fine. Otherwise, as Bru mentioned, you need to allow remote connections for any client to connect to SQL Server from another machine.

    Most SQL Servers (outside Compact/Express) are set up to allow remote connections.

  • December 9, 2009 at 9:15 pm

    #1090336

    Thanks Bru,

    I want know if we disable remote connections on a sql server we cant be able to access sql server from remote machines and apllication will not be able to connect to sql srv. but instead of these are there any impacts if we disable remote access.

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

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