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

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!

Hi Imar,

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

Tom

__________________
Thomas G Magaro

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!

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

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!

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

Hi there,

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

Where? How? To which database? Attached to SQL Server or in App_Data? In the latter case, how did it get there?

So you didn't try out the steps I suggested by creating a brand new site? Also, what is "didn't work"?
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!

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

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!