Problem in Connecting Database. error " SQL Server does not allow remote connections."

Last post 05-12-2008 7:46 AM by KelseyThornton. 3 replies.

Sort Posts:

  • Problem in Connecting Database. error " SQL Server does not allow remote connections."

    05-11-2008, 7:36 AM
    • naveenj
    • Joined on 07-02-2007, 9:09 AM
    • India
    • Posts 538

    Hi Forum,

    Heres the scenario.

    I have VS2008 and SqlServer Enterprise Edition installed in my machine.

    I connect to the database inside the same machine using VS2008.

    I opened the project my client gave me inside vs2008.

    When I ran the project, the it runs.

    but the aspx page to be displayed shows error like

     'Problem in Connecting Database. error " SQL Server does not allow remote connections." '

    I have db and vs in the same machine ( no remote machine involved).

    Why does this error came?

    How to Rectify it?

    Any guidelines are deeply appreciated.

     

      

    Regards,
    Naveen

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    If this solution doesn't solve your problem, just feel free to mark it as not answer and reply.
  • Re: Problem in Connecting Database. error " SQL Server does not allow remote connections."

    05-11-2008, 7:54 AM
    • Loading...
    • KelseyThornton
    • Joined on 07-15-2007, 8:01 AM
    • Breda, The Netherlands
    • Posts 174

    Check your web.config file and make sure that the database connection string doesn't refer to a remote machine...

    Kelsey Thornton
    (In the Netherlands)

    Don't forget - Mark the post which answered your question with "Answer", then that user will get some kudos, and your post will be marked as "Answered" for future readers!
  • Re: Problem in Connecting Database. error " SQL Server does not allow remote connections."

    05-12-2008, 3:04 AM
    • naveenj
    • Joined on 07-02-2007, 9:09 AM
    • India
    • Posts 538

    Hi KeleyThornton,

    No it is not so.

     

    Regards,
    Naveen

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    If this solution doesn't solve your problem, just feel free to mark it as not answer and reply.
  • Re: Problem in Connecting Database. error " SQL Server does not allow remote connections."

    05-12-2008, 7:46 AM
    • Loading...
    • KelseyThornton
    • Joined on 07-15-2007, 8:01 AM
    • Breda, The Netherlands
    • Posts 174

    Shame - that is  aproblem I have runinto myself before now...

    You say that the project works in VS, but not when you run it from IE?

    that would maybe imply that hte SQL server is treating ISS as "external"?!?

    Kelsey Thornton
    (In the Netherlands)

    Don't forget - Mark the post which answered your question with "Answer", then that user will get some kudos, and your post will be marked as "Answered" for future readers!
Page 1 of 1 (4 items)