Visual Studio 2005

Re: Internet Explorer cannot display the webpage

mikehac — Wed, 01 Jul 2009 06:53:01 GMT

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

Re: Internet Explorer cannot display the webpage

geosync — Thu, 23 Apr 2009 01:46:48 GMT

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:

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

Re: Internet Explorer cannot display the webpage

Thomas Sun – MSFT — Fri, 17 Apr 2009 09:11:50 GMT

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.

Re: Internet Explorer cannot display the webpage

geosync — Fri, 17 Apr 2009 01:13:31 GMT

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.

Re: Internet Explorer cannot display the webpage

geosync — Fri, 17 Apr 2009 00:55:21 GMT

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?

Re: Internet Explorer cannot display the webpage

vinz — Wed, 15 Apr 2009 21:45:06 GMT

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

Internet Explorer cannot display the webpage

geosync — Wed, 15 Apr 2009 14:47:59 GMT

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?