Can't get started

Old Pedant · October 4th, 2008, 01:44 PM

Ahhh...I thought steps 6, 6 (<grin>), and 7 were done by VWD or VS, but same net effect.

When I said I didn't know how it worked (at all, not just my mistaken impression), I was referring to the WROX demo he said he first tried.

Does that demo also just depend on the <asp:login> and the same sequence of steps?? Never saw the demo, so of course I don't know.

Thanks for stepping in!

I'm betting that SQL Server isn't running on his machine.

Imar · October 5th, 2008, 03:06 AM

No, these steps are done by .NET. If you create a very simple web page with just an <asp:Login /> control on the page, hook it up to IIS and run it, you get a database in App_Data as well.

I don't have that specific book either, so I don't know this demo. I suggested the Login control and trying to log on just to rule out anything else. If a single page with a single login control doesn't work, the problem has to be SQL Server and / or security related.

And I agree: SQL Server is probably not installed correctly or not running. So, I suggest that Shane sends off his visitors and gets back to some serious programming to find out the cause of the problem.... ;)

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

Old Pedant · October 5th, 2008, 02:52 PM

Shane:

FWIW, I'm posting from home, now, and have SQL Server Express (2005, but doubt that matters much) running on this machine.

When I go
CONTROL PANEL ==>>
ADMINISTRATIVE TOOLS ==>>
SERVICES

And then look at the list of services, I see *FOUR* that are SQL Server related:

Code:

Name                                 -- status    -- startup type
SQL Server (SQLEXPRESS)              -- Started   -- Automatic
SQL Server Active Directory Helper   -- [blank]   -- Disabled
SQL Server Browser                   -- Started   -- Automatic
SQL Server VSS Writer                -- Started   -- Automatic

As I read it, you need *AT LEAST* the first and third of those to be STARTED in order to make the SQL Server connection. (Active Directory is only needed if you will use SQL to make LDAP queries, inapplicable on a non-networked machine. VSS Writer is for one kind of backup/restore.)

So if those aren't started, start them.

If they aren't there, your installation is faulty.

shanebbb · October 8th, 2008, 11:16 AM

Imar and "OP", I'm back on it today (visitors left) and for the next while I'll be trying your good suggestions. Thank you again for the help. I'll post later...

shanebbb · October 8th, 2008, 12:51 PM

Imar and Old Pedant,

YES! I successfully installed and got through Appendix B!

I did the following:

1) started the 4 services
2) set up the "NETWORK SERVICE' account
3) deleted the c:\..\..\..\..\Microsoft\Microsoft SQL Server\SQLEXPRESS directory (per the book)
4) rebooted

And when I tried your suggestion to create a simple login screen I no longer receive the "Failed to generate a user instance..." message. Instead, I got an "invalid userid" message. This tells me SQL Server is OK now?

But more importantly, the test at the end of the install (Appendix B) worked fine and the WROX United website came up! So I can proceed.

Thank you both very much for your genuine interest in helping me.

I owe you both a Starbucks....

- Shane

Imar · October 8th, 2008, 01:41 PM

Quote:

quote:Instead, I got an "invalid userid" message. This tells me SQL Server is OK now?

Yes, that's correct. Because .NET created an empty database for you, there won't be a user account, so you can't log in. However, getting this message indicates that ASP.NET could connect to SQL Server and try to find the user....

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

jackSparrow · December 24th, 2008, 01:19 AM

Hi,
everybody , I need your help. I have Visual Studio 2005 professsional edition and Sql server 2005 installed in my office machine. But I am confuse how to starrt the try out sections given in the book, because in Apendix B the details have been given for VWD express edition and sql server express edition. So please help me to sort out the problem.
Thanks in advance.
Bye,
jackSparrow

Imar · December 24th, 2008, 04:58 AM

Hi jackSparrow,

Cross post. For replies please see here:

I want to start the try out's in VS2005 professional edition and Sql sqerver 2005

Imar