Post reply

problem arises when i connect it to MSDE

  • September 5, 2005 at 3:45 am

    #165875

    Hello friends

    I have sql server in PC now I want to connect another PC which has sqsql server 2000 but problem arises when  i connect it to MSDE

     

    what might be problem for that ??

    T.I.A

    Shashank

    Regards,

    Papillon

  • September 5, 2005 at 5:49 am

    #587551

    What problem is it giving you?



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • September 6, 2005 at 6:44 am

    #587759

    When you install MSDE, you must specify the DISABLENETWORKPROTOCOLS=0 command line option to setup.exe to allow network access.

    To rectify this after installation, run the server network configuration utility for SQL (C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe by default).  Enable the TCP protocol (maybe named pipes as well) and this might fix your problem.  If you had no protocols enabled, then SQL won't be accessible to other machines across the network.

    Cheers!

  • September 6, 2005 at 9:46 pm

    #587990

    Hey !!!

     

    Thats worked fine!!!

     

    Regards

    Shashank

    Regards,

    Papillon

  • September 6, 2005 at 10:59 pm

    #587993

    No probs - glad to help!

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

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