Forums (Obsolete)

Technical support This forum is closed.

Version 1.x > Technical support > VS2005/SQL Server 2005 Project

View modes:

Guest

norashlea - 3/9/2006 4:57:13 AM

VS2005/SQL Server 2005 Project

I'm just starting to use VS2005 for CMSDesk, and finding it significantly different to VS2003. I've tried twice to create and run a site, but failed both times. The projects are created ok, but I can't run the sites. Both times, I created them as site root projects using the web-installer:

-- First time, I selected to create the database as the project was created.
-- Second time, I selected the recommended "Create database through application"

If I try to run http://localhost, I get an error:

"A name was started with an invalid character. Error processing resource 'http://localhost/'. Line 1, Position 2

<%@ Page Language="C#" Inherits="ncg.defaultMain" CodeFile="default.aspx.cs" %> -^"

Looking at the html and the code of default.aspx, there's no "-^" anywhere.

If I try to run them from within VS2005, it fails on Line 99 of App_Code/Global.asax.cs:

"Kentico.CMS.UrlRewritingEngine.UrlRewriter.RewriteUrl( Functions.GetConnectionString() );"

with the error: "Failed to map path '/CMSDesk/Metadata'.

web.config has all the default configurations, entered as the project is created:

<add key="CMSMetadataFolder" value="/CMSDesk/Metadata" />
<add key="CMSFilesFolder" value="" />
<add key="CMSParentFrameName" value="application" />
<add key="CMSWebSiteBaseAliasPath" value="" />
<add key="CMSUseFriendlyURLs" value="true" />
<add key="CMSWebApplicationVirtualPath" value="/" />
<add key="CMSDefaultAliasPath" value="/home" />

I've followed the setup procedure in the pdf tutorial for VS2005. Can you tell me if there's some other more specific documentation for VS2005?

Thanks,

Sharon.


Guest	admin - 3/9/2006 6:22:12 PM Re: VS2005/SQL Server 2005 Project Hi Sharon, let's try to open the web site in VS 2005 first. In order to do that, you will need to set up the project so that it uses the IIS instead of the local web server. You can do that in WebSite -> Start Options... -> choose "Use Custom Server" and specify http://localhost. Please let me know if it helps. Best Regards,

Guest

norashlea - 3/9/2006 8:41:16 PM

Re: VS2005/SQL Server 2005 Project

Aha, that was frustrating me a bit, trying to figure out how to run using standard localhost. Thanks.

But no joy yet :o( I get "Server Application Unavailable"! and if I change the active site back to another asp.net 1.1 project I get the same error until I run iisreset. I think the issue is something to do with installation of asp.net 2.0 and/or SQL Server 2005.

On my dev machine, I previously had VS2003 and asp.net 1.1 installed together with the Express versions of 2005 and whatever version of asp.net 2.0 is installed with them. I had done a very quick test project for CMSDesk a few months ago, and I know it was running OK. I had also installed the MS TimeTracker project, and that was running OK too.

Last week I got the full VS2005 and SQL Server 2005 Standard package, so before installing made sure I completely uninstalled all the Express versions first - including asp.net 2.0. Then I just went through the default installation for VS2005.

Now I can't run the MS TimeTracker project either, and get a SQL Server connection error. When I test the TimeTracker connection using the ASP.net Web App Admin utility, I get "Could not establish a connection to the database".

Member

Member

argodev - 3/9/2006 11:50:52 PM

Re: VS2005/SQL Server 2005 Project

It looks like, from your last post, that you have eliminated Kentico as your problem as you have demonstrated the "problem" using other applications other than Kentico.

I'm guesing that, based on what you described in your post, that you are seeing the problem on a box running Win2K3 and IIS 6 with multiple applications on it (some running asp.net 1.1 and others running asp.net 2.0) yet only having one app pool. I'm guessing that if you looked at the event viewer you would see some error about not being able to run two versions of the .NET framework in the same application pool. If this is indeed the case, create a new app pool dedicated to 2.0 apps, configure those vdirs etc. to run asp.net 2.0 (via the ASP.NET tab) and also configure them to run in the newly-created app pool (via the Home DIrectory tab)... that should help some...

Guest

norashlea - 3/10/2006 12:02:06 AM

Re: VS2005/SQL Server 2005 Project

Well, except that I'm running on XP sp2, the rest of the configuration is pretty much as you've described. And, yes, checking the Event Viewer, the error recorded when I try to run the 1.1 app after trying to run the 2.0 app (before running iisreset) is exactly as you've described.

I will look further into setting it up to run both versions. I know that it must be possible in XP, because I had it running perfectly (probably just by fluke) when I was running the Express versions. This problem has only emerged after I uninstalled all the previous stuff and then installed the full Standard version.

Thanks for the pointer,
Sharon.

Guest

admin - 3/10/2006 7:09:14 PM

Re: VS2005/SQL Server 2005 Project

Hi Sharon,

you might want to set up a new web site using IISAdmin, run it, switch it to ASP.NET 2.0 and then deploy some very simple "Hello world" .NET 2.0 application on this web site to make sure that it's configured correctly.

The issue with SQL Server connection may be caused by SQL Server 2005 default configuration that doesn't support TCP/IP connections. You may need to enable them.

Best Regards,

Guest

norashlea - 3/11/2006 2:19:49 AM

Re: VS2005/SQL Server 2005 Project

Thanks for the help, all. Have got it sorted out at last. Two issues:

1. ASP.net 2.0 had not been registered properly
2. Had to reinstall SQL Server 2005, as the network connections hadn't been installed, so I didn't even have the option to enable tcp/ip.

I'm still having a bit of connection issue trying to create a database in a new 2.0 web application (still says it can't find the server), but at least I can run the projects that I created with the Kentico Web Installer OK, and at this point it's only these ones that I need to work on in 2.0 anyway.

Thanks,
Sharon.


Member	steve - 3/15/2006 1:45:25 PM Re: VS2005/SQL Server 2005 Project I had the same issue with (vs2005 / SQL Server 2000 / Windows 2003) and changing the entry of <add key="CMSMetadataFolder" value="/CMSDesk/Metadata" /> to <add key="CMSMetadataFolder" value="~/CMSDesk/Metadata" /> fixed it. Steve

Guest

admin - 3/15/2006 2:04:50 PM

Re: VS2005/SQL Server 2005 Project

Hi Steve,

Thank you for your post. I must say that we haven't tested the ~/cmsdesk/metadata. If it works for you, it's great. If you still encounter any problem, you may want to change it to "/kenticocms/cmsdesk/metadata" where /kenticocms is the name of the sub-folder (virtual directory) where you installed Kentico CMS.

Best Regards,

Top