Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > BOOK: Professional ASP.NET MVC 2
BOOK: Professional ASP.NET MVC 2
This is the forum to discuss the Wrox book Professional ASP.NET MVC 2 by Jon Galloway, Scott Hanselman, Phil Haack, Scott Guthrie, Rob Conery; ISBN: Professional ASP.NET MVC 2
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional ASP.NET MVC 2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old December 14th, 2010, 01:46 PM
Registered User
Join Date: Dec 2010
Posts: 8
Thanks: 6
Thanked 2 Times in 2 Posts
Unhappy Using Full SQL Server instance instead of SQL Server Express

Hello All,
I have used the full SQL Server instance instead of the SQL EXpress version that the book used. Now I can't use or take advantage of the login and registration forms in order to continue working on the tutorial on page 110.

My question is how do I use my FULL SQL SERVER INSTANCE to take advantage of the codes and forms come with MVC 2 (NerdDinner) starting project?

I know I have to make some changes in the "web.config" file but I don't really know what the connectionString entails. Part of the reason is that the original database file was automatically created when I created this project due to not having the SQL express on my machine.

Any idea ?

Thank you!
Old December 14th, 2010, 02:22 PM
Friend of Wrox
Join Date: Oct 2010
Posts: 106
Thanks: 1
Thanked 17 Times in 17 Posts

I havent tried that yet. But I think you're on the right track. This is what I would do... First, figure out the web.config changes (google sql connection string). Don't mess with log-in stuff until you get this to work.

Then lookup asp.net configuration tool. asp.net configuration is launched from an icon in solution Explorer that looks like a globe and a hammer. This is where you set up user(s) and roles. As I recall, it was not mentioned in the book. Turn on roles, create an admin user as well as a non-admin user.

One question though, why aren't you using SQL Express? I would suggest using it to get through chapter 1. And then later adjust it. Just focus on getting through chapter 1.
The Following User Says Thank You to flyinhawaiian For This Useful Post:
lagonave (December 17th, 2010)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Questions about SQL Server 2005 and SQL Server Express Edition 2005 gfmann BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 1 May 24th, 2009 09:36 AM
SQL Server 2005 vs SQL Server Express Rachel BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 May 9th, 2009 01:08 PM
Upgrade SQL Express to SQL Server timeware SQL Server 2005 2 August 27th, 2007 02:37 PM
VB Express and SQL server on remote server questio HoosierDaddy61 Visual Basic 2005 Basics 0 February 22nd, 2006 11:27 AM
Accessing a SQL Server Express DB thru VB Express djelavic SQL Server 2005 2 February 21st, 2006 07:53 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.