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

[Steve Holdorf]

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

[Steve Holdorf]

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

[milos]

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

[Steve Holdorf]

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

[milos]

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

[Ziji]

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 !!!

[pat]

I just copied out of the program files dir into a junk dir and it ran.

[Lasse]

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>

[Coen]

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.