Sql Server does not exit or access denied

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • neoupadhyay
    New Member
    • Feb 2007
    • 57

    Sql Server does not exit or access denied

    Hello friends,

    I am facing a problem at the FTP or Server Side.

    I am using the .net1.1 and sql server, my all connectivity is working okey at the loacl host, but after upload it and hit the website, its show the explicitly call Error Page which we configure in web.config that any error occur, it will display the Error page when we change the config file that do not show the error page then after hiting the website it show the "Sql Server does not exit or access denied".

    So, please any body let me know why this problem occur....
    Please help me

    Thnx
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Originally posted by neoupadhyay
    Hello friends,

    I am facing a problem at the FTP or Server Side.

    I am using the .net1.1 and sql server, my all connectivity is working okey at the loacl host, but after upload it and hit the website, its show the explicitly call Error Page which we configure in web.config that any error occur, it will display the Error page when we change the config file that do not show the error page then after hiting the website it show the "Sql Server does not exit or access denied".

    So, please any body let me know why this problem occur....
    Please help me

    Thnx
    Could you post the exact error message that is given?
    Also can you determine at which stage in the program the error is being thrown.

    Comment

    • neoupadhyay
      New Member
      • Feb 2007
      • 57

      #3
      Originally posted by r035198x
      Could you post the exact error message that is given?
      Also can you determine at which stage in the program the error is being thrown.


      Server Error in '/' Application.
      --------------------------------------------------------------------------------

      SQL Server does not exist or access denied.
      Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

      Exception Details: System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or access denied.

      Source Error:

      An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

      Stack Trace:


      [SqlException: SQL Server does not exist or access denied.]
      System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean& isInTransaction ) +474
      System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction ) +372
      System.Data.Sql Client.SqlConne ction.Open() +384
      test.Components .data.OpenConne ction()
      test.Components .data.GetDataTa ble(String Sql)
      test.main.Page_ Load(Object sender, EventArgs e)
      System.Web.UI.C ontrol.OnLoad(E ventArgs e) +67
      System.Web.UI.C ontrol.LoadRecu rsive() +35
      System.Web.UI.P age.ProcessRequ estMain() +750




      --------------------------------------------------------------------------------
      Version Information: Microsoft .NET Framework Version:1.1.432 2.2407; ASP.NET Version:1.1.432 2.2407


      This is the exact error, and its comes when i hit the website...at the main page

      Comment

      • dhanashivam
        New Member
        • Mar 2007
        • 31

        #4
        check the user name and password which was supplied in the coding.

        and also check the IIS Authentication, whether does it allow to access the database or not.

        regards,
        dhanasekaran.

        Comment

        • debasisdas
          Recognized Expert Expert
          • Dec 2006
          • 8119

          #5
          That might be a Firewall related issue.

          Comment

          Working...