Wrox Programmer Forums
|
BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8
This is the forum to discuss the Wrox book Beginning ASP.NET 2.0 by Chris Hart, John Kauffman, David Sussman, Chris Ullman; ISBN: 9780764588501
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 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 October 28th, 2006, 03:41 PM
Registered User
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Beginning ASP.NET 2.0 Chapter 4 page 111

I am working on Chapter 4, and following the Try It Out for “User Account Configuration” on page 111. When I click on Administer Website and click on the security link it takes me to: http://localhost:1074/asp.netwebadmi...security0.aspx, which last file name is “security0.aspx” the book shows “security.aspx”. This page shows the following:
“There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.”

This enables me to continue the exercise. Could you please tell me what is wrong.
 
Old November 1st, 2006, 01:55 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 105
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to DanM
Default

Hi there,
Well, it looks like Visual Web Developer is unable to contact your database. This is the first point in the book that you've really needed to access SQL Server at all, so i guess we should go with te basics and make sure that it is installed.

If you open your start menu, under All Programs do you have an entry for Microsoft SQL Server Express? If not, please have a look at page 648 of the book for how to install it with VWD. If you rerun the VWD installer it will give you the option to install SQL Server Express but won't download and reinstall VWD.

If SQL Express is installed, let me know and we'll carry on and figure out the next step.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive
 
Old November 1st, 2006, 02:59 PM
Registered User
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Dan,

I have installed on my machine SQLserver 2005 Pro.

Gustavo


 
Old November 5th, 2006, 02:29 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 105
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to DanM
Default

Hi gvecino,

Ah, in that case I'd ask you to have a quick look at http://p2p.wrox.com/topic.asp?TOPIC_ID=50675 which is another thread on this forum showing how to alter your web.config file to make use of a full SQL Server installation rather than SQL Server express.

If you have any problems, with that, let me know.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive
 
Old November 9th, 2006, 06:22 PM
Registered User
 
Join Date: Mar 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Dan I appreciate your help,
I checked Topic ID = 50675, the connecting string is god because I create a new web page and connect with the SqlDataSource.
Basically, I can create a web site and I can connect to a SqlServer database and every thing works fine. But, when I click on the security link of the Web Site Administration Tool it does not connect. It warns me with the following:

“There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

The following message may help in diagnosing the problem: Unable to connect to SQL Server database.”
 
Old November 10th, 2006, 06:46 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 105
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to DanM
Default

Hi there,

Did you install SQL Server 2005 after you installed Visual Web Developer? If so, I think the issue might simply be that the ASPNETDB database isn't there at all. Can you check this please - you should be able to open the SQL Server and see the ASPNETDB database listed there.

If it's not there, I'm afraid that you'll need to do a little work to get it up and running. You'll need to navigate over to http://msdn.microsoft.com/library/de...aght000013.asp and follow the instructions for Using the SqlRoleProvider.

Dan

Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive
 
Old November 28th, 2006, 08:18 AM
Registered User
 
Join Date: Nov 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

I have similar problem as gvecino.
I have installed sql server express with vwd express in the same one time(using installer option to do it automatically).

When I click on Administer Website and click on the security link it takes me to: http://localhost:portno/asp.netwebad...security0.aspx
And I see message like this:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.

When I am trying to refresh the site I am getting different message:

The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 5170 and the SqlException message is: Cannot create file 'C:\WEBSITES\BEGIN\CHAPTER04\APP_DATA\ASPNETDB_TMP .MDF' because it already exists. Change the file path or the file name, and retry the operation. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Creating the ASPNETDB_0806ff56103e4d5cb0e06f8c97a5ab84 database...

And in the folder there really is a database ASPNETDB_TMP.MDF' along with log file.

When I am creating a database in database explorer in the same folder('C:\WEBSITES\BEGIN\CHAPTER04\APP_DATA ) and using the feature to test connection it is showing that every thing is OK – it is connected. After that I am trying to use website administration tool -> security I am getting the same communicate as before.
Additionally when I am trying to connect ( using the database explorer ) the database created by web administration tool it is impossible, I get communicate -logging failed.

I am working on windows 2000 sp4.

ThX for help.


 
Old December 2nd, 2006, 01:36 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 105
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to DanM
Default

Hi there,

Hmm, it's having a problem trying to create a database that's already there. Have you tried deleting the mdf and ldf files for the database it is trying to create and refreshing the page? It might create the page properly after that. Failing that, can you run through the instructions on the Microsoft MSDN page I've mentioned in this thread and see how you get on?

Cheers, Dan


Dan Maharry
Read the feed at http://feeds.feedburner.com/dansarchive





Similar Threads
Thread Thread Starter Forum Replies Last Post
Beginning ASP.NET using C# -- Chapter 2 Eric Smith BOOK: Beginning ASP.NET 1.0 1 October 9th, 2006 02:27 PM
Beginning ASP.NET 2.0 - Chapter 6 - page 196 warren_banks BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 September 2nd, 2006 08:21 AM
Chapter 15, page 648-649 (Beginning ASP 3.0) JB977 Wrox Book Feedback 0 February 16th, 2004 05:27 PM





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