Unable to create new Orchard site with Visual Studio 2010

Topics: Installing Orchard
Jul 4, 2012 at 11:07 AM

I'm trying to setup new Orchard 1.4 with Visual Studio 2010 and MS SQL Server 2008. After specifying site name, user name, password and the connection string, I pressed Finish Setup and got the following error:

 

Setup failed: could not execute query
[ SELECT top 2 this_.Id as Id31_0_, this_.Name as Name31_0_ FROM Orchard_Roles_RoleRecord this_ WHERE this_.Name = @p0 ]
Positional parameters: #0>Anonymous
[SQL: SELECT top 2 this_.Id as Id31_0_, this_.Name as Name31_0_ FROM Orchard_Roles_RoleRecord this_ WHERE this_.Name = @p0]

 

Any ideas, pls

Coordinator
Jul 5, 2012 at 5:56 AM

Bad connection string?

Jul 5, 2012 at 6:30 AM

No, I can reach the empty database with the login and password using MS SQL Management Studio.

Coordinator
Jul 5, 2012 at 7:13 AM

I'd start over, making sure that IIS is configured correctly, with the app pool running asp.net 4.0.

Jul 5, 2012 at 9:05 AM

I use Visual Studio 2010 in debug mode, so I'm sure that IIS is configured correctly.

Coordinator
Jul 5, 2012 at 9:08 AM

Where did you download Orchard? Any modules you added? What recipe did you use? Are you sure the connection string you used gives unlimited access to that database?

Jul 5, 2012 at 10:41 AM

Orchard.Source.1.4.0.zip was downloaded from Codeplex. 

Default recipe.

There are 46 Modules in the project.

The user mentioned in the connection string is a db_owner.

Developer
Jul 5, 2012 at 10:20 PM

Does it work when you use SQL CE? (try that when starting over). Just as a test.

Jul 6, 2012 at 6:28 AM

Yes, it work with SQL CE perfectly.

Developer
Jul 7, 2012 at 1:00 AM

Then it's definitely a problem with the connection to the SQL Server database. Fire up your debugger (enable the "Thrown" checkboxes for "Common Language Runtime Exceptions" and "Managed Debugging Assistants") and you should be able to find out what exactly is causing the issue.