Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional 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
  #1 (permalink)  
Old November 11th, 2010, 07:55 PM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Cannot run website administration tool

Hi

I'm trying to run the website admin tool. When I click on the security tab I get an error message that the tool could not connect to the server. It suggests that I run the aspnet_regsql utility, but I keep getting the message database creation failed

What do I need to do to get this to work

Tom
__________________
Thomas G Magaro
  #2 (permalink)  
Old November 12th, 2010, 03:13 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi Tom,

The tool by default assumes you have a locally installed SQL Server instance called .\SqlExpress. Is that the case on your machine?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #3 (permalink)  
Old November 12th, 2010, 09:19 AM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default re: asp.net administration tool

Hi Imar,

Yes, I do have Sql Server 2008 express addition. I am using VS 2005.

Tom
__________________
Thomas G Magaro
  #4 (permalink)  
Old November 12th, 2010, 10:54 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

But is your SQL Server instance called .\SqlExpress? Can you connect to it using SQL Server Management Studio? And which error message do you get exactly when you run the regsql tool? You shouldn't have to use this tool when you .\SqlExpress and rely on the automatic creation of the database.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #5 (permalink)  
Old November 12th, 2010, 01:25 PM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Back at you

I am able to connect using management studio. However, I have been able to successfully register asp with sql

Thanks for the help

Tom
__________________
Thomas G Magaro
  #6 (permalink)  
Old November 12th, 2010, 01:44 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
I have been able to successfully register asp with sql
Not sure what you mean with that. In order to help you, we need lots more information, including the steps you're following (in detail) and the errors you're getting.

What hapens when you try this:

1. Create a new Web Site using File | New Web Site

2. Add a Login control to Default.aspx

3. Open the page in your browser and try to log in, Obviously the login won't succeed because there are no user accounts, but ASP.NET should create the database for you or give you an error message.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #7 (permalink)  
Old November 12th, 2010, 02:34 PM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Still getting error

Hey Imar,

I had already renamed the default.aspx to SignOn.aspx, so I added another default.aspx, didn't work. I added myself as a user of the database with full blown read/write access. Still nothing.
It continues to give me the same answer when I try to click on the secuity tab. The first error says unable to generate user instance, and the second message when I try to test the provider says that I need to run the aspnet_regsql again.

__________________
Thomas G Magaro
  #8 (permalink)  
Old November 12th, 2010, 02:52 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Hi there,

I am sorry but you really have to be more specific and detailed, or this is not going to work. For example:

Quote:
I added myself as a user of the database with full blown read/write access.
Where? How? To which database? Attached to SQL Server or in App_Data? In the latter case, how did it get there?

Quote:
I had already renamed the default.aspx to SignOn.aspx, so I added another default.aspx, didn't work.
So you didn't try out the steps I suggested by creating a brand new site? Also, what is "didn't work"?
Quote:
The first error says unable to generate user instance
If you can't be explicit and post the exact error message I asked for here, then at least copy and paste the erron in Google. There are many posts related to issues like this.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #9 (permalink)  
Old November 12th, 2010, 03:13 PM
Authorized User
Points: 222, Level: 4
Points: 222, Level: 4 Points: 222, Level: 4 Points: 222, Level: 4
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2007
Location: Phoenix, AZ, USA.
Posts: 48
Thanks: 4
Thanked 0 Times in 0 Posts
Default Sorry about that

Hey Imar,

I added myself as a user to aspnetdb and gave myself read/write access to the database using SQL Server Management Studio.

I meant that when I tried running the configuration tool, I got the same messages.

I already had a website in progress, so I thought I might be able to use it.

I'll try the new site idea and get back to you.


Tom
__________________
Thomas G Magaro
  #10 (permalink)  
Old November 12th, 2010, 03:20 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
I added myself as a user to aspnetdb and gave myself read/write access to the database using SQL Server Management Studio.
You shouldn't have to, as a new database is create on the fly in App_Data by default.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!


Similar Threads
Thread Thread Starter Forum Replies Last Post
Administration tool question kherrerab ASP.NET 2.0 Professional 0 February 9th, 2007 10:16 AM
Help! Website Administration Tool Problem agf2309 ASP.NET 2.0 Basics 2 August 29th, 2006 07:25 AM
Web Site Administration tool steffteo ASP.NET 2.0 Basics 2 March 18th, 2006 05:06 AM
security tab in Administration Tool m_gorbani ASP.NET 2.0 Basics 0 March 8th, 2006 07:08 AM





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