Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    Unanswered: error in connection


    i am trying to connect my application with SQL SERVER. but

    it gives error as below.

    When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Please reply me soon.

    Best regards,

  2. #2
    Join Date
    Jun 2003

    Thumbs up

    U have to enable remote connections in SQL 2005 if u want to connect from remote clients.

    1) Open SQL 2005 Surface Area configuration-->Surface Area configuration for Services and connections -->Database Engine-->Remote Connections-->Enable Local and remote connections.

    2) Enable the protocol from SQl Server Configuration manager which u are using(in ur case 'Named Pipes').
    To do that,
    SQl Server Configuration manager -->SQL server 2005 Network Configuration-->Protocols for SQl2005-->Enabe Named Pipes.
    I love cursor,though I never use it.Cos' I dont want to misuse it.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts