SQL Server 2008 Developper Edition

12 posts, 0 answers
  1. Francois MARTIN
    Francois MARTIN avatar
    44 posts
    Member since:
    Aug 2005

    Posted 20 Dec 2010 Link to this post

    Hi guys,

    this is a minor issue, but I've been thinking about writing about it for... years :)

    The installation of the Telerik ASP.Net Ajax controls is intended to be done on a computer used by a developper. But strangely enough it takes into account only the SQL Express edition for the demo databases, leaving aside the full SQL Server 2008 R2 Developper Edition, which is of course the one generally used (otherwise one is missing the extensions like SQL Profiler, the super usefull tool!!)

    Of course this isn't a difficult issue as one just needs to edit the win.ini file and manually attach the demo databases to the SQL Server instance, but wouldn't it be nice during the installation to detect the SQL Server version present on the computer, or at least to ask if the samples should be installed for SQL Express or the regular SQL Server ?

    Francois
  2. Erjan Gavalji
    Admin
    Erjan Gavalji avatar
    1455 posts

    Posted 20 Dec 2010 Link to this post

    Hi Francois,

    Thanks indeed for the suggestion!
    I'm just not sure if the databases deployed by the demos get used outside the demos themselves.

    With that in mind, the implementation of the demo-databases-to-SQLServer-instance setup would involve the introduction of one more dialog to the installer. That in turn would result in yet another click during setup, which I'm not sure of.

    Let me know your opinion on that. It is most appreciated.

    Kind regards,
    Erjan Gavalji
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Francois MARTIN
    Francois MARTIN avatar
    44 posts
    Member since:
    Aug 2005

    Posted 14 Jan 2011 Link to this post

    Hello there,

    well if I had to choose between another click in while in the install dialog, or manually copying the demo databases, joining them to the instance, and finnaly updating the web.config file, well... I would go for the single click !! :)
  5. Jeff
    Jeff avatar
    6 posts
    Member since:
    Mar 2008

    Posted 16 Jan 2011 Link to this post

    where are the demo databases installed for the Q3 2010 Live Examples.

    I'm using the live examples with my development machine and it has SQL Server 2008 installed with Northwind and Adventureworks sample databases. I get the following error when I select the "



    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Source File: c:\Program Files (x86)\Telerik\RadControls for ASP.NET AJAX Q3 2010\Live Demos\App_Code\SessionDataSource.cs    Line: 238
    Thanks

    Jeff O'Connell

  6. Francois MARTIN
    Francois MARTIN avatar
    44 posts
    Member since:
    Aug 2005

    Posted 16 Jan 2011 Link to this post

    Hi Jeff,

    The error that you are experiencing comes from the fact that the samples are trying to establish a connection with the SQL Server Express edition, and you obviously have the developper edition. You should start by updating the web.config file to correct the connections.
    Here is what I have on my side (just a sample for you):
    <connectionStrings>
        <add name="NorthwindConnectionString" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlClient"/>
        <add name="TelerikConnectionString" connectionString="Data Source=localhost;Initial Catalog=Telerik;Integrated Security=True" providerName="System.Data.SqlClient"/>
        <add name="NorthwindConnectionString35" connectionString="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlClient"/>
        <add name="TelerikConnectionString35" connectionString="Data Source=localhost;Initial Catalog=Telerik;Integrated Security=True" providerName="System.Data.SqlClient"/>
        <add name="NorthwindEntities" connectionString="metadata=res://*;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=Northwind;Integrated Security=True"" providerName="System.Data.EntityClient"/>
        <add name="TelerikEntities" connectionString="metadata=res://*;provider=System.Data.SqlClient;provider connection string="Data Source=localhost;Initial Catalog=Telerik;Integrated Security=True"" providerName="System.Data.EntityClient"/>
        <add name="QSFRatingsConnectionString" connectionString="Data Source=localhost;Initial Catalog=QSFRatings;Integrated Security=True" providerName="System.Data.SqlClient"/>
    </connectionStrings>


    you should have the demo databases in the following directory (if you are using an x64 OS):

    C:\Program Files (x86)\Telerik\RadControls for ASP.NET AJAX Q3 2010\Live Demos\App_Data

    You should manually attach them in SQL Server 2008 if you arn't using the SQL Server 2008 Express edition.

    .... See Erjan ? This is EXCATLY what I was talking about :)
    A simple option in the install procedure would avoid sutch an issue...
  7. Erjan Gavalji
    Admin
    Erjan Gavalji avatar
    1455 posts

    Posted 17 Jan 2011 Link to this post

    Hello Francois,

    Thanks indeed for the heads up and the help!
    I just changed the priority of the task and we will consider a possible implementation and the implications that might arise. Though not sure of when we might be able to add a check for the default SQL server instance to the RadControls installers, I'll do my best to have it for Q2 2011 the latest.

    Kind regards,
    Erjan Gavalji
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  8. Jeff
    Jeff avatar
    6 posts
    Member since:
    Mar 2008

    Posted 21 Jan 2011 Link to this post

    Thank you so much Francois,

    I have since purchased the Telerik and now I'm trying to get the Live Demos to run. I've taken your advice and tried to manually attach the databases, but I'm getting this error:

    -------------------------------------------------------------------------------------------------------------------
    ASPNETDB.MDF
    base 'C:\WORK\DEV\TELERIK.WEB.EXAMPLES\APP_DATA\ASPNETDB.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

    TELERIK.MDF
    Database 'C:\USERS\PEICHEV\DOCUMENTS\QSF\DEV\TELERIK.WEB.EXAMPLES\APP_DATA\TELERIK.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

    QSFRATINGS.MDF
    Database 'C:\WORK\TELERIKWEBUI-TFS\FIXES\2009.Q3.1103\TELERIK.WEB.EXAMPLES\APP_DATA\QSFRATINGS.MDF' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

    NORTHWIND.MDF
    Database 'C:\QSF_LOCAL\DEV\TELERIK.WEB.EXAMPLES\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. (Microsoft SQL Server, Error: 3415)

    what might I doing wrong?

  9. Francois MARTIN
    Francois MARTIN avatar
    44 posts
    Member since:
    Aug 2005

    Posted 22 Jan 2011 Link to this post

    Hi Jeff,

    this is probably a simple Windows right issue. As I guess that you didn't protect you database files to be read-only on purpose (obviously), have you checked the rights ?
    What I mean is this : your SQL Server instance is running with a specific user profile (NT AUTHORITY\LOCAL SERVICE may be ???). Are you sure that this internal Windows user has the right to read / write your database files (check the Windows filesystem rights in the directory C:\WORK\DEV ) ?

    If you want to avoid this kind of issue for the future, I would suggest that you make your own SQL Server development instance run with the NT AUTHORITY\LOCAL SYTEM account, which won't ever hav a "right problem"...

    Francois.
  10. Jeff
    Jeff avatar
    6 posts
    Member since:
    Mar 2008

    Posted 22 Jan 2011 Link to this post

    Francois,
    Once again. Thank You for your assistance with this matter.
    After I sent the post yesterday I was able to figure out that it was a simple Windows file permissions issue that wasn't allowing me to attach the .mdf's in SQL Server 2008
    Then after I was able to attach the files, I started dealing with a lot of login issues with those attached DB instances.

    I'm glad to say that I have finally got the Telerik Demos program all working with the supplied DB files.

    Here's what I had to do:
    Copy the .mdf's from the attached instances and create my own separate DB objects. Once I did that for all four demo databases, I changed the web.config connections to reflect the new instances. Voila!!! It worked.

    Thanks so much for your help Francois!

    You should get beaucoup Telerik points for your assistance!

    Jeff
  11. Francois MARTIN
    Francois MARTIN avatar
    44 posts
    Member since:
    Aug 2005

    Posted 22 Jan 2011 Link to this post

    :)
    I don't know if Telerik will give me "lots of Telerik points", but It was a pleasure Jeff!

    Francois
  12. Erjan Gavalji
    Admin
    Erjan Gavalji avatar
    1455 posts

    Posted 24 Jan 2011 Link to this post

    Hi guys,

    @Jeff, indeed, you're right, I hope you'll find our demos useful!
    @Francois, you can bet on it! Thanks a lot for your help! Please, check your Telerik account :)

    Kind regards,
    Erjan Gavalji
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  13. Roman
    Roman avatar
    2 posts
    Member since:
    Jun 2012

    Posted 23 Jul 2012 Link to this post

    I know this is an old thread but i wanted to chime real quick on the attaching the DB to the developer instance. 
    The error with read-only mdf/ldf is actually due to the fact that program files location is protected and requires a developer to runthe Sql Server Managment Studio Elevated.  Then the files are attached without any issues.

    Thanks

    Roman.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017