Member Avatar for fmardani

Hi,
I have made the necessary changes in the web.config so that I can get to the security Tab for the
ASP.NET configuration.
The new error when trying to go to the security Tab is:

The following message may help in diagnosing the problem: Could not find stored procedure
'dbo.aspnet_CheckSchemaVersion'.

At present I have started the shopping site to work ok, but I can not get to the security Tab.

<connectionStrings>

<add name="BalloonShopConnection"
connectionString="Data Source=servername\servername;Initial Catalog=BalloonShop;User
Id=sa;Password=password1"
providerName="System.Data.SqlClient"/>

<!--This allows you to access the Security Tab under WebSite, ASP.NET Configuration-->
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=servername\servername;Initial
Catalog=BalloonShop;Persist Security Info=True;User ID=sa;Password=password1"
providerName="System.Data.SqlClient" />
</connectionStrings>

Any thoughts please?
Thanks

  • 3 Contributors
  • 2 Replies
  • 142 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by f1 fan

Dani AI

Generated

This error is coming from the VS2005 Web Administration tool (the "ASP.NET Configuration" security tab) rather than the IIS UI. As hinted, that tool talks to the ASP.NET membership/role/profile schema and calls the helper stored procedure that verifies schema version. As pointed out, the IIS management UI is different and will not show the same security dialog.

Checklist and practical steps to resolve the missing-procedure error:

  • Confirm which database the membership provider is actually using (the provider's connectionStringName in web.config). The admin tool will try to use that connection to find the ASP.NET objects.

  • From SQL Server Management Studio (or Query Analyzer) verify whether the verification stored proc exists:

-- SQL Server 2005+
SELECT * FROM sys.objects
WHERE name = 'aspnet_CheckSchemaVersion' AND type = 'P';

-- SQL Server 2000
SELECT * FROM sysobjects
WHERE name = 'aspnet_CheckSchemaVersion' AND xtype = 'P';

  • If the procedure/tables are missing, run the ASP.NET SQL registration tool for .NET 2.0 to install the membership schema. On a typical machine run:

    C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe

    Use the wizard (or run it with appropriate credentials) and target the application database. Back up the database before applying any schema changes.

  • If the objects exist but are owned by a non-dbo user, re-run aspnet_regsql using a login with dbowner rights or change the object owner so the caller can find them under dbo. Also ensure the SQL login in the connection string has EXECUTE permissions on the aspnet* stored procedures.

  • After changes, recycle the app pool or restart Visual Studio so the web.config overrides are reloaded.

Caution: running aspnet_regsql modifies the target database (adds tables, procs). Back up the DB first and perform these changes in a test environment if possible.

Recommended Answers

All 2 Replies

Member Avatar for kedar_challa

Hi,

exactly i didnt get what ur trying to do. Where ur not getting the security tab. If it is in the ASP.Net add-in to the IIS manager, then we don't have security tab there.

it will show you the Authorization and Authentication tabs.

Regards,
Kedar

Member Avatar for f1 fan

I think he is on about the web admin page that comes with VS2005. Which is just a simple interface to both the webconfig and any providers.

But i am not sure of what is missing or the rest of the web config? some light would help

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.