Post reply

When I connect Remote SQL Server Getting Error "This Failure may be caused by fact that Under Default setting , SQL Server does not allow reote connection,Provider -Named Pipe Provider : Eroor 40, Cound not open connection SQL Server "

  • November 13, 2008 at 12:12 am

    #125894

    When I connect Remote SQL Server Getting Error "This Failure may be caused by fact that Under Default setting , SQL Server does not allow reote connection,Provider -Named Pipe Provider : Eroor 40, Cound not open connection SQL Server "

    I got many times, this error, sometime server was sucessfuly connected..

    Please refer attached File for error page....

    Please do needfull for solution....

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 13, 2008 at 12:31 am

    #897913

    Go to surface area configuration as shown and configure there.

    DBDigger Microsoft Data Platform Consultancy.

  • November 13, 2008 at 3:05 am

    #897948

    If this does not sort the problem, check the obvious, is MSSQL service running?.

    Had the same error message this morning, turned out that the service had failed to start after a reboot.

  • November 13, 2008 at 10:07 pm

    #898399

    Thanks guy,

    can u tell u why required TCP/IP and Named Pipes in SQL server?.... for my info.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 13, 2008 at 10:47 pm

    #898403

    [font="Verdana"]It looks like SQL Server or Instance you are trying to connect is either stopped or it doesn't exists. Make sure its running fine.

    TCP\Ip & Named pipes are protocol to connect from remote machines. If you turn off these protocols you won't be able to connect to SQL server.[/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • November 13, 2008 at 11:51 pm

    #898417

    I want to know , if i enable only named piped then what hapopen, and enable only tcp/ip than what happen? means what indiavidual purpose of both protocol?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 14, 2008 at 12:24 am

    #898427

    It depends upon application or setting of tool that you are using. If you have configured to use named pipes then it should be enabled obviously. And same for TCP/IP. Both are protocols with slight pros and cons for SQL Server environment.

    DBDigger Microsoft Data Platform Consultancy.

  • November 14, 2008 at 4:54 am

    #898483

    I have face same problem again, I have tried to open remote sql server from one local machine i did not got..and i was got same error as attachement i hich i have ulploded ,

    error :

    "This Failure may be caused by fact that Under Default setting , SQL Server does not allow reote connection,Provider -Named Pipe Provider : Eroor 40, Cound not open connection SQL Server "

    and tried from another local machine then sucess..and also both protocols are enable(tcp/ip and named pipe).

    What is reason for that, some time sucess and sometime failed to connect?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

Viewing 8 posts - 1 through 7 (of 7 total)

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