p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: ASP.NET Website Programming Problem-Design-Solution (http://p2p.wrox.com/forumdisplay.php?f=23)
-   -   Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. (http://p2p.wrox.com/showthread.php?t=71981)

Dominik December 28th, 2008 05:59 PM

Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
 
Hi all,

I have a .net 2.0 website that is running on a shared hosting environment. In this database I don't have administrative permission and can't run the tool C:\WINDOWS\Microsoft.NET\Framework\<versionNumber> \aspnet_regsql.exe due to database remote connection restrictions. I am getting the following error, which I have been searching is due to (within a shared environment) not having the database owner name included (instead of 'dbo') within all calls from the provider classes. For what I can see, the 'dbo' prefix is hard coded in build-in SqlMembershipProvider/SqlRoleProvider.

Someone with the same problem can give me some advice?? Otherwise, I'm afraid I have to write a custom membership/role provider.

Thanks in advance,

Dominik.

-----------------------------------------------------------------------------------------

Server Error in '/' Application.
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +1948826
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4844747
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +204
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +175
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
System.Web.Util.SecUtility.CheckSchemaVersion(Prov iderBase provider, SqlConnection connection, String[] features, String version, Int32& schemaVersionCheck) +378
System.Web.UI.WebControls.WebParts.SqlPersonalizat ionProvider.CheckSchemaVersion(SqlConnection connection) +69
System.Web.UI.WebControls.WebParts.SqlPersonalizat ionProvider.LoadPersonalizationBlobs(WebPartManage r webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) +204
System.Web.UI.WebControls.WebParts.Personalization Provider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) +94
System.Web.UI.WebControls.WebParts.WebPartPersonal ization.Load() +103
System.Web.UI.WebControls.WebParts.WebPartPersonal ization.LoadInternal() +23
System.Web.UI.WebControls.WebParts.WebPartManager. OnInit(EventArgs e) +293
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378


Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

zeronexxx December 29th, 2008 03:35 PM

Hi Dominik

I cann't be much help at this very moment because i am still completeing my project which i need to host in a shared server. The hosting also does not provides remote connections.

I am using godaddy's hosting, well they have all the asp membership tables and stored procedure already in my database. I am not sure if i will be able to use.

I was thinking of using LINQ and creating classes for all the tables and then using LINQ's create tables function, i am not sure if it will import the stored procedures.

i think you can export your whole database as script and import it on the web server.

i am not sure if it will work but worth trying.

i will try to post the solution if i get mine working....

thanks

Dominik January 8th, 2009 05:17 PM

Hi again,

Finally, my hosting at aruba.it does not want to run the scripts needed to give the necesary access to my database user, so I still have the same error because my database owner in not 'dbo' which is who all ASP.NET providers call hard coded as prefix. I don't have administrative permission, so I must deal between my hosting restrictions and the Microsoft hard coded implementation solutions.

Has anyone some other solution?

Otherwise, I must overwrite all the providers or try it in a better hosting...

Thanks.


All times are GMT -4. The time now is 11:02 PM.

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