Results 1 to 3 of 3

Thread: MSSQL Issue

  1. #1

    MSSQL Issue


    Recently, I did a migration in my hsphere system from another data center. Everything was transfered except MSSQL data which is still pointing to the old server. Now, since then, nobody can connect to their mssql database (even though it is pointing to the old location) and it gives them the following message: (oh by the way, the new system is on Windows 2003 Server)

    That is the error:

    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.SqlClient.SqlException: SQL Server does not exist or access denied.

    Source Error:

    Line 7:
    Line 8: If Not Page.IsPostBack Then
    Line 9: ThisHit.BindGoogleCatListing(GoogleCatListing)
    Line 10:
    Line 11: End If

    Source File: C:\hshome\was813\\default.aspx Line: 9

    Stack Trace:

    [SqlException: SQL Server does not exist or access denied.]
    System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
    System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
    System.Data.SqlClient.SqlConnection.Open() +384
    netAxle.Hit.GetGoogleCats() +125
    netAxle.Hit.BindGoogleCatListing(Object GoogleCatListing) +175
    ASP.default_aspx.Page_Load(Object Sender, EventArgs E) in C:\hshome\was813\\default.aspx:9
    System.Web.UI.Control.OnLoad(EventArgs e) +67
    System.Web.UI.Control.LoadRecursive() +35
    System.Web.UI.Page.ProcessRequestMain() +731

    PLEASE, any help would be appreciated in telling me what went wrong.


  2. #2
    Join Date
    Mar 2004
    Philadelphia, PA
    Are you running Windows 2003 Web Edition?


  3. #3
    Join Date
    May 2003
    Wilmington, NC

    Do you have the appropriate ports open on your firewall(s)? If so, are the appropriate protocols enabled? Perhaps the old data center will not allow outside access to the SQL server.

    Please feel free to contact me. If I can be of any help, I will certainly try.

Posting Permissions

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