Grid demo broken

[Theo]

I get the following error when trying to view the Grid demo:

The database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NETAJAX Q3 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF' cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.
Could not open new database 'C:\PROGRAM FILES (X86)\TELERIK\RADCONTROLS FOR ASP.NETAJAX Q3 2012\LIVE DEMOS\APP_DATA\NORTHWIND.MDF'. CREATE DATABASE is aborted.
An attempt to attach an auto-named database for file C:\Program Files (x86)\Telerik\RadControls forASP.NET AJAX Q3 2012\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.

Please advise

[Andrey]

Hello,

From Q1 2012 we converted the database files used for demo application to use SQL Server 2008. Most probably the problem you are experiencing is caused by the fact that you are trying to open such database with SQL Server 2005.

Verify that you are using SQL Server 2008 and try again.

Kind regards,
Andrey
the Telerik team

[Andrew]

Theo's error, which is exactly what I am encountering now, manifest itself when loading the RadControls AspNet Ajax Grid demo installed with the RadControls for ASP.NET AJAX Q3 2012 release. Neither of us are trying to open the "northwind.mdf" file in SQL Server 2005 - so your response makes no sense. Is there a file association we need to change / update? I have SQL Server 2008 R2 installed locally.

[Vasil]

Hi Cary,

The demos are using these database file NORTHWIND.MDF. By default the project is configured such way to use the default SQLExpress installed in your machine. If you have installed another SQL server that you want to use open the

C:\Program Files (x86)\Telerik\RadControls for ASP.NET AJAX Q3 2012\Live Demos\Web.config

See the <connectionStrings> and edit them according to the SQL instance that you want to use.

Regards,
Vasil
the Telerik team

[Andrew]

I figured this out almost as soon as I hit the "Reply" button from my previous response, but thank you for taking the time to clarify the issue.

[Matiu]

Hello Telerik.
Im using SQL Server 2012 and I have the same problem.
Im using Q1 2013.
How can I solve my issue?

[Vasil]

Hello Matiu,

To resolve it, change the <connectionStrings> in the web.config as I mentioned in my previous post, according to the name of your instance of SQL server.
Check for some online resources if you are not familiar with the instance names of SQL servers:
http://sqlserver-help.com/2011/06/19/help-whats-my-sql-server-name/
https://www.google.com/search?q=SQL+2012+server+instance+check+name

Currently in the web.config you will see tags like:

<add name="NorthwindConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Northwind.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

They should be changed to something more like:

<add name="NorthwindConnectionString" connectionString="Data Source=.\YourServerName;AttachDbFilename=|DataDirectory|Northwind.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

Kind regards,
Vasil
the Telerik team