I'm a bit new to installing and configuring, well, just about anything regarding databases, so please bear with me.
I'm currently building a couple of ASP.NET MVC 2 sites. I'm following along with the MVCMusicStore tutorial, and am trying to set up user management using ASP.NET's configuration tool. The problem is that ASP.NET can't 'see' the database.
I have SQL Server 2008 installed on my laptop. It's the version which is available on the Web Platform Installer (I believe it's Express). When I try running the aspnet_sqlreg.exe program to set up my user management database, it can't tell that
I'm running any version of SQL Server at all. I get an exception about 'named pipes', and some other things I don't understand at the moment.
Obviously, this is all a bit over my head. Is there an idiot proof guide or tutorial available that describes, step-by-step, how to:
1. Install SQL Server 2008 on a development PC
2. How to configure it to be used by Visual Studio 2010 Professional
3. How to properly upload/modify the db on the production server with what's on the development PC
Essentially, all the things that the ASP.NET tutorials gloss over. Any suggestions, links to documentation, or other nudges in the right direction would be immensely appreciated.
View Complete Post