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.

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

Thanks Dan,

I have installed on my machine SQLserver 2005 Pro.

Gustavo

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

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.”

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

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.

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