Error trying to run live demo application installed on my machine.

9 posts, 0 answers
  1. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 14 Aug 2011 Link to this post

    When I try to run the demo website on my machine I get the following error:

    Database 'C:\PROGRAM FILES\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2011\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
    An attempt to attach an auto-named database for file C:\Program Files\Telerik\RadControls for ASP.NET AJAX Q1 2011\Live Demos\App_Data\Northwind.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.


    I have uninstalled and restalled the 2011 ajax version and am still having the same problem. I did install mysql on my machine today and uninstalled sql server 2008, then removed 2005 and reinstalled sql server 2008. Am running vs studio 2010 professional trial.

    Please assist.


    Thanks,


    Steve Holdorf
  2. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 14 Aug 2011 Link to this post

    Also, here is the stack trace:

    Exception Details: System.Data.SqlClient.SqlException: Database 'C:\PROGRAM FILES\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2011\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
    An attempt to attach an auto-named database for file C:\Program Files\Telerik\RadControls for ASP.NET AJAX Q1 2011\Live Demos\App_Data\Northwind.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

    Source Error:

    The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

    1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

      <%@ Page Language="C#" Debug="true" %>

    or:

    2) Add the following section to the configuration file of your application:

    <configuration>
       <system.web>
           <compilation debug="true"/>
       </system.web>
    </configuration>

    Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

    Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

    Stack Trace:

    [SqlException (0x80131904): Database 'C:\PROGRAM FILES\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2011\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.
    An attempt to attach an auto-named database for file C:\Program Files\Telerik\RadControls for ASP.NET AJAX Q1 2011\Live Demos\App_Data\Northwind.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5050218
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
       System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
       System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
       System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
       System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
       System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
       System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
       System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
       System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
       System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
       System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
       System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
       System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
       System.Data.SqlClient.SqlConnection.Open() +125
       Telerik.GridExamplesCSharp.Programming.SimpleBinding.DefaultCS.GetDataTable(String query) +200
       Telerik.GridExamplesCSharp.Programming.SimpleBinding.DefaultCS.LoadData() +26
       Telerik.GridExamplesCSharp.Programming.SimpleBinding.DefaultCS.Page_Load(Object sender, EventArgs e) +24
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
       System.Web.UI.Control.OnLoad(EventArgs e) +91
       System.Web.UI.Adapters.ControlAdapter.OnLoad(EventArgs e) +14
       System.Web.UI.Control.LoadRecursive() +8948986
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
    
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. milos
    milos avatar
    3 posts
    Member since:
    Aug 2011

    Posted 16 Aug 2011 Link to this post

    Hi Steve,  I also have the same error.  I also uninstalled SQL Server 2005 and installed SQL Server 2008 Express but it didn't resolve it.  I couldn't attach the example MDF database due to the write restrictions (I had the same error message as you).  Did you manage to resolve this?  Good luck! Milos
  5. Steve Holdorf
    Steve Holdorf avatar
    119 posts
    Member since:
    Apr 2010

    Posted 16 Aug 2011 Link to this post

    Hi,

    When I create apps that use my Telerik controls they work fine with MySQL. What I am doing is use the on-line internet site example demo to help implement my code. What I did notice is that when I installed the MySQL ODBC connection namespace and dll for Windows it added the MyDB conection to my list of databases in VS 2010 along with the Telerik SQL demo databases. In this case the Telerik databases appear red x'ed out when I open the telerik sample demo solution. I removed all database connections in VS and rebuild your solution. When I run in debug the site comes up but anytime data binding occurs. I still get the error and stack trace. Now, what my dba said is that what I need to do is add myself, owner account, to the security database for SQL server. He is writting a script to help me do this today and I will get back with you once I try this and let you know if it works. If it works I will add the script to my next post. If you find a solution before then please let me know.

    Thanks,


    Steve Holdorf
  6. milos
    milos avatar
    3 posts
    Member since:
    Aug 2011

    Posted 16 Aug 2011 Link to this post

    Hi Steve,

    I just got it to work.  Although I had set the mdf files as writable I didn't realise that the account I was using didn't have "FULL CONTROL". Right click on the folder and go to the Security Tab.  Check that the account you are using has FULL CONTROL.     I also moved the Telerik databases to a backup folder within SQLServer Express and used a stored procedure to do the attaching.

    EXEC sp_attach_db @dbname = N'NorthwindTest',
    @filename1 = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\Northwind.mdf',
    @filename2 = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Backup\Northwind_Log.ldf'

    Good luck!
    Cheers,
    Milos
  7. Ziji
    Ziji avatar
    4 posts
    Member since:
    May 2011

    Posted 17 Sep 2011 Link to this post

    I use only SQL SQLExpress 2008 and no SQL Server or SQL Server Dev installed on my Windows 7 laptop.
    The account running SQLExpress on my laptop is Network Service.
    I had trouble running AJAX Demo as I kept getting above errors for months. I tried many tricks posted here but no luck.
    Finally, I tried to grant Full Conctrol to Network Service on 'C:\PROGRAM FILES\TELERIK\RADCONTROLS FOR ASP.NET AJAX Q1 2011\LIVE DEMOS' folder (NOT the App_Data under it !!!) and the Demo works without any database connection error.
    The important thing is the folder needs the Full Conctrol permission is LIVE DEMOS, NOT App_Data under it !!!
  8. pat
    pat avatar
    1 posts
    Member since:
    Jan 2012

    Posted 25 Jan 2012 Link to this post

    I just copied out of the program files dir into a junk dir and it ran.
  9. Mikkel
    Mikkel avatar
    58 posts
    Member since:
    Aug 2012

    Posted 18 Nov 2014 Link to this post

    I prepended "Initial Catalog=uniquenamehere;" to the connection string, then it worked.

    I also messed with permissions, adding "Everybody" with full permissions to the App_Data folder.

    The connection string now is:

    <connectionStrings>
      <add name="Northwind" connectionString="metadata=res://*/Models.Northwind.csdl|res://*/Models.Northwind.ssdl|res://*/Models.Northwind.msl;provider=System.Data.SqlClient;provider connection string="Initial Catalog=grid-crud;data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\Northwind.mdf;integrated security=True;user instance=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
    </connectionStrings>


  10. Coen
    Coen avatar
    1 posts
    Member since:
    Aug 2015

    Posted 03 Sep 2015 in reply to Ziji Link to this post

    I am using SQLExpress on my PC and encountered the same issue with attaching the Telerik database in the demo. After trying all of the tricks listed here I decided to open SQL Server management Studio as Administrator. I then could attach the database without error.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017