Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How i do networking with SQL server 2005

Answered How i do networking with SQL server 2005

  • Monday, October 31, 2011 5:34 PM
     
     
    Sign In to Vote
    0

    hello sir

                i m using Nrega Software in Front end and using SQL server 2005 in back end.i want to run Nrega software in two system connect by networking but there database store only in one computer. i have little bit idea i use cleient server method.but i don't know how i do so.pls tell me in details and stepwise.pls

    it is very urgent

    thanks in adv. pls help me

    regards

    RAHUL

     

All Replies

  • Wednesday, November 02, 2011 4:45 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi RAHUL,

    It seems that you are trying to connect to SQL Server instance remotely. First, you should enable remote connection on SQL Server. For more information, please follow the steps on this KB article: How to configure SQL Server 2005 to allow remote connections.

    For connect to SQL Server on the client, please use the method as locally, just replace ‘local’ or ‘.' to server name or IP address. For example: Servername\Instancename (named instance), Servername(default instance).

    Best Regards,
    Stephanie Lv

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.