I've been using VS 2005 for 2 1/2 years.  Yesterday, I uninstalled / reinstalled SQL Server 2005.

Now, I can't debug/run the website project I've been developing:

"Internet Explorer cannot display the webpage"

The startup page is specified as default.aspx, and this page exists. 

The TimeTracker starter kit works ok.  So there's something about my web app project;  I don't know what...

Could someone please give me some guidance on restarting my development project?

Please try to check this thread: http://forums.asp.net/p/1356920/2787194.aspx

Thanks, vinz. 

The web app starts if I use a different project Start Page.

Then, I saw this error:

     Cannot open database "..." requested by the login. The login failed.
     Login failed for user 'MAIN\ASPNET'

I can add ASPNET as a user to the database. 

But will I have to add ASPNET as a user to each future database, too?  Is there a better way?

Now I'm getting a series of errors that start with this:

"The EXECUTE permission was denied on the object..."

For example:

     The EXECUTE permission was denied on the object 'aspnet_Membership_GetAllUsers', database...

So I grant execute permissions to each object where an error occurs; but what is happening here?  I reinstalled SQL Server, and now I need to grant permissions where I never had to before.

This is making me crazy.

Hi,

For the Login failed for user 'MAIN\ASPNET' error, you also can use SQL Server Authentication to login server. To do so, we need UserID and Password to connect database. The connection string should look like "Server=YourServerAddress;Database=YourDataBase;Uid=YourUsername;Pwd=YourPassword;"

For more information, see http://www.connectionstrings.com/?carrier=sqlserver2005

geosync:

Now I'm getting a series errors that start with this:

"The EXECUTE permission was denied on the object..."

The error message above indicates the user doesn't have execute permission on these objects. When you add user (in this case, it is 'MAIN\ASPNET'), you also need to grant proper permissions to it. You can use Grant T-Sql (http://msdn.microsoft.com/en-us/library/ms188371(SQL.90).aspx).

For testing, you also can use other account of SQL Server, such as SA, to connect database in your web application.

I look forward to receiving your test results.

Thomas,

Thank you for your this valuable information.  But, there is something I don't understand:

1. The web.config of my web app always includes this line:

    <add name="LocalSqlServer" connectionString="Server=localhost;Database=DSAT;Trusted_Connection=True;" />

2. I'm using the same .MDF file as before I reinstalled SQL Server 2005.

I think the only thing that changed is the installation of DB engine.

Why would I need to change any database permissions after reinstalling SQL Server 2005?  Why doesn't everything work like it did before I reinstallled SQL Server 2005?

Something must be different about how I reinstalled SQL Server 2005.  What could it be?

Thanks again

geosync:

Now I'm getting a series of errors that start with this:

"The EXECUTE permission was denied on the object..."

For example:

     The EXECUTE permission was denied on the object 'aspnet_Membership_GetAllUsers', database...

So I grant execute permissions to each object where an error occurs; but what is happening here?  I reinstalled SQL Server, and now I need to grant permissions where I never had to before.

This is making me crazy.

I think,that I had same problem,so I tried to grand permition to every object(actually there was a couple of stored procedures that throw these exceptions),but after that I just added ASPNET user to my database(MyDB/Securety/Users new user)

and the problem has disappeared