lost database with VISTA

Last post 02-21-2007 8:49 PM by Parley. 1 replies.

Sort Posts:

  • lost database with VISTA

    02-19-2007, 11:45 AM
    • Member
      15 point Member
    • Parley
    • Member since 02-07-2005, 5:26 AM
    • Posts 69

    When I installed VISTA, it made it appear that I had two databases of the same name.  One as c:\documents and settings\Ley\My Documents\My Web Sites\ClubWebSite1\App_Data\ASPNETBB_Parley.MDF and another as Desktop\Ley\Documents\My Web Sites\ClubWebSite1\App_Data\ASPNETDB_Parley.MDF.  I realized what was happening - two separate paths to the same file - and moved the site to a new location in which there would only be one path.  I deleted the old location but that did not solve the problem.  Now when you run ASP NET CONFIGURATION, I get the following message: 

    'C:\Documents and Settings\Ley\My Documents\My Web Sites\ClubWebSite1\App_Data\ASPNETDB_Parley.MDF' already exists. Could not attach file 'C:\WebPages\lkwdfirstlions\App_Data\ASPNETDB_Parley.MDF' as database 'ASPNETDB_Parley'.

     

    I guestion is "how can the ClubWebSite1 still exist?  I deleted the folder, files and all."  SQL thinks its still there!

     

    I had a hard time finding aspnet_regsql.exe.  I ran it and it reports:

     

    System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  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)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,

    and so forth

     

    Thank heavens the hosted site is still running correctly, but I can not run the site on my machine.

  • Re: lost database with VISTA

    02-21-2007, 8:49 PM
    • Member
      15 point Member
    • Parley
    • Member since 02-07-2005, 5:26 AM
    • Posts 69

    More information.  I am still down.  Everything works as it should.  I can call up a copy of the portal and it will run until, I change the database's name to "ASPNETDP_Parley.MBF" at which time it fails, reporting that there is a second copy with the same name in the deleted folder.  I even tried undeleting the folder and deleting the database with webdeveloper.  Still it says there is a second database at that location.  I deleted the folder again.  Still a second database at that location.  It must be something to do with SQL.  I tried runing SQL but could not attach to anything.  I tried uninstalling SQL and WebDebeloper and then re-installing them.  Still the same problem.  The simple solution would be to rename the database, but the hosted version is running okay as is and I would not like to rename the database on the host.  It was hard enough the first time.  Is there anyone out there with some answer?

     

     

Page 1 of 1 (2 items)