Post reply

sql server connection

  • January 4, 2012 at 11:43 pm

    #252992

    hi

    i using sql server 2008 in my local machine..in my window server i installed sql server 2008 R2..when i try to connect that window server (sql server) in my local machine (window xp) its shows error like

    cannot connect to <server_name>

    Addition information:

    Timeout expired..the timeout period elapsed prior to completion of the operation or the server is not responding

  • January 4, 2012 at 11:50 pm

    #1428799

    By default SQL Server does not allow remote connections. You need to enable remote connections.

  • January 5, 2012 at 12:13 am

    #1428803

    ya thanks for ur reply shall u plz tell me briefly how to enable that connection

  • January 5, 2012 at 12:48 am

    #1428814

    EXEC sys.sp_configure N'remote access', N'1'

    GO

    RECONFIGURE WITH OVERRIDE

    GO

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

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